Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. STOP SLAVE;
- 2. SHOW SLAVE STATUS;
- 3. Note these values Master_Log_File: mysql-bin.018098 & Read_Master_Log_Pos: 185753950
- 4. FLUSH TABLES WITH READ LOCK;
- 5. Service mysql stop
- 4. Took snapshot of mysql data vol and restore it on new mysql slave server, also I changed the server-id in my.cnf on the new mysql slave.
- 5. service mysql start.
- 6. UNLOCK TABLES;
- 1. service mysql start --skip-slave-start
- 2.
- CHANGE MASTER TO MASTER_HOST='existing slave',
- MASTER_USER='xxx',
- MASTER_PASSWORD='xxx',
- MASTER_LOG_FILE='mysql-bin.018098',
- MASTER_LOG_POS=185753950;
- 3. execute start slave
- got an error:
- 2016-11-18 16:39:50 5736 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
- 2016-11-18 16:39:50 5736 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file', Error_code: 1236
- 2016-11-18 16:39:50 5736 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.018098', position 185753950
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement