38 blog posts in 12 categories
MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment. ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.
Severalnines Senior Support Engineer Art van Scheppingen has created a series of videos to demonstrate the top features of ClusterControl for MySQL, MongoDB & PostgreSQL.
Severalnines Support Engineer Art van Scheppingen demonstrates the top features and functions of ClusterControl by Severalnines.
MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.
This blog post shows you how to deploy and configure ProxySQL from ClusterControl 1.3.3, on top of a master-slave replication setup. ProxySQL is an SQL-aware load balancer. It allows you to automatically do read-write split of your traffic, by sending writes to your writeable master and sending reads to the read-only slaves.
ClusterControl has come a long way since its release in 2012. Here are some interesting facts and figures on how it’s being used and by whom.
This blog post will go through new replication features in ClusterControl 1.4.0, including enhanced multi-master deployment, managing replication topology changes, automated failover and handling of replication errors.
This blog post shows you how to use GitHub’s gh-ost to perform an online schema change on a MySQL master-slave replication setup.
This blog post shows you how to set up a sharded MySQL setup based on MySQL Fabric and ProxySQL.
This blog post will introduce you to three different tools which are designed to help users shard their MySQL databases.