mysql主主配置文件,mysql 主从配置文件

主机配置文件

[root@linux-i77adb]#cd /usr/local/mysql516-3303/

[root@linux-i77amysql516-3303]#cat my

my.cnf my.cnf.bak my.cnf.bak20130812 mysql-test/

[root@linux-i77amysql516-3303]#cat my

my.cnf my.cnf.bak my.cnf.bak20130812 mysql-test/

[root@linux-i77amysql516-3303]#cat my.cnf |grep -v ^#

[client]

port = 3303

socket = /tmp/mysql3303.sock

[mysqld]

datadir = /data/mysql_data_3303/

port = 3303

socket = /tmp/mysql3303.sock

language = /usr/local/mysql516-3303/share/english/

skip-external-locking

max_allowed_packet = 4M

table_cache = 2048

sort_buffer_size = 8M

read_buffer_size = 8M

read_rnd_buffer_size = 16M

myisam_sort_buffer_size = 128M

key_buffer_size = 512M

thread_cache_size = 64

thread_concurrency = 8

query_cache_size = 0

query_cache_type = 0

query_cache_limit = 2M

tmp_table_size = 128M

ft_min_word_len = 1

max_connections=1024

max_connect_errors=9999

innodb_data_home_dir = /data/mysql_data_3303/

innodb_data_file_path = ibdata1:2G;ibdata2:10M:autoextend

innodb_log_group_home_dir = /data/mysql_data_3303/

innodb_buffer_pool_size = 2048M

innodb_additional_mem_pool_size = 32M

innodb_log_file_size = 128M

innodb_log_buffer_size = 4M

innodb_flush_log_at_trx_commit = 0

innodb_lock_wait_timeout = 50

server-id = 3303

binlog-do-db= xy_db_activity

binlog-do-db= xy_db_activity_test

binlog-do-db= xy_db_community

binlog-do-db= xy_db_community_test

binlog-do-db= xy_db_config

binlog-do-db= xy_db_config_test

binlog-do-db= xy_db_gm

binlog-do-db= xy_db_info

binlog-do-db= xy_db_info_test

binlog-do-db= xy_db_inter

binlog-do-db= xy_db_items

binlog-do-db= xy_db_items_test

binlog-do-db= xy_db_partner

binlog-do-db= xy_db_partner_test

binlog-do-db= db_inner_manage

binlog-ignore-db= mysql

binlog-ignore-db= information_schema

binlog-ignore-db= bak20130531

binlog-ignore-db= kang

binlog-ignore-db= mysql

binlog-ignore-db= mytest

binlog-ignore-db= test

binlog-ignore-db= test2

binlog-ignore-db= test_a

log-bin=/data/mysql_data_3303/bin

binlog-format=mixed

sync_binlog=0

expire_logs_days=7

log-slave-updates

relay-log=relay-bin

log-error=error

log-slow-queries=slow

long_query_time=0.5

sql-mode=STRICT_TRANS_TABLES

default-storage-engine=innodb

lower_case_table_names=1

character-set-server=utf8

skip-name-resolve

wait_timeout = 1200

interactive_timeout = 1200

user = mysql

event_scheduler = on

loose_handlersocket_port = 9998

loose_handlersocket_port_wr = 9999

loose_handlersocket_threads = 16

loose_handlersocket_threads_wr = 1

open_files_limit = 65535

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

default-character-set=utf8

[isamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit = 4096

从机配置文件

[root@linux-250 etc]# cat my.cnf|grep -v ^#

[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld]

port = 3306

socket = /tmp/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 1M

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

log-bin=mysql-bin

binlog_format=mixed

server-id = 2

master-host =192.168.1.213

master-user =backup

master-pass =bak250

master-port =3303

master-connect-retry=60

replicate-do-db = xy_db_activity

replicate-do-db = xy_db_activity_test

replicate-do-db = xy_db_community

replicate-do-db = xy_db_community_test

replicate-do-db = xy_db_config

replicate-do-db = xy_db_config_test

replicate-do-db = xy_db_gm

replicate-do-db = xy_db_info

replicate-do-db = xy_db_info_test

replicate-do-db = xy_db_inter

replicate-do-db = xy_db_items

replicate-do-db = xy_db_items_test

replicate-do-db = xy_db_partner

replicate-do-db = xy_db_partner_test

replicate-do-db = db_inner_manage

replicate-ignore-db= mysql

replicate-ignore-db= information_schema

replicate-ignore-db= bak20130531

replicate-ignore-db= kang

replicate-ignore-db= mysql

replicate-ignore-db= mytest

replicate-ignore-db= test

replicate-ignore-db= test2

replicate-ignore-db= test_a

[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