Advanced MySQL Load Balancing with NGINX Plus
In this article, we explain how to use some of the advanced features in NGINX Plus and the open source NGINX software to load balance MySQLTM database servers in a Galera cluster. We explore splitting of reads and writes across load-balancing database servers, advanced health checks and monitoring, and some best practices for maximizing availability. (Both NGINX and NGINX Plus support the features we’re discussing, but for ease of reading we refer to NGINX Plus throughout.) Setting Up a Galera Cluster of MySQL Database Servers This blog builds on our previous blog about MySQL load balancing with NGINX Plus and assumes you have a working knowledge of MySQL, Galera Cluster, and TCP load balancing with NGINX Plus. We followed the DigitalOcean guide to set up three MariaDB database servers as a Galera cluster, but you can set up an equivalent cluster however you choose, and substitute MySQL [ more… ]