How to Set up Read-Write Split in Galera Cluster Using ProxySQL
Edited on Sep 12, 2016 to correct the description of how ProxySQL handles session variables. Many thanks to Francisco Miguel for pointing this out. ProxySQL is becoming more and more popular as SQL-aware load balancer...
Infrastructure Automation – Deploying ClusterControl and MySQL-Based Systems on AWS using Ansible
We recently made a number of enhancements to the ClusterControl Ansible Role, so it now also supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster). The updated role uses the awesome ClusterControl...
Adding Existing Databases and Clusters (Updated)
In our previous blog post we covered the deployment of four types of clustering/replication: MySQL Galera, MySQL master-slave replication, PostgreSQL replication set and MongoDB replication set. This should enable you to create new clusters with...
What's New in ClusterControl 1.3.1 Documentation
If you haven’t upgraded to ClusterControl 1.3.1, you should! It’s full of great new features and enhancements. We have lots of documentation to help you get started. Documentation on older versions is also available in...
Webinar Replay: How to Build Scalable Database Infrastructures with MariaDB & HAProxy
Thanks to everyone who participated in last week’s live webinar on how CloudStats.me moved from MySQL to clustered MariaDB for high availability with Severalnines ClusterControl. The webinar included use case discussions on cloudstats.me’s database infrastructure...
Understanding the MySQL Galera Cluster and MariaDB Cluster Diagnostic Logs
In a previous post, we discussed the error log as a source of diagnostic information for MySQL. We’ve shown examples of problems where the error log can help you diagnose issues with MySQL. This post...
Webinar Replay: Deploying MongoDB, MySQL, PostgreSQL & MariaDB’s MaxScale in 40min
Live demo recording of ClusterControl 1.2.11 and its new features Thanks to everyone who joined us for our recent live webinar on ‘ClusterControl 1.2.11 - new release’ led by Art van Scheppingen , Senior Support...
How to Deploy and Manage MaxScale Using ClusterControl
We were delighted to announce that ClusterControl now supports MaxScale, the intelligent database gateway from the MariaDB team. In this blog, we will show you how to deploy and manage MaxScale from ClusterControl. We previously...
How to Preform an Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10
The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features. In this blog post,...
SQL Load Balancing Benchmark – Comparing Performance of MaxScale vs HAProxy
In a previous post, we gave you a quick overview of the MaxScale load balancer and walked through installation and configuration. We did some quick benchmarks using sysbench, a system performance benchmark that supports testing...
How to Deploy and Configure MaxScale for SQL Load Balancing with Read-Write Split
There are two models of load balancing: transport and application layer. HAProxy is a great TCP load balancer, but it’s lack of SQL awareness effectively limits its ability to address certain scaling issues in distributed...
How to Deploy High Availability CloudStack/CloudPlatform with MariaDB Galera Cluster
Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key...