分布式开发(4)-mysql集群1-简单主从集群

docker安装模拟mysql主从复制集群

1. 创建一个主(master)的mysql容器

docker run -p 3307:3306 --name mysql-master \
-v /mydata/mysql/master/log:/var/log/mysql \
-v /mydata/mysql/master/data:/var/lib/mysql \
-v /mydata/mysql/master/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7
参数说明
 -p 3307:3306：将容器的3306端口映射到主机的3307端口
 -v /mydata/mysql/master/log:/var/log/mysql：将配置文件夹挂载到主机
 -v /mydata/mysql/master/log:/var/log/mysql：将日志文件夹挂在到主机
 -v /mydata/mysql/master/data:/var/lib/mysql：将数据文件夹挂在到主机
 -e MYSQL_ROOT_PASSWORD=123456：初始化root用户密码

2. 创建一个从(slave)的mysql容器

docker run -p 3317:3306 --name mysql-slave \
-v /mydata/mysql/slave/log:/var/log/mysql \
-v /mydata/mysql/slave/data:/var/lib/mysql \
-v /mydata/mysql/slave/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7

3. 配置/mydata/mysql/master/conf/my.cnf基本配置

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
# skip-name-resolve不加这句，连接mysql会很慢

4. 配置/mydata/mysql/slave/conf/my.cnf基本配置

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

5. 修改/mydata/mysql/master/conf/my.cnf

server-id=1
log-bin=mysql-bin
read-only=0
binlog-do-db=gulimall

replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
说明
 server-id：唯一标识
 log-bin：log记录，增删改都会记录日志，从数据库通过日志来判断主数据库的变化，从而进行数据同步
 read-only=0：非只读模式
 binlog-do-db：需要同步的数据库
 replicate-ignore-db：不需要同步的数据库，即系统自动生成的数据库

6. 修改/mydata/mysql/slave/conf/my.cnf

server-id=2
log-bin=mysql-bin
read-only=1
binlog-do-db=gulimall

replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

配置好以后，将两者重启。

7. 在master中执行grant replication slave on *.* to 'backup'@'%' identified by '123456';，代表创建一个backup账户，此账户可以访问主节点能够复制日志
   
   查看master状态show master status
   
   从节点中执行change master to master_host='10.12.34.53',master_user='backup',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=0,master_port=3307;，即告诉从节点需要从那个主节点复制数据
   
   启动start slave
   
   查看状态show slave status
   
8. 以上配置好以后，只要在master的mysql创建数据库或者进行增删改，就会自动同步到从数据库中