Question

How Should I set this up?

Posted February 6, 2020 227 views
ApacheMariaDBLoad Balancing

I have the following set up....

LB -> apache cluster (3 hosts) -> Gluster cluster (4 hosts w/ replication)
|
|
V
Load Balancer -> db cluster (3 hosts w/ Galera)

My question is should this be how it is set up? The two load balancers would physically be the same one just have different rules to send data for apache to the apache cluster and then mariadb to the db cluster.

please let me know

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hello,

The setup looks good. As long as you are using a DigitalOcean managed Loadbalancer it should be OK, as DigitalOcean Load Balancers are configured with automatic failover to maintain availability even when failures occur at the balancing layer. Internally, the active balancing component is monitored and fails over to a standby if necessary, meaning your load balancer is never a single point of failure.

If you are not planning to use managed Loadbalancer but HAProxy for example, I would suggest using Heartbeat and Floating IP and setup 2 HPAproxy load balancers:

https://www.digitalocean.com/community/tutorials/how-to-create-a-high-availability-setup-with-heartbeat-and-floating-ips-on-ubuntu-16-04

Regards,
Bobby

by Sebastian Canevari
Heartbeat is an open source program that provides cluster infrastructure capabilities—cluster membership and messaging—to client servers, which is a critical component in a high availability (HA) server infrastructure. Heartbeat is typically used in conjunction with a cluster resource manager (CRM), such as Pacemaker, to achieve a complete HA setup. However, in this tutorial, we will demonstrate how to create a 2-node HA server setup by simply using Heartbeat and a DigitalOcean Floating IP.
Submit an Answer