Docker: MySQL主从

朴灿烈づ我的快乐病毒、 2022-12-29 04:57 178阅读 0赞

master.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 = 1
    
    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
    
     
    
     
    
    slave.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 = 2
    
    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
    
    
    docker run -p 3306:3306 --name master -v /root/master.cnf:/etc/mysql/conf.d/master.cnf -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
    docker run -p 3307:3306 --name slave -v /root/slave.cnf:/etc/mysql/conf.d/slave.cnf -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
    docker run -p 3308:3306 --name slave2 -v /root/slave.cnf:/etc/mysql/conf.d/slave.cnf -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
    
    
    docker exec -it master /bin/bash
    docker exec -it slave /bin/bash
    docker exec -it slave2 /bin/bash
    
    mysql -uroot -p123456
    
    create user 'amadeus' identified by '123456';
    GRANT ALL PRIVILEGES ON *.* TO 'amadeus'@'%' IDENTIFIED BY '123456'; 
    FLUSH PRIVILEGES;
    
    show master status;
    
    
    
    
    
    
    
    change master to master_host='192.168.183.235', master_port=3306,master_user='amadeus',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=0;
    start slave;
    show slave status\G;