FW: Replication - Slave Backup to Master

2003-11-13 Thread nm
Hi I set a 2-way replication on 2 servers. I made some test transactions and it is working. I can make the clients go to any of my servers and the replication is done in real time, or so. It looks great. What are the potential problems I could have? Suggestions? Do you have any experience? (usin

Re: Replication - Slave Backup to Master

2003-11-13 Thread Mikael Fridh
On Thursday 13 November 2003 10.41, nm wrote: > Hi there > > I have a question regarding replication. > This is the situation: > > Mysql-Max4.0.16 > > 192.168.0.10 master > 192.168.0.11 slave > > I would like to use the slave as the backup server > and use it in case the master goes down for any re

Re: Replication - Slave Backup to Master

2003-11-13 Thread Rainer M. Krug
Hi thanks a lot for your prompt reply. The second email went out on accident - apologies. I managed to fix it - I found "localhost; EcolMod1" in user.myd. Thanks again, Rainer On 13 Nov 2003 at 10:41, nm wrote: > > Hi there > > I have a question regarding replication. > This is the situat

RE: Replication - Slave Backup to Master

2003-11-13 Thread Simon Green
Message- From: nm [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 09:41 To: [EMAIL PROTECTED] Subject: Replication - Slave Backup to Master Hi there I have a question regarding replication. This is the situation: Mysql-Max4.0.16 192.168.0.10 master 192.168.0.11 slave I would like to use

Replication - Slave Backup to Master

2003-11-13 Thread nm
Hi there I have a question regarding replication. This is the situation: Mysql-Max4.0.16 192.168.0.10 master 192.168.0.11 slave I would like to use the slave as the backup server and use it in case the master goes down for any reason. I'm looking for a safe method to re-update the master when