The updates on the slave will not syncronize to the master if you have a one
direction master->slave relationship setup. It is possible however to setup
each server as a master and as a slave so that server 1 is the master for
server 2 and server 2 is the master for server 1. Then queries will
propogate in both directions. This may be what you are looking for.
If you setup such bi-directional replication and you are executing queries
at the same time on both servers you need to be careful about things like
auto-index collumns getting out of sync and causing conflicts due to the
latency in replication.
John A. McCaskey
-----Original Message-----
From: Mike Mapsnac [mailto:mikerh9@stripped]
Sent: Monday, January 26, 2004 4:50 PM
To: mysql@stripped
Subject: updates on slave server??
Hello
I found today that some data on slave server were different than on master
server. I don't know how that can happen. Slave server was running, "show
slave statu"s show no errors
If I make some updates on slave server. Does this updates will be reflected
on
master server? Or slave cannot synchronize master server?
Thanks
_________________________________________________________________
Rethink your business approach for the new year with the helpful tips here.
http://special.msn.com/bcentral/prep04.armx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
