Webinar Replay: High Availability in ProxySQL for HA MySQL infrastructures
Thanks to everyone who participated in our recent webinar on High Availability in ProxySQL and on how to build a solid, scalable and manageable proxy layer using ProxySQL for highly available MySQL infrastructures. This second...
Webinar Replay: Load balancing MySQL & MariaDB with ProxySQL & ClusterControl
Thanks to everyone who participated in our recent webinar on how to load balance MySQL and MariaDB with ClusterControl and ProxySQL! This joint webinar with ProxySQL creator René Cannaò generated a lot of interest …...
Video Interview with ProxySQL Creator René Cannaò
In anticipation of this month’s webinar MySQL & MariaDB Load Balancing with ProxySQL & ClusterControl that will happen on February 28th Severalnines sat down with the creator of ProxySQL founder and creator René Cannaò to...
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...
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...
Tips and Tricks – How to Shard MySQL With ProxySQL in ClusterControl
Having too large a (write) workload on a master is dangerous. If the master collapses and a failover happens to one of its slave nodes, the slave node could collapse under the write pressure as...
Sharding MySQL with MySQL Fabric and ProxySQL
There are numerous ways to migrate into MySQL Fabric. Most of them require serious changes in your application - you have to switch to the MySQL Fabric connector to actually benefit from the MySQL Fabric...
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...
How ProxySQL Adds Failover and Query Control to Your MySQL Replication Setup
In a previous blog post, we discussed the installation of ProxySQL and its configuration system. In today’s post, we’ll set up ProxySQL to work in a MySQL Replication environment managed by ClusterControl. We will take...
MySQL Load Balancing with ProxySQL – An Overview
Year 2015 was a good year for proxies in MySQL environments. First, MariaDB released a GA version of MaxScale, a new proxy that understands MySQL Replication and Galera topologies and supports read-write splitting. Later in...