Not the answer you need?
Register and ask your own question!

percona replication error after shutting down the slave

aysabzevaraysabzevar EntrantInactive User Role Beginner
Here is the slave:
mysql> show slave status \G
*************************** 1. row ***************************<br>
Master_Log_File: mysql-bin.000226<br>
Read_Master_Log_Pos: 695831819<br>
Relay_Log_File: mysql-relay-bin.000001<br>
Relay_Log_Pos: 4<br>
Relay_Master_Log_File: mysql-bin.000226<br>
Slave_IO_Running: No<br>
Slave_SQL_Running: Yes<br>
Exec_Master_Log_Pos: 695831819<br>
Relay_Log_Space: 120<br>
Last_IO_Errno: 1236<br>
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'<br>
Last_IO_Error_Timestamp: 150709 14:26:07<br>

It seems slave receives the logs.
Actually we have "Master with Relay Slave" replication and the slave itself act as master for another slave.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.