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 database environments. In the open source world, there’s been a few SQL-aware load balancers, namely MySQL Proxy, ProxySQL and MaxScale, but they all seemed to be in beta status and unfit for production use. So we were pretty excited when the MariaDB team released a GA version of MaxScale earlier this year. In this blog, we’ll have a look at MaxScale and see how it compares with HAProxy.
מקור: How to Deploy and Configure MaxScale for SQL Load Balancing with Read-Write Split | Severalnines
This tutorial will demonstrate how you can use Corosync and Pacemaker with a Floating IP to create a high availability (HA) server infrastructure on DigitalOcean. Corosync is an open source program that provides cluster membership and messaging capabi
מקור: How To Create a High Availability Setup with Corosync, Pacemaker, and Floating IPs on Ubuntu 14.04 | DigitalOcean
Recently, nginx 1.9 introduced support for TCP load balancing – similar to what HAProxy is capable of. The one major drawback is that it does not support advanced backend health checks. This is required when running MySQL Galera Cluster, as we’ll explain in the next section. Note that this limitation is removed in the paid-only edition called NGINX Plus.
מקור: nginx as Database Load Balancer for MySQL or MariaDB Galera Cluster | Severalnines
- Deploy, manage, monitor and scale entire clusters
- SQL and NoSQL cluster topologies
- SQL load balancing via HAProxy
ב-clustercontrol | Severalnines.