数据同步
禁止写操作:flush tables with read lock;
解锁:unlock tables;
进入容器:docker exec -it id bash
备份所有数据: mysqldump -uroot -p123+Jvmp=456 --all-databases > database.sql
退出容器,复制safeweb.sql到主机上:docker cp id:database.sql .
在slave数据库中还原数据
master数据库
开启二进制日志:
vi volumes/management/mysqld.cnf
[mysqld]
server-id = 1
log-bin = mysql-bin
重启容器
配置权限:GRANT ALL PRIVILEGES ON *.* to 'backup'@'%' identified by &#