mysql实例化_mysql多实例实例化数据库

最新推荐文章于 2022-01-17 08:00:00 发布

weixin_39768645

最新推荐文章于 2022-01-17 08:00:00 发布

阅读量57

点赞数

文章标签： mysql实例化

本文链接：https://blog.csdn.net/weixin_39768645/article/details/113289898

版权

实例化数据库：/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