Skip to content

Instantly share code, notes, and snippets.

@matsumana
Created October 19, 2012 17:59
Show Gist options
  • Save matsumana/3919644 to your computer and use it in GitHub Desktop.
Save matsumana/3919644 to your computer and use it in GitHub Desktop.
MySQL5.6レプリケーションを試す
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
character-set-server=utf8mb4
log-bin=mysql-bin
relay-log=relay-mysql-bin
binlog_format=mixed
log_slave_updates
replicate-ignore-db=information_schema,performance_schema,mysql
innodb_flush_log_at_trx_commit=1
sync_binlog=1
gtid-mode=ON
disable-gtid-unsafe-statements
master-info-repository=TABLE
server-id=3
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment