1.xtrabackup备份的数据库,在A和B机器恢复。
2.进行master-slave进行主从配置,一直出现Slave is not configured or failed to initialize properly. You must at least set –server-id to enable either a master or a slave.
2.进行master-slave进行主从配置,一直出现Slave is not configured or failed to initialize properly. You must at least set –server-id to enable either a master or a slave.
解决方案
20
感觉是你这个配置文件没生效。改个其他参数验证一下,例如改个max_connections,进MySQL看看最大连接数有没有变化。
20
show variables like “%server-id%”看看两台机器的这个参数能否和你配置文件里面的一样