Which is the best way to sync multiple database on one central server? My idea is to implement on the central server multiple mysql instances and to create master - slave replication for each host ( in this case I need 4 slave hosts only ). There is one better method for this?
The purpose of this is that i have to run a application which makes multiple queries on databases and i don`t wanna push to much load on production servers.
