$ sudo cat /home/mysql/docker-data/3311/conf/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M #datadir=/home/mysql/docker-data/3307/data #socket=/home/mysql/docker-data/3307/mysql.sock character_set_server=utf8 init_connect='SET NAMES utf8' # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 #log-error=/home/mysql/docker-data/3307/logs/mysqld.log #pid-file=/home/mysql/docker-data/3307/mysqld.pid lower_case_table_names=1 # 表名是否小寫 server-id=1403311 log-bin=mysql-bin # 開啟binlog binlog-format=ROW # binlog的格式 auto_increment_increment=1 # 自增的步長，適用于主主復制，為了避免id沖突，步長設置為master的個數 auto_increment_offset=1 # 自增的偏移，主主復制每個master的偏移需要不一致 # binlog-do-db=mstest # 要同步的數據庫 # binlog-ignore-db=mysql # 要忽略的數據庫 #rpl_semi_sync_master_enabled=1 #rpl_semi_sync_master_timeout=10000 啟動mysql：
