Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Online Schema Upgrade in MySQL Galera Cluster using RSU Method

Performing RSU - Rolling Schema Upgrade - in a safe way is much more complex than just running a couple of commands. This blog post explains the RSU method for schema changes in Galera Cluster for MySQL, MariaDB Galera Cluster or Percona XtraDB Cluster.

Updated - Full Restore of a MySQL or MariaDB Galera Cluster from Backup

Performing regular backups of your database cluster is imperative for high availability and disaster recovery. This blog post provides a series of best practices on how to fully restore a MySQL or MariaDB Galera Cluster from backup.

Posted in:

Updated - How to Bootstrap MySQL or MariaDB Galera Cluster

Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL or MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. This process is known as cluster bootstrap. Bootstrapping is an initial step to introduce a database node as primary component, before others see it as a reference point to sync up data.

Posted in:

Database TCO - Calculating the Total Cost of Ownership for MySQL Management

This blog post will show you how to calculate the total cost of ownership (TCO) for database servers and how to optimize your cost.

Meet the Severalnines team at M|17 and Percona Live this month

April 2017 will see the Severalnines team attend two open source database conferences, namely the MariaDB User Conference, and the Percona Live Conference. Find all details about our participation here.

Posted in:

MySQL High Availability tools - Comparing MHA, MRM and ClusterControl

This blog post compares HA solutions: MHA, MRM and ClusterControl.

Top mistakes to avoid in MySQL replication

There are many mistakes you can make with MySQL replication, but do you also know how to resolve them afterwards? This post will uncover the most common pitfalls and their solutions.

Webinar Replay and Q&A: Load balancing MySQL & MariaDB with ProxySQL & ClusterControl

This blog provides details for the replay of our webinar on how to load balance MySQL and MariaDB with ClusterControl and ProxySQL; as well as answers to the many questions asked during this session.

Posted in:

MySQL Tutorial - Troubleshooting MySQL Replication Part 2

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.

MySQL Tutorial - Troubleshooting MySQL Replication Part 1

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.