I've spent a bit of time researching this topic as I was trying to find a low-cost solution for clients who needed their websites to be up 24/7, but don't have the budget for an enterprise type setup. Initially, I tried out a two server solution utilizing MariaDB's MaxScale software, but soon found out that this software requires a paid license and that only older versions are free to use.
Thi ...
: 
: 