1. The binlog logs are deleted several more times and the MySQL master is not synchronized.
Mysql> show slave status \ G;
Slave_IO_Running: No
Slave_ SQL _Running: Yes
View the error log
[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 ',
Solution
Slave Server Configuration:
Master Server View
Mysql> show master status;
+ ------------------ + ---------- + -------------- + ------------------ +
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+ ------------------ + ---------- + -------------- + ------------------ +
| Mysql-bin.000005 | 106 |
+ ------------------ + ---------- + -------------- + ------------------ +
1 row in set (0.00 sec)
Slave server settings
Mysql> change master to master_host = '192. 168.0.10 ', master_user = 'replicase', master_password = 'replicase', master_log_file = 'mysql-bin.000003', master_log_pos = 192;
Query OK, 0 rows affected (0.03 sec)
Mysql> stop slave;
Mysql> start slave;
Master Server Configuration
View on server
Mysql> show master status;
+ ------------------ + ---------- + -------------- + ------------------ +
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+ ------------------ + ---------- + -------------- + ------------------ +
| Mysql-bin.000005 | 106 |
+ ------------------ + ---------- + -------------- + ------------------ +
1 row in set (0.00 sec)
Master Server Configuration
Mysql> change master to master_host = '192. 168.0.11 ', master_user = 'replicase', master_password = 'replicase', master_log_file = 'mysql-bin.000005', master_log_pos = 192;
Query OK, 0 rows affected (0.03 sec)
Mysql> stop slave;
Mysql> start slave;
Check the slave status.