搭建Mysql主从复制

[root@localhost mysql]# yum -y install docker
复制

[root@localhost mysql]# docker -v
Docker version 1.13.1, build 0be3e21/1.13.1
复制

[root@localhost mysql]# service docker start
复制

[root@localhost ]# docker run --name mysql1 -p 33061:3306 -e MYSQL_ROOT_PASSWORD=root1234 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
复制

[root@localhost ]# docker run --name mysql2 -p 33062:3306 -e MYSQL_ROOT_PASSWORD=root1234 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
复制

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'root1234';
复制

[root@localhost /]# docker exec -it mysql1 /bin/bash
复制

root@125dfce1b700:/# cat etc/mysql/mysql.conf.d/mysqld.cnf
复制

# Copyright (c) 2014, 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA


#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html


[mysqld]
pid-file  = var/run/mysqld/mysqld.pid
socket    = var/run/mysqld/mysqld.sock
datadir    = var/lib/mysql
#log-error  = var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address  = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
复制

[root@localhost ]# exit
复制

[root@localhost ]# vi mysqld.cnf
复制

opyright (c) 2014, 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA




#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[mysqld]


log-bin=/var/lib/mysql/binlog
server-id=1
binlog-do-db=master_slave_database




pid-file  = var/run/mysqld/mysqld.pid
socket    = var/run/mysqld/mysqld.sock
datadir    = var/lib/mysql
#log-error  = var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address  = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
复制

[root@localhost ]# docker cp ./mysqld.cnf mysql1:/etc/mysql/mysql.conf.d/
复制

[root@localhost ]# docker restart mysql1
复制

show master status;
复制

[mysqld]
server-id=2


pid-file  = /var/run/mysqld/mysqld.pid
socket    = /var/run/mysqld/mysqld.sock
datadir    = /var/lib/mysql
#log-error  = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address  = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
复制

[root@localhost /]# docker restart mysql2
复制

[root@localhost /]# docker exec -it mysql2 /bin/bash
复制

root@490fac23b15d:/# mysql -u root -p 
Enter password: 输入自己设置的mysql密码，然后回车即可，会出现下面内容
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33 MySQL Community Server (GPL)


Copyright (c) 2000, 2021, Oracle and/or its affiliates.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>


复制

mysql> change master to master_host='10.20.60.130',master_port=33061,master_user='rep1',master_password='root1234',master_log_file='binlog.000002',master_log_pos=735;


//返回这条数据，说明成功了：Query OK, 0 rows affected, 2 warnings (0.03 sec)
复制

mysql> show slave status\G;
复制

 Last_IO_Error: error connecting to master 'rep1@10.20.60.130:33061' - retry-time: 60  retries: 969
复制

mysql> stop slave
复制

[root@localhost /]# docker inspect mysql1
复制

mysql> change master to master_host='172.17.0.1',master_port=3306,master_user='rep1',master_password='root1234',master_log_file='binlog.000002',master_log_pos=735;
复制

mysql> start slave;
Query OK, 0 rows affected (0.01 sec)


mysql> show slave status\G;
复制