View Single Post
  #1  
Old 21st May 2013, 02:15
davefrooney davefrooney is offline
Junior Member
 
Join Date: Apr 2011
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links