MySQL & MariaDB Load Balancing with ProxySQL
Proxies are building blocks of high availability setups for MySQL and MariaDB. They can detect failed nodes and route queries to hosts which are still available. If your master failed and you had to promote...
MySQL in the Cloud – Pros and Cons of Amazon RDS
Moving your data into a public cloud service is a big decision. All the major cloud vendors offer cloud database services, with Amazon RDS for MySQL being probably the most popular. In this blog, we’ll...
How to Deploy and Manage MySQL Multi-Master Replication Setups With ClusterControl 1.4
MySQL replication setups can take different shapes. The main topology is probably a simple master-slave setup. But it is also possible to construct more elaborate setups with multiple masters and chained setups. ClusterControl 1.4 takes...
Video: Top Four Feature Sets of ClusterControl for MySQL, MongoDB & PostgreSQL
The videos below demonstrate the top features and functions included in ClusterControl. Deploy Deploy the best open source database for the job at hand using repeatable deployments with best practice configurations for MySQL, MySQL Cluster,...
How to Manage Configuration Templates for Your Databases With ClusterControl
ClusterControl makes it easy to deploy a database setup - just fill in some values (database vendor, database data directory, password and hostnames) in the deployment wizard and you’re good to go. The rest of...
Video: An Overview of the Features & Functions of ClusterControl
The video below demonstrates the top features and functions included in ClusterControl. ClusterControl is an all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases on-premise...
Automatic Failover of MySQL Replication – New in ClusterControl 1.4
MySQL replication setups are inevitably related to failovers. Unlike multi-master clusters like Galera, there is one single writer in a whole setup - the master. If the master fails, one of the slaves will have...
Deploy and Configure ProxySQL on Top of MySQL Replication Using ClusterControl
A proxy layer is an important building block for any highly available database environment. HAProxy has been available for a long time, as a generic TCP load balancer. We later added support for MaxScale, an...
Evolution of ClusterControl for MySQL & MongoDB
ClusterControl reduces complexity of managing your database infrastructure on premise or in the cloud, while adding support for new technologies; enabling you to truly automate mixed environments for next-level applications. Since the launch of ClusterControl...
Automating MySQL Replication with ClusterControl 1.4.0 – What's New
With the recent release of ClusterControl 1.4.0, we added a bunch of new features to better support MySQL replication users. In this blog post, we’ll give you a quick overview of the new features. Enhanced...
ClusterControl 1.4 – the MySQL Replication & MongoDB Edition
Today we are pleased to announce the 1.4 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases in any environment; on-premise...
Online Schema Change With gh-ost – Throttling and Changing Configuration at runtime
(this post was edited on 13/01/2017 after comments from Shlomi N.) In previous posts, we gave an overview of gh-ost and showed you how to test your schema changes before executing them. One important feature...