The main problem we are looking at is backing up the database. We have several big tables that all need to backed so the problem is these tables are being use 24/7 so taking a snap shot of the database will course down time.
We have had no problems with auto increment columns. -----Original 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 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 we take it up again. I read that 2-ways replication is dangerous so for peace of mind I would avoid it. I was considering a simple dump of the database on slave, when I have to reconnect the master server. I would: 1. disconnect the slave 2. create a dump file form salve 3. put the dump on the master 4. reconnect the master and slave Questions are.. a. I use innodb tables. Any problems to nofify? b. Are auto_increment values correct/safe after such operations. I guess so but I'm not 100% sure c. Do you have comments and suggestions regarding 2-ways replications Any suggestion / comment is welcome ;) Thanks!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
