这篇文章给大家介绍如何进行MySQL多实例配置管理,内容非常详细,感兴趣的小伙伴们可以参考借鉴,希望对大家能有所帮助。

MySQL 多实例配置管理配置多实例my.cnf:

[root@open_source3309]#cat/mysql/3307/my.cnf[mysqld]user=mysqlbasedir=/usr/local/mysqldatadir=/mysql/3307/datasocket=/tmp/mysql3307.sockport=3307server_id=7[root@open_source3309]#cat/mysql/3308/my.cnf[mysqld]user=mysqlbasedir=/usr/local/mysqldatadir=/mysql/3308/datasocket=/tmp/mysql3308.sockport=3308server_id=8[root@open_source3309]#cat/mysql/3309/my.cnf[mysqld]user=mysqlbasedir=/usr/local/mysqldatadir=/mysql/3309/datasocket=/tmp/mysql3309.sockport=3309server_id=9初始化多实例

mysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql--datadir=/mysql/3307/data/mysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql--datadir=/mysql/3308/data/mysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql--datadir=/mysql/3309/data/启动多实例:

[root@open_source3309]#mysqld_safe--defaults-file=/mysql/3307/my.cnf&[root@open_source3309]#mysqld_safe--defaults-file=/mysql/3308/my.cnf&[root@open_source3309]#mysqld_safe--defaults-file=/mysql/3309/my.cnf&[root@open_source3309]#ps-ef|grepmysql|grep-vgreproot102517511018:57pts/100:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/mysql/3307/my.cnfmysql1042810251018:57pts/100:00:00/usr/local/mysql/bin/mysqld--defaults-file=/mysql/3307/my.cnf--basedir=/usr/local/mysql--datadir=/mysql/3307/data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--log-error=open_source.err--pid-file=open_source.pid--socket=/tmp/mysql3307.sock--port=3307root104647511018:59pts/100:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/mysql/3308/my.cnfmysql1064110464018:59pts/100:00:01/usr/local/mysql/bin/mysqld--defaults-file=/mysql/3308/my.cnf--basedir=/usr/local/mysql--datadir=/mysql/3308/data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--log-error=open_source.err--pid-file=open_source.pid--socket=/tmp/mysql3308.sock--port=3308root106727511019:00pts/100:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/mysql/3309/my.cnfmysql1084910672019:00pts/100:00:01/usr/local/mysql/bin/mysqld--defaults-file=/mysql/3309/my.cnf--basedir=/usr/local/mysql--datadir=/mysql/3309/data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--log-error=open_source.err--pid-file=open_source.pid--socket=/tmp/mysql3309.sock--port=3309[root@open_source3309]#netstat-anlt|grep33tcp600:::3307:::*LISTENtcp600:::3308:::*LISTENtcp600:::3309:::*LISTEN登录多实例server_id:

[root@open_source3309]#mysql-S/tmp/mysql3307.sock-e"select@@server_id"+-------------+|@@server_id|+-------------+|7|+-------------+[root@open_source3309]#mysql-S/tmp/mysql3308.sock-e"select@@server_id"+-------------+|@@server_id|+-------------+|8|+-------------+[root@open_source3309]#mysql-S/tmp/mysql3309.sock-e"select@@server_id"+-------------+|@@server_id|+-------------+|9|+-------------+停止多实例:

[root@open_source~]#mysqladmin-S/tmp/mysql3307.sockshutdown2020-03-10T00:04:36.491980Zmysqld_safemysqldfrompidfile/mysql/3307/data/open_source.pidended[1]Donemysqld_safe--defaults-file=/mysql/3307/my.cnf(wd:/mysql/3309)(wdnow:~)[root@open_source~]#mysqladmin-S/tmp/mysql3308.sockshutdown2020-03-10T00:04:45.304744Zmysqld_safemysqldfrompidfile/mysql/3308/data/open_source.pidended[2]-Donemysqld_safe--defaults-file=/mysql/3308/my.cnf(wd:/mysql/3309)(wdnow:~)[root@open_source~]#mysqladmin-S/tmp/mysql3309.sockshutdown2020-03-10T00:04:54.383289Zmysqld_safemysqldfrompidfile/mysql/3309/data/open_source.pidended[3]+Donemysqld_safe--defaults-file=/mysql/3309/my.cnf(wd:/mysql/3309)(wdnow:~)

关于如何进行MySQL多实例配置管理就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。