mysql多实例实例化数据库

实例化数据库：/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/m_data/nduoa/db

启动实例数据库： /usr/local/mysql/bin/mysqld_multi --defaults-extra-file=/usr/local/mysql/etc/my.cnf --user=mysql start 3307

停止实例数据库：/usr/local/mysqlinstance/bin/mysqld_multi --defaults-extra-file=/usr/local/mysqlinstance/etc/my.cnf --user=root --password=aibei1010 stop 3310

start slave;

show slave status \G

show master status \G

GRANT REPLICATION SLAVE ON *.* TO ‘repl‘@‘192.168.0.193‘ IDENTIFIED BY ‘aibei1010!!‘;

GRANT REPLICATION SLAVE ON *.* TO ‘repl‘@‘192.168.4.18‘ IDENTIFIED BY ‘aibei1010!!‘;

change master to master_host=‘192.168.0.172‘, master_port=3311, master_user=‘repl‘, master_password=‘aibei1010!!‘, master_log_file=‘mysql-bin.000001‘, master_log_pos=4712;

start slave;

show slave status \G

change master to master_host=‘192.168.0.174‘, master_port=3311, master_user=‘repl‘, master_password=‘aibei1010!!‘, master_log_file=‘mysql-bin.000001‘, master_log_pos=4712;

start slave;

show slave status \G

mkdir /m_data/nduoa/db

mkdir /m_data/nduoa/logs

mkdir /m_data/nduoa/sock

mkdir /m_data/nduoa/run

mkdir /m_data/nduoa/tmp

mkdir /m_data/nduoa/binlogs

mkdir /m_data/nduoa/innodb

mkdir /m_data/nduoa/binlogs/mysql-bin

cp -r /m_data/iapppay/scripts /m_data/onepay

chown -R mysql.mysql /m_data/onepay

本文出自 “我的运维时光” 博客，请务必保留此出处http://aaronsa.blog.51cto.com/5157083/1741502

mysql多实例实例化数据库

原文：http://aaronsa.blog.51cto.com/5157083/1741502