Galera 3 node cluster + web servers ¿load balancer best route?
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.