The my.cnf of a MySQL master

[Mysqld]

Port= 3306

Socket=/tmp/mysql.sock

Datadir=/data/mysql/data

Server-id= 1

Skip-name-resolve

Expire_logs_days=15

Log-bin=mysql-bin

Binlog_format=mixed

Replicate-do-db=allin_platform

Replicate-do-db=allin_platform_log

Slow_query_log = On

Long_query_time = 2

Slow_query_log_file=/data/mysql/data/mysql-master-slow.log

#explicit_defaults_for_timestamp =true

Query_cache_type=1

Key_buffer_size = 512M

Max_allowed_packet = 8M

#table_open_cache = 2000

Sort_buffer_size = 16M

#net_buffer_length = 8K

Read_buffer_size = 32M

#read_rnd_buffer_size = 256K

Myisam_sort_buffer_size = 16M

Default-storage-engine=innodb

max_connections=500

innodb_log_buffer_size=16m

innodb_buffer_pool_size=2048m

Character_set_server=utf8

Innodb_sort_buffer_size = 8M

#innodb_buffer_pool_instances = 8

#innodb_flush_log_at_trx_commit = 1

Innodb_file_per_table = OFF

#open_files_limit = 10000

Query_cache_limit = 4M

Query_cache_size = 512M

[Client]

Port = 3306

Socket =/tmp/mysql.sock

[Mysqldump]

Quick

Max_allowed_packet = 16M

[MySQL]

No-auto-rehash

[Myisamchk]

Key_buffer_size = 20M

Sort_buffer_size = 20M

Read_buffer = 2M

Write_buffer = 2M

[Mysqlhotcopy]

Interactive-timeout

The my.cnf of a MySQL master