Bi-directional synchronization between multiple mysql databases
-
Guys, Is it possible to synch 4 databases in mysql? I mean there are 4 servers on different location and databases on server will be in Auto Synch mode. If any one goes down rest of the three gets sync automatically and it goes UP, all 4 gets synch automatically. Please reply...!
-
Guys, Is it possible to synch 4 databases in mysql? I mean there are 4 servers on different location and databases on server will be in Auto Synch mode. If any one goes down rest of the three gets sync automatically and it goes UP, all 4 gets synch automatically. Please reply...!
You're talking about sharding, replication, and load balancing, which is great, but unless you're writing software that will perform this task, this is the wrong forum for it. I'd suggest the System Administrator or Database forums.
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli