我正在两个虚拟机上测试MySQL复制,VirtualBox运行Debian8.2。下面是教程,下面是我如何设置奴隶的/etc/my.cnf
server-id = 2
master-host = 192.168.56.101
master-connect-retry = 60
master-user = slave
master-password = 123
replicate-do-db = base1
replicate-do-db = base2
relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index但是,这样做也不会让我启动mysql。当我运行/etc/init.d/mysql start时,它会失败。以下是日志中出现的两个错误:
error: Can't connect to local MySQL server through socket '/var/run/mysql/mysqld.sock' (2)
Failed to start LSB: Start and stop the mysql server database daemon通过注释master-zzz行,mysql可以在没有问题的情况下启动。
虚拟机可以在不丢失的情况下看到对方和ping。我尝试更改my.cnf的主用户和密码,以及在主服务器上创建不同的复制从用户,但都没有效果。我做错了什么?
发布于 2015-11-20 18:39:00
嗯,原来我的教程有点过时了。这些是my.cnf文件的最终配置:
#master
bind-address = 0.0.0.0
server-id = 1
log-bin= /var/log/mysql/mysql-bin.log
#slave
server-id = 2我没有设置从服务器的my.cnf,而是使用mysql控制台:
CHANGE MASTER TO master_host='master_ip', master_user='slave', master_password='slavepass';根据本手册的说明:https://downloads.mysql.com/docs/mysql-replication-excerpt-5.0-en.pdf
https://stackoverflow.com/questions/33813963
复制相似问题