本文引用： http://blog.csdn.net/dream_broken/article/details/77838579
想搭建個mysql主從復(fù)制的環(huán)境，但是資源有限，不想創(chuàng)建多個虛擬機，就用docker來吧。

centos7下安裝docker的方法，博文“docker學(xué)習(xí)2--centos7下安裝”。

docker pull 從官方下載mysql鏡像，速度非常慢,所以就從daocloud下載鏡像吧，速度很快。

docker pull daocloud.io/library/mysql:5.7

image

運行起來，端口分別對應(yīng)3306,3307

image

3306為主，3307為從

進入3306,并查看容器的系統(tǒng)版本

image

發(fā)現(xiàn)用的是debian版本的linux，查找下my.cnf在哪

image

查看my.cnf，發(fā)現(xiàn)里面又指向/etc/mysql/mysql.conf.d/mysql.cnf

cat /etc/mysql/mysql.conf.d/mysqld.cnf

看到

 [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  

這是我們熟悉的mysql配置了，我們指定下編碼和主服務(wù)配置

使用vi的時候，提示not found

root@b5ab3b336918:/etc/mysql/mysql.conf.d# vi /etc/mysql/mysql.conf.d/mysqld.cnf   
bash: vi: command not found 

apt-get install vim失敗。。。不想折騰了，把mysql.conf.d/mysql.cnf的內(nèi)容復(fù)制到window本地來，修改好后，上傳到虛擬機，然后docker run 的時候，使用-v 命令，把mysql.cnf映射到mysql容器吧

退出容器，刪除容器mysql3306,mysql3307

image

虛擬機上準(zhǔn)備好/mysql-3306.cnf，是主庫的配置

  [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  

 character-set-server=utf8  
 default-storage-engine=INNODB  
 sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION  

 server-id=1  
 log_bin=/var/log/mysql/binlog  

從庫配置/mysql-3307.cnf

  [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  

  character-set-server=utf8  
  default-storage-engine=INNODB  
  sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION  

  server-id=2  
  log_bin=/var/log/mysql/binlog  
  innodb_file_per_table=ON  
 skip_name_resolve=ON  
  binlog-format=row  
  log-slave-updates=true  
 relay_log=/var/log/mysql/relay.log  

server-id是唯一的，主從不能相同。

執(zhí)行下邊命令，運行兩個mysql鏡像

 docker run --name mysql3306 -v /mysql-3306.cnf:/etc/mysql/mysql.conf.d/mysql.cnf -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d daocloud.io/library/mysql:5.7  


 docker run --name mysql3307 -v /mysql-3307.cnf:/etc/mysql/mysql.conf.d/mysql.cnf -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -d daocloud.io/library/mysql:5.7  

使用navicat連接3306,3307

image

主庫3306上查詢下SHOW MASTER STATUS

image

從庫3307上，停止slave,并配置主庫master的連接

image

配置主庫連接，使用root用戶

CHANGE MASTER TO MASTER_HOST='192.168.174.136',MASTER_USER='root', MASTER_PASSWORD='123456',MASTER_LOG_FILE='binlog.000003',MASTER_LOG_POS=154;  

注意：MASTER_LOG_FILE='binlog.000003',MASTER_LOG_POS=154;要和主庫3306上面show master的時候得到的數(shù)據(jù)一致

從庫3307啟動start slave

image

查看slave狀態(tài)

image

配置OK了，接著試試在主庫3306上創(chuàng)建數(shù)據(jù)庫、表，看看是否3307也同步

3306上執(zhí)行

CREATE DATABASE test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;  

然后navicat上刷新3307，發(fā)現(xiàn)3307上也創(chuàng)建有test庫了，說明主從同步OK了，可以接著測試創(chuàng)建表、對表的數(shù)據(jù)進行增刪改進行測試

在這從庫配置的時候，還需要stop slave;change XXXX;start slave操作，那如果從庫重啟了，這主從同步是否仍然有效呢？停止3307，然后在3306上創(chuàng)建表，這是3307停止了，肯定沒同步到3307，然后啟動3307，再次檢查數(shù)據(jù)，發(fā)現(xiàn)3306的表同步過來了，說明從庫重啟，同步功能然后存在。

CREATE TABLE `user` (
`id`  int NOT NULL AUTO_INCREMENT ,
`user_name`  varchar(50) NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
;