在docker 里实现mysql5.6.44主从复制

我们在启动vagrant的时候我们先在vagrantfile配置文件里放出一个公网或者私网

首先在docker hub 上拉取mysql5.6.44镜像

docker pull mysql:5.6.44

docker image ls 查看一下我们拉取的镜像

主从复制
创建主服务master.cnf和从服务slave.cnf文件

master.cnf

[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
symbolic-links=0
character-set-server = utf8
#skip-networking
innodb_print_all_deadlocks = 1
max_connections = 2000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 28M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
ft_min_word_len = 4
log-bin = mysql-bin
server-id = 1
binlog_format = mixed
performance_schema = 0
explicit_defaults_for_timestamp
#lower_case_table_names = 1
interactive_timeout = 28800
wait_timeout = 28800

#Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES

[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

slave.cnf

[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
symbolic-links=0
character-set-server = utf8
#skip-networking
innodb_print_all_deadlocks = 1
max_connections = 2000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 28M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
ft_min_word_len = 4
log-bin = mysql-bin
server-id = 2
binlog_format = mixed
performance_schema = 0
explicit_defaults_for_timestamp
#lower_case_table_names = 1
interactive_timeout = 28800
wait_timeout = 28800

#Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

创建两个mysql容器 主节点my_master从节点my_slave1
docker run -d -p 3306:3306 --name my_master -v /home/vagrant/master.cnf:/etc/mysql/conf.d/master.cnf -e MYSQL_ROOT_PASSWORD=‘root’ mysql:5.6.44

docker run -d -p 3307:3306 --name my_slave1 -v /home/vagrant/slave.cnf:/etc/mysql/conf.d/slave.cnf -e MYSQL_ROOT_PASSWORD=‘root’ mysql:5.6.44

进入主节点里登入mysql

查看用户
select user,host from myqsl.user;

创建一个myslave用户并给从服务授权
grant replication slave on . to ‘myslave’@’%’ identified by ‘root’;

flush privileges;刷新

查看master

进入从节点

change master to master_host=‘192.168.43.22’,master_user=‘myslave’, master_password=‘root’,master_log_file=‘mysql-bin.000004’, master_log_pos=400;

master_host=‘192.168.43.22’ IP是第一步我们在vagrantfile文件里放出来的IP

master_user=‘myslave’, master_password=‘root’, 这连个用户名是我们在主服务里创建的用户名和密码
master_log_file=‘mysql-bin.000004’, master_log_pos=400; 参考主服务里 master的信息（show master status;）

在从服务里启动slave并查看slave

Slave_IO_Running:Yes
Slave_SQL_Running: Yes 连个都为Yes表示主从复制成功
主从复制测试：

测试软件：

主服务

从服务

先在我们在主服务创建一个数据库test 看一下从服务会不会同步主服务

主服务我们已经建好我们现在刷新一下从服务

我们现在创一个user表看一下

成功！！！
读写分离：