Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How Galera Cluster Enables High Availability for High Traffic Websites

This post gives an insight into how Galera can help to build HA websites.

MySQL on Docker: ClusterControl and Galera Cluster on Docker Swarm

This blog post shows our experimentation on running ClusterControl and Galera Cluster on Docker Swarm.

How to Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x using ClusterControl

Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful as we’ve discussed previously. This new post takes things further and shows you how to deploy an asynchronous replication slave to MariaDB Galera Cluster 10.x (with master failover), using GTID with ClusterControl.

Posted in:

How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID

Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. In this blog post, we will show you how to replicate a Galera Cluster to a MySQL server with GTID, and how to failover the replication in case the master node fails.

Posted in:

Video: ClusterControl for Galera Cluster

This video walks you through the features that ClusterControl offers for Galera Cluster and how you can use them to deploy, manage, monitor and scale your open source database environments.

Posted in:

ClusterControl Product Video for Galera Clusters

ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your Galera clusters up-and-running.

Posted in:

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.