1 [mysqld_multi]
2 mysqld = /mysql/app/mysql/bin/mysqld_safe
3 mysqladmin = /mysql/app/mysql/bin/mysqladmin
4 user = root
5
6 [mysqld1]
7 socket = /tmp/mysql_3301.sock
8 port = 3301
9 pid-file = /usr/local/percona-mysql/mysql_3301/data/mysql_3301.pid
10 datadir = /usr/local/percona-mysql/mysql_3301/data/
11 user = mysql
12 server-id = 100
13 log-bin=mysql-bin
14 max_connections=1024
15 innodb_thread_concurrency=8
16 binlog_format=row
17 innodb_flush_log_at_trx_commit=2
18 sync_binlog=1
19 innodb_flush_method=O_DIRECT
20 innodb_buffer_pool_size=1024M
21 innodb_log_file_size=256M
22 max_allowed_packet=16M
23 max_heap_table_size=256M
24 tmp_table_size=256M
25 max_user_connections=512
26 wait_timeout=31536000
27 interactive_timeout=31536000
28 sort_buffer_size=32m
29 read_buffer_size=32m
30 table_open_cache=1024
31 join_buffer_size=32m
32 lower_case_table_names=1
33 log-slow-queries = /tmp/slowquery1.log
34 long_query_time = 1
35 log_queries_not_using_indexes
36 query_cache_size = 256M
37 query_cache_type = 1
38 log_slave_updates = 1
39
40 [mysqld2]
41 socket = /tmp/mysql_3302.sock
42 port = 3302
43 pid-file = /usr/local/percona-mysql/mysql_3302/data/mysql_3301.pid
44 datadir = /usr/local/percona-mysql/mysql_3302/data/
45 user = mysql
46 server-id = 200
47 log-bin=mysql-bin
48 max_connections=1024
49 innodb_thread_concurrency=8
50 binlog_format=row
51 innodb_flush_log_at_trx_commit=2
52 sync_binlog=1
53 innodb_flush_method=O_DIRECT
54 innodb_buffer_pool_size=1024M
55 innodb_log_file_size=256M
56 max_allowed_packet=16M
57 max_heap_table_size=256M
58 tmp_table_size=256M
59 max_user_connections=512
60 wait_timeout=31536000
61 interactive_timeout=31536000
62 sort_buffer_size=32m
63 read_buffer_size=32m
64 table_open_cache=1024
65 join_buffer_size=32m
66 lower_case_table_names=1
67 log-slow-queries = /tmp/slowquery1.log
68 long_query_time = 1
69 log_queries_not_using_indexes
70 query_cache_size = 256M
71 query_cache_type = 1
72 log_slave_updates = 1
View Code
浙公网安备 33010602011771号