MaxScale without a Single Point of Failure?
Hi,
We are looking at potentially using MaxScale as a solution to load balance our MySQL connections and provide read/write splits in a master slave setup. If we have both web servers pointing to a single proxy then obviously we have a single point of failure. When we were originally looking at HAProxy it was suggested having a local proxy for each web server that could then balance out across the databases. Is it possible to run MaxScale in a similar fashion? Is there a better approach that could be suggested with MaxScale without a single point of failure?
Answer Answered by Guillaume Lefranc in this comment.
Read the following to setup MaxScale in HA mode: https://mariadb.com/blog/how-make-maxscale-high-available-corosyncpacemaker
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
