Share

Question

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

Answer 1

bobbyiliev February 7, 2020

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

How To Create a High Availability Setup with Heartbeat and Floating IPs on Ubuntu 16.04

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.

Reply Report

mikeabrown09 February 7, 2020

bobbyiliev

If I do not use DO managed LB then you are saying to follow the guide you provided which is using HAProxy with a floating IP address. what about keepalived?
Reply Report
- bobbyiliev February 7, 2020
  
  Hi Mike,
  
  Yes indeed you could also use keepalived. You could take a look at this tutorial here:
  
  https://www.digitalocean.com/community/tutorials/how-to-set-up-highly-available-web-servers-with-keepalived-and-floating-ips-on-ubuntu-14-04
  
  Regards,
  Bobby
  
  How To Set Up Highly Available Web Servers with Keepalived and Floating IPs on Ubuntu 14.04
  by Justin Ellingwood
  Keepalived is a service that can monitor servers or processes in order to implement high availability on your infrastructure. In this guide, we will use the `keepalived` daemon to monitor two web servers. The secondary server will take over the web traffic if the primary server experiences issues by automatically claiming ownership of a shared Floating IP address using the DigitalOcean API.
  
  Reply Report

Answer 2

mikeabrown09 February 7, 2020

bobbyiliev

If I do not use DO managed LB then you are saying to follow the guide you provided which is using HAProxy with a floating IP address. what about keepalived?
Reply Report
- bobbyiliev February 7, 2020
  
  Hi Mike,
  
  Yes indeed you could also use keepalived. You could take a look at this tutorial here:
  
  https://www.digitalocean.com/community/tutorials/how-to-set-up-highly-available-web-servers-with-keepalived-and-floating-ips-on-ubuntu-14-04
  
  Regards,
  Bobby
  
  How To Set Up Highly Available Web Servers with Keepalived and Floating IPs on Ubuntu 14.04
  by Justin Ellingwood
  Keepalived is a service that can monitor servers or processes in order to implement high availability on your infrastructure. In this guide, we will use the `keepalived` daemon to monitor two web servers. The secondary server will take over the web traffic if the primary server experiences issues by automatically claiming ownership of a shared Floating IP address using the DigitalOcean API.
  
  Reply Report

Question

How Should I set this up?

Leave a comment

Looking for something else?

Share

Share your Question

Question

How Should I set this up?

Leave a comment

Related

question

Increase upload_max_filesize and post_max_size to 200M

question

How to Protect wp-admin & wp-login ?

question

Can I have two different domains point to same loader, but load different websites?

question

MySQL spikes CPU (>80%) when publishing posts in Wordpress

Looking for something else?

Almost there!