I am creating a shared hosting environment, load balanced and HA. HTTP/HTTPS is okay as well as the distribution of files (code and file uploads) between the servers. The last thing remaining is to load balance and make HA MySQL. I have two servers and I think master-to-master replication with haproxy as balancer is a solution.
What is your advice and what do you think? I need a transparent solution for the end user, something like having only one database to connect to.