docker mysql slave 运行

docker run \
        --name=mysql8.0 \
        --hostname=988da3c35887 \
        --env=MYSQL_ROOT_PASSWORD=123456 \
        --env=PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin \
        --env=GOSU_VERSION=1.7 \
        --env=MYSQL_MAJOR=8.0 \
        --env=MYSQL_VERSION=8.0.16-2debian9 \
        --volume=/opt/mysql:/etc/mysql \
        --volume=/data/mysql:/data/mysql \
        --volume=/var/lib/mysql \
        -p 3304:3304 \
        --expose=3306/tcp \
        --expose=33060/tcp \
        --restart=always \
        --detach=true \
        mysql:8.0.16 \
        --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

指定配置文件目录 my.cnf

[mysqld]
default_authentication_plugin=mysql_native_password
mysqlx                  = 0
port                    = 3304
user                    = mysql
datadir                 = /data/mysql/db3304
slave-load-tmpdir       = /data/mysql/tmp/
socket                  = /data/mysql/tmp/my3304.sock
key_buffer_size         = 128M
max_allowed_packet      = 64M
join_buffer_size        = 16M
sort_buffer_size        = 16M
read_buffer_size        = 16M
read_rnd_buffer_size    = 32M
myisam_sort_buffer_size = 128M
tmp_table_size          = 1024M
max_heap_table_size     = 1024M
thread_cache_size       = 64
#thread_concurrency      = 32
max_connections         = 100
max_user_connections    = 0
max_connect_errors      = 99999999
wait_timeout            = 28800
interactive_timeout     = 28800
slow_query_log          = 1
long_query_time         = 0.5
slow_query_log_file     = /data/mysql/db3304/slow.log
back_log                = 600
myisam_repair_threads   = 1
#myisam-recover          = DEFAULT
pid-file                = /data/mysql/db3304/db3304.pid
binlog_format           = row
default_password_lifetime  = 0

character-set-server=utf8mb4
skip-character-set-client-handshake
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4

skip-external-locking
log-slave-updates
skip-name-resolve
skip-slave-start
#have_statement_timeout  = on
master_info_repository  = TABLE
relay_log_info_repository = TABLE

server-id               = 3304
read_only               = ON
log-bin                 = mysql-bin
relay-log               = relay-bin
log-error=error.log
#skip-grant-tables = 1
gtid_mode  = OFF_PERMISSIVE
enforce_gtid_consistency = ON
replicate-do-db = wallet
replicate-do-db = ucenter
#-------------    innodb  --------------
default-storage-engine          = InnoDB
innodb_data_file_path           = ibdata1:100M:autoextend
#innodb_autoextend_increment     = 100M
innodb_flush_log_at_trx_commit  = 1
innodb_log_buffer_size          = 32M
innodb_buffer_pool_size = 2048M
innodb_buffer_pool_chunk_size   = 128M
innodb_log_file_size            = 1000M
innodb_log_files_in_group       = 3
innodb_max_dirty_pages_pct      = 90
innodb_lock_wait_timeout        = 20
innodb_file_per_table           = 1
innodb_flush_method             = O_DIRECT
innodb_io_capacity              = 500
innodb_buffer_pool_instances    = 8
sync_binlog                     = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_filename    = ib_bufferpool.dump
innodb_change_buffer_max_size =  25
innodb_compression_level        = 6
innodb_default_row_format       = dynamic
innodb_purge_threads            = 4
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

#-----slave-----
#log_slow_slave_statements = 1
#slow_query_log_timestamp_always = 1

[client]
user                    = mysql
port                    = 3304
socket                  = /data/mysql/tmp/my3304.sock

[myisamchk]
key_buffer = 400M
sort_buffer_size = 400M
read_buffer = 256M
write_buffe r= 256M