Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
111 blog posts in 1 category

PostgreSQL Tuning: Key Things to Drive Performance

This blog provides several high-level tips for getting the most performance out of your PostgreSQL setups.

How to Improve Performance of Galera Cluster for MySQL or MariaDB

Galera Cluster comes with many cool features and advantages over traditional asynchronous replication, but these do not automatically translate into higher performance. In this blog post, we will look at what drives MySQL/MariaDB Galera performance, and see how we can get the most out of the cluster.

Watch the Webinar Replay: MySQL & MariaDB Performance Tuning for Dummies

Tuning a database and the underlying OS is one of the key tasks when managing a database. The goal is to avoid overutilization or underutilization of the available resources.

In this webinar replay, we give you a crash course in performance tuning for MySQL & MariaDB databases.

Schema Management Tips for MySQL & MariaDB

Schema changes are not popular among database ops folks. They can be quite cumbersome in MySQL and MariaDB, and there are risks to the data as well as the availability of the database.

This blog describes the different types of schema change operations you can perform on MySQL and MariaDB, and presents some best practices to minimize disruptions to your operations.

Architecture and Tuning of Memory in PostgreSQL Databases

How does PostgreSQL manage memory, and how can we tune it?
This blog provides an overview of memory management in PostgreSQL, the configuration parameters available, and tips on how to optimize them.

Tuning Input/Output (I/O) Operations for PostgreSQL

PostgreSQL I/O is quite reliable, stable and performant on pretty much any hardware, including cloud.  In this blog, we detail steps you can take to tune the input and outputs of your PostgreSQL database.

Comparing RDS vs EC2 for Managing MySQL or MariaDB on AWS

When managing MySQL on AWS, one has the choice between convenience of a hosting service like RDS, and the control and flexibility of running MySQL on EC2. This blog discusses the difference, with focus on the tradeoffs when using replication.

A Performance Cheat Sheet for PostgreSQL

Performance tuning is not trivial, but you can go a long way with a few basic guidelines. In this blog, we will discuss how you analyze the workload of the database, and then review  a list of important configuration parameters to improve the performance of PostgreSQL.

How to Optimize Performance of MongoDB

A number of factors can negatively affect MongoDB performance - inappropriate schema design, improper or no indexing, inadequate hardware,  replication lag, poor query design. In this blog, we’ll take a look at these different factors and provide tips and tricks to optimize performance.

Decoding the MongoDB Error Logs

This blog provides a high level introduction to the MongoDB error logs, where to find them and how to understand common issues.