MySQL Forums
Forum List  »  Synchronization

Replication shutsdown the slave mysql.
Posted by: Rodis Alvarez
Date: December 27, 2010 01:52PM

I have successfully setup replication on mysql, data is going into the slave just fine. But for some reason, the slave shuts down the mysql database. Below is the log file, is there anything that i can do to prevent the salves mysql from shutting down?


101227 14:29:54 mysqld started
101227 14:29:54 InnoDB: Started; log sequence number 0 8643281
101227 14:29:54 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.91-community-log' socket: '/var/lib/mysql/mysql.sock' port: 37475 MySQL Community Edition (GPL)
101227 14:29:54 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 12959095, relay log './christina-relay-bin.000032' position: 10663
101227 14:29:54 [Note] Slave I/O thread: connected to master '**@**:**', replication started in log 'mysql-bin.000003' at position 12959095
101227 14:32:09 [Note] /usr/sbin/mysqld: Normal shutdown

101227 14:32:09 [Note] Slave I/O thread killed while reading event
101227 14:32:09 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 13141902
101227 14:32:09 [Note] Error reading relay log event: slave SQL thread was killed
101227 14:32:09 InnoDB: Starting shutdown...
101227 14:32:09 InnoDB: Shutdown completed; log sequence number 0 8643281
101227 14:32:09 [Note] /usr/sbin/mysqld: Shutdown complete

101227 14:32:09 mysqld ended

101227 14:32:27 mysqld started
101227 14:32:27 InnoDB: Started; log sequence number 0 8643281
101227 14:32:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.91-community-log' socket: '/var/lib/mysql/mysql.sock' port: *** MySQL Community Edition (GPL)
101227 14:32:27 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 13170036, relay log './christina-relay-bin.000036' position: 28369
101227 14:32:27 [Note] Slave I/O thread: connected to master '**@**:**', replication started in log 'mysql-bin.000003' at position 13170036
101227 14:37:08 [Note] /usr/sbin/mysqld: Normal shutdown

101227 14:37:08 [Note] Slave I/O thread killed while reading event
101227 14:37:08 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 13463249
101227 14:37:08 [Note] Error reading relay log event: slave SQL thread was killed
101227 14:37:08 InnoDB: Starting shutdown...
101227 14:37:08 InnoDB: Shutdown completed; log sequence number 0 8643281
101227 14:37:08 [Note] /usr/sbin/mysqld: Shutdown complete

101227 14:37:08 mysqld ended

101227 14:37:26 mysqld started
101227 14:37:26 InnoDB: Started; log sequence number 0 8643281
101227 14:37:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.91-community-log' socket: '/var/lib/mysql/mysql.sock' port: *** MySQL Community Edition (GPL)
101227 14:37:26 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 13469766, relay log './christina-relay-bin.000040' position: 6752
101227 14:37:26 [Note] Slave I/O thread: connected to master '**@**:**', replication started in log 'mysql-bin.000003' at position 13469766
101227 14:42:08 [Note] /usr/sbin/mysqld: Normal shutdown

101227 14:42:08 [Note] Slave I/O thread killed while reading event
101227 14:42:08 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 13817775
101227 14:42:08 [Note] Error reading relay log event: slave SQL thread was killed
101227 14:42:08 InnoDB: Starting shutdown...
101227 14:42:09 InnoDB: Shutdown completed; log sequence number 0 8643281
101227 14:42:09 [Note] /usr/sbin/mysqld: Shutdown complete

101227 14:42:09 mysqld ended

101227 14:42:27 mysqld started
101227 14:42:27 InnoDB: Started; log sequence number 0 8643281
101227 14:42:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.91-community-log' socket: '/var/lib/mysql/mysql.sock' port: *** MySQL Community Edition (GPL)
101227 14:42:27 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 13834397, relay log './christina-relay-bin.000044' position: 16857
101227 14:42:27 [Note] Slave I/O thread: connected to master '**@**:**', replication started in log 'mysql-bin.000003' at position 13834397



Edited 1 time(s). Last edit at 12/27/2010 01:53PM by Rodis Alvarez.

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication shutsdown the slave mysql.
5164
December 27, 2010 01:52PM


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.