Best Mysql Replication Solution?
I am running 3 am running 3 web/db servers. I originally setup master master replication so that all my webservers could use localhost as this was speeding up the sites considerably. The problem was I was getting mysql errors from some of the table and I had to setup the replication from scratch again and again which is not ideal. I also noticed that the mysql database wasn't replicating properly itself. This was a real pain when adding user. It meant I had to add the user manually to all the servers
I tried mysql-proxy using read/write splitting which would run fine for a short time but once an error occurred the system would crash and have to be restarted manually.
I'm wondering what the most reliable system is to keep my 3 databases synchronized?
Many thanks in advance for your help