Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

My MySQL Database is Corrupted... What Do I Do Now?

Performing regular database backups is imperative for any production system. Usually when MySQL data gets corrupted, the recommendation is to restore it from the last backup, switch to DR server or take down the affected node down, if you have a cluster, to serve data immediately from other nodes. In some cases you can't - if the backup is not there, the cluster was never set up, your replication is down for a very long time, or the DR procedure was never tested.

How to Go Into Production With MongoDB - Top Ten Tips

Check out some of these top tips for going into production with MongoDB from selecting deployment options through to monitoring solutions.

ClusterControl Tips & Tricks - Using socat on CentOS/RHEL for Streaming Backups

There are several ways to perform remote-to-remote data copy - socat, netcat, rsync, scp, sftp. ClusterControl previously used netcat for remote copy purposes, however we have flipped that decision to use socat. This blog post describes the reasons behind it.

How to Achieve GDPR Compliance: Documenting Our Experience (II)

The journey to compliance continues with Severalnines & the European Union’s General Data Protection Regulation (GDPR).

Tips & Tricks for Navigating the PostgreSQL Community

This blog provides an enthusiasts view into the PostgreSQL development community with tips and resources to helping you get the most out of it.

Updated: ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or ProxySQL.

How to Secure your PostgreSQL Database - 10 Tips

Security is not a game, it is a necessity! In this post we will discuss some common attacks against PostgreSQL server, and how to avoid them.

Pages