Advertisement
Guest User

Untitled

a guest
Nov 18th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. 1. STOP SLAVE;
  2. 2. SHOW SLAVE STATUS;
  3. 3. Note these values Master_Log_File: mysql-bin.018098 & Read_Master_Log_Pos: 185753950
  4. 4. FLUSH TABLES WITH READ LOCK;
  5. 5. Service mysql stop
  6. 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.
  7. 5. service mysql start.
  8. 6. UNLOCK TABLES;
  9.  
  10. 1. service mysql start --skip-slave-start
  11.  
  12. 2.
  13. CHANGE MASTER TO MASTER_HOST='existing slave',
  14. MASTER_USER='xxx',
  15. MASTER_PASSWORD='xxx',
  16. MASTER_LOG_FILE='mysql-bin.018098',
  17. MASTER_LOG_POS=185753950;
  18.  
  19. 3. execute start slave
  20.  
  21. got an error:
  22. 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)
  23. 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
  24. 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