多執行個體MySQL的/etc/my.cnf設定檔

標籤：io   os   for   strong   檔案   on   cti   log   ad   

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin

[mysqld1]
datadir=/mnt/mysql/3306
socket=/tmp/mysql3306.sock
pid-file=/mnt/mysql/mysql3306.pid
log-error=/mnt/logs/mysql/3306/error.log
#general_log=/mnt/logs/mysql/3306/mysql.log

user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
port=3306
server-id=197

log-bin=mysql-bin
skip-external-locking
skip-name-resolve

key_buffer = 256M
max_allowed_packet = 1024M
net_buffer_length = 1M
#table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
ft_min_word_len = 1

query_cache_type = 1
query_cache_size = 64M

read_rnd_buffer_size = 4M
#table_open_cache = 256
thread_concurrency = 4

interactive_timeout=180
wait_timeout=180

long_query_time = 2
log_slow_queries = 1
#slow_query_log_file = /mnt/logs/mysql/3306/slow_query.log

max_connect_errors = 10000
log_bin_trust_function_creators=1

thread_cache_size = 8

innodb_file_per_table

expire_logs_day = 30

#binlog_format=mixed
master-host=42.121.3.42
master-port=3306
master-user=slaverep
master-password=TwirEmU5
#master-connect-retry=60

[mysqld2]
datadir=/mnt/mysql/3307
socket=/tmp/mysql3307.sock
pid-file=/mnt/mysql/mysql3307.pid
log-error=/mnt/logs/mysql/3307/error.log
#general_log=/mnt/logs/mysql/3307/mysql.log

user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
port=3307
server-id=115

log-bin=mysql-bin
skip-external-locking
skip-name-resolve

key_buffer = 256M
max_allowed_packet = 1M
#table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
ft_min_word_len = 1

query_cache_type = 1
query_cache_size = 64M

read_rnd_buffer_size = 4M
#table_open_cache = 256
thread_concurrency = 4

interactive_timeout=180
wait_timeout=180

long_query_time = 2
log_slow_queries = 1
#slow_query_log_file = /mnt/logs/mysql/3307/slow_query.log

max_connect_errors = 10000
log_bin_trust_function_creators=1

thread_cache_size = 8

innodb_file_per_table

expire_logs_day = 30

#binlog_format=mixed
master-host=112.124.34.26
master-port=3306
master-user=slaverep
master-password=TwirEmU5
master-connect-retry=60

[mysqld3]
datadir=/mnt/mysql/3308
socket=/tmp/mysql3308.sock
pid-file=/mnt/mysql/mysql3308.pid
log-error=/mnt/logs/mysql/3308/error.log
#general_log=/mnt/logs/mysql/3308/mysql.log

user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
port=3308
server-id=116

log-bin=mysql-bin
skip-external-locking
skip-name-resolve

key_buffer = 256M
max_allowed_packet = 1024M
net_buffer_length = 1M
#table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
ft_min_word_len = 1

query_cache_type = 1
query_cache_size = 64M

read_rnd_buffer_size = 4M
#table_open_cache = 256
thread_concurrency = 4

interactive_timeout=180
wait_timeout=180

long_query_time = 2
log_slow_queries = 1
#slow_query_log_file = /mnt/logs/mysql/3308/slow_query.log

max_connect_errors = 10000
log_bin_trust_function_creators=1

thread_cache_size = 8

innodb_file_per_table

expire_logs_day = 30

#binlog_format=mixed
master-host=112.124.7.82
master-port=3306
master-user=slaverep
master-password=TwirEmU5
#master-connect-retry=60

多執行個體MySQL的/etc/my.cnf設定檔