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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.