linux---mysql的主从配置

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;