mysql主从配置.md

mysql主从配置

配置主库

1.创建账号

GRANT REPLICATION SLAVE ON *.* TO 'replica_user'@'replica_server_ip';
FLUSH PRIVILEGES;

配置从库

1.配置同步点

STOP SLAVE;
CHANGE MASTER TO MASTER_HOST ='your-master-ip', MASTER_USER ='replication_user', MASTER_PASSWORD ='password', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 900;

问题

1. 删除了同步点，从旧的binlog点开始同步，需要跳过的报错（从库）

[mysqld]
slave-skip-errors=1062,1032