Galera 3 node cluster + web servers ¿load balancer best route?

Question

Hi,

I’m trying to get a redundant setup with MariaDB Galera (3 nodes cluster).

I have 4 web servers that needs to read/write (not too heavy currently) to the cluster. However, the only piece missing is the “bridge” between web servers and the DB cluster.

What would be the best option?
A load balancer? How much of a single point of failure the load balancer would be?

I don’t want to over complicate things either. Any idea is welcomed.

Thanks!

Answer 1

alexdo October 9, 2019

Hello, @raenk

I believe you should be fine with e Load Balancer setup. The load balancer can be a small node which will only redirect the requests. You can use Galera Load Balancer (glb) for this. it should work perfectly.

If you’re afraid that with load balancer in place there is a single point of failure you can grand more resources to the load balancer or simply setup a small test environment to see if this setup will be suitable with your needs.

Let me know if you have any questions.

Reply Report

raenk October 9, 2019

Hi,

Thanks for your response. I was thinking about a DO load balancer. For GLB, it would have to be a droplet manually setup as GLB, correct?

Or there’s a way to fire up a DO GLB? If not, would you rather recommend GLB over DO’s?

Thanks again!
Reply Report
- alexdo October 9, 2019
  
  For the GLB you would need to configure this manually, that is correct. I can give you some brief instructions on how to set this, if you want.
  
  I would also recommend you to check this tutorial on how to configure Galera Cluster with MariaDB on Ubuntu 18.04
  
  https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-ubuntu-18-04-servers
  
  Let me know how it goes.
  
  How To Configure a Galera Cluster with MariaDB on Ubuntu 18.04 Servers
  by bsder
  In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Ubuntu 18.04 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.
  
  Reply Report
  
  raenk October 9, 2019
  
  I would appreciate your help on the instructions for GLB.
  
  Many thanks!
  
  Reply Report

Answer 2

raenk October 9, 2019

Hi,

Thanks for your response. I was thinking about a DO load balancer. For GLB, it would have to be a droplet manually setup as GLB, correct?

Or there’s a way to fire up a DO GLB? If not, would you rather recommend GLB over DO’s?

Thanks again!
Reply Report
- alexdo October 9, 2019
  
  For the GLB you would need to configure this manually, that is correct. I can give you some brief instructions on how to set this, if you want.
  
  I would also recommend you to check this tutorial on how to configure Galera Cluster with MariaDB on Ubuntu 18.04
  
  https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-ubuntu-18-04-servers
  
  Let me know how it goes.
  
  How To Configure a Galera Cluster with MariaDB on Ubuntu 18.04 Servers
  by bsder
  In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Ubuntu 18.04 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.
  
  Reply Report
  
  raenk October 9, 2019
  
  I would appreciate your help on the instructions for GLB.
  
  Many thanks!
  
  Reply Report

Related

Question

Galera 3 node cluster + web servers ¿load balancer best route?

Related

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

Galera 3 node cluster + web servers ¿load balancer best route?

Related

Leave a comment

Related

question

Server1 <-> server2 setup?

question

MariaDB Configuration - mysql tuner recommendations

question

Cannot add external certificate generated from cloudflare to certificate list

question

how can I get latency of each request generated by wrk2 benchmarking tool?

Looking for something else?