mysql主从搭建

mysql主从搭建

注意由于mycat不支持mysql 8 在装环境时，装mysql5.7。 假设装mysql8,mycat就不能以docker 环境安装。因为在mysql8 的情况下需要把mycat 的jdbc驱动包替换掉，在docker 环境下没办法进行替换。

在master 机器 下创建

sudo mkdir -p /usr/local/mysql/master/conf.d sudo mkdir -p /usr/local/mysql/master/datadir sudo vim /usr/local/mysql/master/conf.d/my.cnf [mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql secure-file-priv= NULL symbolic-links=0 log-bin=mysql-bin server-id=1 !includedir /etc/mysql/conf.d/

在 slave 机器下创建

sudo mkdir -p /usr/local/mysql/slave/conf.d sudo mkdir -p /usr/local/mysql/slave/datadir sudo vim /usr/local/mysql/slave/conf.d/my.cnf

将server-id 改为2 在portainer 管理工具 下执行

version: "3" services: mysql-master: container_name: master image: mysql restart: always ports: - 3306:3306 volumes: - /usr/local/mysql/master/datadir:/var/lib/mysql - /usr/local/mysql/master/conf.d:/etc/mysql/conf.d environment: - MYSQL_ROOT_PASSWORD=****** networks: - mysql mysql-slave: container_name: slave image: mysql restart: always ports: - 3306:3306 volumes: - /usr/local/mysql/slave/datadir:/var/lib/mysql - /usr/local/mysql/slave/conf.d:/etc/mysql/conf.d environment: - MYSQL_ROOT_PASSWORD=****** networks: - mysql networks: mysql: external: true

进入master 容器

docker exec –it master bash

登录 mysql

Mysql -u root -p

Master 创建 一个slave账户

Create user 'slave'@'%' INENTIFIED BY GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%';

查看master 连接状态

show master status

登录slave后 执行下面命令

登录slave后 执行下面命令

slave change master to master_host ='masterIP', master_user='slaveuser' ,master_log_pos=155 ,master_log_file='mysql-bin.000005' ,master_port=3306,master_password='**********!';

注意：master_log_file，master_log_pos 值需要跟master值对应就刚刚 show master status 查询到的值复制过来

最后查看集群同步状态：

show slave status \G;

这2个参数为YES 代表主从，读写ok Slave_IO_Running : YES Slave_SQL_Running : YES