Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
579 blog posts in 13 categories

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.

MySQL on Docker: Running a MariaDB Galera Cluster without Orchestration Tools - DB Container Management - Part 2

So you’ve deployed MariaDB cluster on Docker, what next? What do you do when containers fail or are rescheduled, and IP addresses change? How do you ensure that the database adapts to changes to the underlying container configurations? In this follow-up blog post, we’ll look into cluster management and orchestration of Galera cluster on Docker.

Using pg_dump and pg_dumpall to Backup PostgreSQL

pg_dump and pg_dumpall are popular tools used to backup PostgreSQL.  This blog shows you how to use them, with some tips and tricks for ensuring you have a proper backup strategy.

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.

ChatOps - Managing MySQL, MongoDB & PostgreSQL from Slack

CCBot helps you monitor and manage your database Infrastructure from Slack. ChatOps is about bringing your DevOps work to your chats and conversations within a team, e.g. Slack. You can deploy database clusters, get status information, trigger backups, add nodes to your cluster or replication setup by talking to a chatbot, which understands ClusterControl commands.

How to Benchmark Performance of MySQL & MariaDB using SysBench

How can you quickly evaluate performance of a database under intensive load? Welcome to sysbench. This blog gives you a good background of sysbench, and how you can use it to benchmark MySQL and MariaDB.