Repair Replication

Repair Replication

2018. 7. 10. 06:42ㆍ개발/MariaDB

로그확인

grep mysql /var/log/syslog

SHOW SLAVE STATUS

다음 값 확인

Slave_IO_Running: Yes

Slave_SQL_Running: No

Repairing The Replication

1.STOP SLAVE;

2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

3.START SLAVE;

4.SHOW SLAVE STATUS \G

로그 확인

grep mysql /var/log/syslog

[ mariadb ] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") (0)	2023.08.22

[ mariadb ] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") 2023.08.22

스마트플렉스