Hi,
I’ve got two db on different server I read about db replication
but I’m wondering if the flow could be
master > slave
only or also
slave > master
Thanks in advance.
Replication will copy data in near real-time from the master to the slave. Never write data to the slave, just to the master, otherwise your data will not by correctly synchronized.
-Bing
Hi, thanks for the reply.
Do you know a way to synchronize the two db ( a > b and b > a) ?
If you are going to have two masters, you need to do things a bit differently. This is an example:
http://www.howtoforge.com/mysql_master_master_replication
This type of configuration is really dependent on the application.
In our case, we have a number of slaves that handle the read-only portion of the application. The master handles writes of which is replicated to the slaves:
