Re: seeding a slave from a slave
Hi Ofer, Is it necessary to stop the slave before doing the mysql dump. If we use --single-transaction option in mysqldump should provide consistent backup..right. or stop slave note the slave status info. start slave start mysqldump. regards anandkl On 7/26/07, Ofer Inbar [EMAIL PROTECTED] wrote: Ian P. Christian [EMAIL PROTECTED] wrote: How do I create a mysql data dump from a slave to seed another slave? Using --master-data with mysqldump from my existing slave sets the master to the slave I was dumping, not the real master. I started a discussion of the same thing a week or two ago on this list, if you search the archives (or just google, I bet) you'll see more detail. The quick answer is you can't do it if the slave is in use and needs to keep replicating. You need to stop replicating, copy down the slave's master info (you can see it in show slave status), run the dump while replication is stopped, then start it again. (Read the earlier thread if you want more detail) -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: seeding a slave from a slave
Ian P. Christian [EMAIL PROTECTED] wrote: How do I create a mysql data dump from a slave to seed another slave? Using --master-data with mysqldump from my existing slave sets the master to the slave I was dumping, not the real master. I started a discussion of the same thing a week or two ago on this list, if you search the archives (or just google, I bet) you'll see more detail. The quick answer is you can't do it if the slave is in use and needs to keep replicating. You need to stop replicating, copy down the slave's master info (you can see it in show slave status), run the dump while replication is stopped, then start it again. (Read the earlier thread if you want more detail) -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
seeding a slave from a slave
Hi All, How do I create a mysql data dump from a slave to seed another slave? Using --master-data with mysqldump from my existing slave sets the master to the slave I was dumping, not the real master. Many Thanks, Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]