1:修改my.cnf文件
1.1:到mysql/3306/conf文件夹下
设置文件权限:chmod 777 my.cnf
1.2:在my.cnf文件下加 vim my.cnf
server-id=200
log-bin=mysql-bin
binlog_format=row
2:
进入容器显示bash-4.4的解决方案
进入容器后输入以下两个命令
cp /etc/skel/.bashrc /root/
cp /etc/skel/.bash_profile /root/
退出容器后再次进入
3:创建主从账号”slave”
3.1:创建用户
create user 'slave'@'%' identified by'123456';
3.2:给slave用户授权
grant replication slave, replication client on *.* to 'slave'@'%';
3.3:修改密码
alter user 'slave'@'%' identified with mysql_native_password by'123456';
3.4:更行权限
flush privileges;
mysql从服务器
4:修3310文件夹里的my.cnf文件
4.1:到mysql/3310/conf文件夹下
设置文件权限:chmod 777 my.cnf
4.2:在my.cnf文件下加 vim my.cnf
1.server-id=201
2.log-bin=mysql-slave-01-bin
3.relay_log=edu-mysql-relay-bin
4.read-only=1
5:创建mysql_3310容器
docker run -itd --name mysql_3310 --privileged=true -p 3310:3306
-v /usr/local/software/mysql/3310/data:/var/lib/mysql
-v /usr/local/software/mysql/3310/conf/my.cnf:/etc/mysql/my.cnf
-v /usr/local/software/mysql/3310/mysql-files:/var/lib/mysql-files
-e MYSQL_ROOT_PASSWORD=123456 mysql
6:查看mysql_3306容器IP地址
docker inspect mysql_master |grep IPA
7:进入从服务器mysql_3310配置主从
change master to master_host='172.17.0.2',
master_user='slave',master_password='123456',
MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=157;
8:启动从服务器
start slave;
9:查看是否成功
show slave status \G;