MaxScale without a Single Point of Failure?
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