Mysql Instances
mysqlmanager –passwd >> /etc/mysqlmanager.passwd
##
##/etc/mysql/my.cnf
##
[mysql.server]
user-manager
[manager]
port =2273
monitoring-interval =2
socket =/var/run/mysqld/manager.sock
pid-file =/var/run/mysqld/manager.pid
password-file =/etc/mysqlmanager.passwd
default-mysqld-path =/usr/sbin/mysqld
bind-address =0.0.0.0
[mysqld1]
user =mysql
port =3307
monitoring-interval =2
server-id =3
character-set-server = utf8
default-character-set = utf8
socket =/var/run/mysqld/mysqld1.sock
pid-file =/var/run/mysqld/mysqld1.pid
mysqld-path =/usr/sbin/mysqld
log-error =/var/log/mysql/mysqld1.err
datadir =/mysql/domain/db/mysqld1
bind-address =0.0.0.0
[mysqld2]
user =mysql
port =3308
monitoring-interval =2
server-id =4
character-set-server = utf8
default-character-set = utf8
socket =/var/run/mysqld/mysqld2.sock
pid-file =/var/run/mysqld/mysqld2.pid
mysqld-path =/usr/sbin/mysqld
log-error =/var/log/mysql/mysqld2.err
datadir =/mysql/domain/db/mysqld2
bind-address =0.0.0.0
[mysqld3]
user =mysql
port =3309
monitoring-interval =2
server-id =5
character-set-server = utf8
default-character-set = utf8
socket =/var/run/mysqld/mysqld3.sock
pid-file =/var/run/mysqld/mysqld3.pid
mysqld-pat h =/usr/sbin/mysqld
log-error =/var/log/mysql/mysqld3.err
datadir =/mysql/domain/db/mysqld3
bind-address =0.0.0.0
#[TEST] mysql -h scotch -P 2273 -u root – p
#optional bind-address =0.0.0.0
#listen on all interfaces
START INSTANCE {instance_name}
STOP INSTANCE {instance_name}
SHOW INSTANCES
SHOW INSTANCE STATUS {instance_name}
SHOW INSTANCE OPTIONS {instance_name}
SHOW {instance_name} LOG FILES
SHOW {instance_name} LOG {ERROR | SLOW | GENERAL} size[,offset_from_end]
SET instance_name.option_name[=option_value]
UNSET instance_name.option_name
FLUSH INSTANCES