mysql mysqld_multi_利用mysqld_multi启动管理多实例

利用mysqld_multi启动管理多实例

官方管理多实例的一个脚本peer

#将之前的目录清空

[root@mysql01 mysql]# tree /data/mysql/

/data/mysql/

├──mysql_3306

│├──data

│├──logs

│├──my3306.cnf

│└──tmp

├──mysql_3307

│├──data

│├──logs

│├──my3307.cnf

│└──tmp

└──yejr_3306

#3307目录规划

3306

/data/mysql/mysql_3306/{data,logs,tmp}

/data/mysql/mysql_3306/my3306.cnf

3307

/data/mysql/mysql_3307/{data,logs,tmp}

/data/mysql/mysql_3307/my3307.cnf

[root@mysql01 ~]# cat /etc/my.cnf

#my.cnf

[client]

port            = 3306

socket          = /tmp/mysql.sock

[mysql]

prompt="\\u@\\h [\\d]>"

#pager="less -i -n -S"

#tee=/opt/mysql/query.log

no-auto-rehash

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

log = /opt/mysql/mysqld_multi.log

user =mdev

password = mdev4admin

[mysqld]

#misc

user = mysql

basedir = /usr/local/mysql

datadir = /data/mysql/mysql_3306/data

port = 3306

socket = /tmp/mysql.sock

event_scheduler = 0

tmpdir = /data/mysql/mysql_3306/tmp

#timeout

interactive_timeout = 300

wait_timeout = 300

#character set

character-set-server = utf8

open_files_limit = 65535

max_connections = 100

max_connect_errors = 100000

#lower_case_table_names =1

#logs

log-output=file

slow_query_log = 1

slow_query_log_file = slow.log

log-error = error.log

log_warnings = 2

pid-file = mysql.pid

long_query_time = 1

#log-slow-admin-statements = 1

#log-queries-not-using-indexes = 1

log-slow-slave-statements = 1

#binlog

#binlog_format = STATEMENT

binlog_format = row

server-id = 23306

log-bin = /data/mysql/mysql_3306/logs/mysql-bin

binlog_cache_size = 4M