mysql主从同步视图_MySQL主从同步

1.MDB

[client]

port = 3306

socket = /usr/local/mysql/mysql.sock

[mysqld]

port = 3306

socket = /usr/local/mysql/mysql.sock

datadir = /usr/local/mysql/var

server-id = 1

log-bin = /data/mysqllog/binlog/mysql-bin

wait_timeout = 300

expire_logs_days = 10

skip-name-resolve

default-character-set = utf8

back_log = 50

max_connections = 1000

max_connect_errors = 32

max_allowed_packet = 16M

table_cache = 2048

binlog_cache_size = 1M

max_heap_table_size = 64M

tmp_table_size = 64M

key_buffer_size = 32M

read_buffer_size = 2M

read_rnd_buffer_size = 16M

bulk_insert_buffer_size = 64M

sort_buffer_size = 8M

join_buffer_size = 8M