Hi, I did manage to get two-way replication to work properly, but I have to type:
mysql> load data from slave; This is the only way it replicates the data. Is there a way to have it replicate back and forth in real time? Thanks, Richard -----Original Message----- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:33 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Database replication Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -----Original Message----- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote: > Hi, > > I'm working on setting up db replication, and I have a question. If I have > a master server, which will replicate to a slave, what about vice versa? It works, but there is no conflict resolution built in. If both servers update the same record, it will cause problems. I believe you would also have problems if both servers added records to a table with an autoincrement field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]