MySQL Forums
Forum List  »  Newbie

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

Written By
Replication fun
August 10, 2009 11:29PM
August 11, 2009 06:03PM
August 24, 2009 11:41PM
October 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.