List:General Discussion« Previous MessageNext Message »
From:John McCaskey Date:January 27 2004 4:02pm
Subject:RE: updates on slave server??
View as plain text  
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

Thread
updates on slave server??Mike Mapsnac27 Jan
  • Re: updates on slave server??Paul DuBois27 Jan
  • RE: updates on slave server??John McCaskey27 Jan
Re: updates on slave server??Mike Mapsnac28 Jan