Mysql-多实例配置

数据库 , 评论

Mysql-多实例配置

配置文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
/etc/my.cnf
 
[mysqld_multi]
mysqld=/usr/bin/mysqld_safe
mysqladmin=/usr/bin/mysqladmin
log=/data/mysql/mysqld_multi.log
user=mysql_shutdown                                          #-->关闭用户,只有关闭权限,不配置不能用 mysqld_multi stop命令
password=Sino!Sh!Dbwx!123                               #-->关闭用户密码,安全起见,比标准的少了一个符号
 
[mysqld3306]
port=3306
basedir=/usr
datadir=/data/mysql
socket=/data/mysql/mysql3306.sock
server-id=2
federated
 
# InnoDB settings
innodb_buffer_pool_size=5G
innodb_log_file_size=1G
 
replicate-do-db=test
replicate-ignore-db=mysql
log-slave-updates
slave-skip-errors=all
slave-net-timeout=60

# Other
character-set-server=utf8
collation-server=utf8_general_ci
 
max-connect-errors=6000
max-connections=3000
thread_cache_size = 300
thread_concurrency =32
innodb_thread_concurrency =16
max-connect-errors=6000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1
 
[mysqld3307]
port=3307
basedir=/usr
datadir=/data/mysql3307
socket=/data/mysql3307/mysql3307.sock
server-id=22
federated
 
# InnoDB settings
innodb_buffer_pool_size=5G
innodb_log_file_size=1G
 
replicate-do-db=test
replicate-ignore-db=mysql
log-slave-updates
slave-skip-errors=all
slave-net-timeout=60
 
# Other
character-set-server=utf8
collation-server=utf8_general_ci
 
max-connect-errors=6000
max-connections=3000
thread_cache_size = 300
thread_concurrency =32
innodb_thread_concurrency =16
max-connect-errors=6000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1
 
[mysqld3308]
port=3308
basedir=/usr
datadir=/data/mysql3308
socket=/data/mysql3308/mysql3308.sock
server-id=22
federated
 
# InnoDB settings
innodb_buffer_pool_size=5G
innodb_log_file_size=1G
 
replicate-do-db=test
replicate-ignore-db=mysql
log-slave-updates
slave-skip-errors=all
slave-net-timeout=60
 
# Other
character-set-server=utf8
collation-server=utf8_general_ci
 
max-connect-errors=6000
max-connections=3000
thread_cache_size = 300
thread_concurrency =32
innodb_thread_concurrency =16
max-connect-errors=6000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1

startup and stopd

1
2
3
4
5
6
7
8
9
10
11
12
## start all
mysqld_multi start

## start single
mysqld_multi start 3307

## check status
mysqld_multi report

## stop
mysqld_multi stop
mysqld_multi stop 3307

biglovewheat老年佛系运维

老年佛系运维 | biglovewheat@126.com