개발/MariaDB(2)
-
[ 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")
log-bin = /var/log/mariadb/mariadb-bin log-bin-index = /var/log/mariadb/mariadb-bin.index binlog_format = mixed from my config does, in fact, remove the 'warning'.
2023.08.22 -
Repair Replication
로그확인grep mysql /var/log/syslog SHOW SLAVE STATUS 다음 값 확인Slave_IO_Running: YesSlave_SQL_Running: No Repairing The Replication1.STOP SLAVE;2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;3.START SLAVE;4.SHOW SLAVE STATUS \G 로그 확인grep mysql /var/log/syslog
2018.07.10