MySQL Forums :: Newbie :: Replication fun


Advanced Search

Replication fun
Posted by: Tyler Hall ()
Date: August 10, 2009 11:29PM

Hi, I have two quick questions..

1) The documentation says to do 'lock tables with read lock' and then do a mysqldump, so nothing gets written as you do the dump, however if you do mysqldump dbname > db.sql while read lock is on, it just hangs with a 0 byte. What is the correct way to get a dump of the DB without it changing?

2) I constantly get these error messages if the machine shuts down incorrectly:

090811 5:16:43 [Note] Slave SQL thread initialized, starting replication in log 'bin.000013' at position 634998665,
relay log '/var/log/mysql-master/relay.000001' position: 4
090811 5:16:44 [Note] Slave I/O thread: connected to master 'repi@blahblah:3306', replication started in log 'bin.000013' at position 634998665
090811 5:16:44 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
090811 5:16:44 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
090811 5:16:44 [Note] Slave I/O thread exiting, read up to log 'bin.000013', position 634998665


I can't find a way to fix them unless I wipe out the db and start the replication from scratch. (I get these errors on the slaves)

Options: ReplyQuote


Subject Written By Posted
Replication fun Tyler Hall 08/10/2009 11:29PM
Re: Replication fun Roel Van de Paar 08/11/2009 06:03PM
Re: Replication fun Rick James 08/24/2009 11:41PM
Re: Replication fun Rick James 10/29/2009 09:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.