docker mysql主从复制

本篇基于https://www.cnblogs.com/sweetchildomine/p/7814692.html，进行整合。修改内容包括 以下几点：
1. 实现不同：个人转换为在docker内运行2个mysql容器，对容 器进行单独ip设置,而原文中是两个ip不同的机器或者虚拟机
2. 原文中调用镜像，命令使用了一些镜像id，容器id，对此改用 镜像名称、容器别名 的形式，便于使用。
3.容器设置ip,参考与 http://blog.csdn.net/tzm1921995/article/details/52526661

一、准备工作

1. docker pull mysql:5.7.21  //拉取mysql5.7.21版本的镜像
2. 使用network plugin创建一个新的bridge，然后即可通过–ip 选项自定ip，实现docker 容器固定ip 
   # 1.设置新的bridge,别名br1，ip段根据个人喜好设置即可    
   docker network  create  -d bridge --subnet=192.168.210.0/24 --gateway=192.168.210.1 -o parent=eth0 br1
   # 2. 查看
    docker network ls

二、Master 部分

1. 宿主机持久化mysql data 以及mysql.cnf

 mkdir -pv /usr/local/mysqlData/master/cnf
 mkdir -pv /usr/local/mysqlData/master/data
 # 1. 创建mysql.cnf
   cd /usr/local/mysqlData/master/cnf
   touch mysql.cnf 
 # 2. 编辑mysql.cnf 
    vi /usr/loal/mysqlData/master/cnf/mysql.cnf

 # 3. master mysql.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 = 100  #ip的最后一位，个人设置的masterip为192.168.210.100
    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

2. 启动容器，命名为master

docker run -itd --net=br1 --ip=192.168.210.100 -p 3306:3306 --name master -v /usr/local/mysqlDat