Mysqld_multi可以管理多個(gè)幀聽不同Unix套接字文件和TCP/IP端口的連接的mysqld 進(jìn)程。它可以啟動(dòng)或停止服務(wù)器，或報(bào)告它們的當(dāng)前狀態(tài)。
即可以管理多個(gè)實(shí)例。
筆者在之前也介紹過使用mysqld_safe啟用多實(shí)例的方法，啟動(dòng)和關(guān)閉都指定配置文件，實(shí)例間是對(duì)立的，互不影響。成功的部署了多個(gè)實(shí)例主從Replication，今天也介紹下mysql_multi多實(shí)例管理，配置簡(jiǎn)單，方便管理。
1、首先配置my.cnf文件，列出我的Mysql配置文件：
[mysqld_multi]mysqld = /usr/local/mysql/bin/mysqld_safe #根據(jù)自己的mysql目錄配置mysqladmin = /usr/local/mysql/bin/mysqladmin[mysqld1]port = 3306socket = /tmp/mysql3306.sockbasedir=/usr/local/mysqldatadir=/mysqldata/data3306log-slow-queries=slow_query.txtlong_query_time=2skip-lockingskip-name-resolveskip-innodbmax_allowed_packet = 256Mquery_cache_size=256Mmax_connections=2000max_connect_errors=10000key_buffer_size=6000Mread_buffer_size=32Mread_rnd_buffer_size = 32Mmyisam_sort_buffer_size=512Mtmp_table_size=1024Mold-passwordsinteractive_timeout=60wait_timeout=60connect_timeout=60table_cache=8192thread_cache_size=512sort_buffer_size=128Mback_log = 500thread_concurrency=48expire_logs_days=10log-bin=mysql-bin[mysqld2]port = 3307socket = /tmp/mysql3307.sockbasedir=/usr/local/mysqldatadir=/mysqldata/data3307log-slow-queries=slow_query.txtlong_query_time=2skip-lockingskip-name-resolveskip-innodbmax_allowed_packet = 256Mquery_cache_size=256Mmax_connections=2000max_connect_errors=10000key_buffer_size=6000Mread_buffer_size=32Mread_rnd_buffer_size = 32Mmyisam_sort_buffer_size=512Mtmp_table_size=1024Mold-passwordsinteractive_timeout=60wait_timeout=60connect_timeout=60table_cache=8192thread_cache_size=512sort_buffer_size=128Mback_log = 500thread_concurrency=48expire_logs_days=10log-bin=mysql-bin[mysqldump]quickmax_allowed_packet = 512M[mysql]no-auto-rehash[isamchk]key_buffer = 512Msort_buffer_size = 32Mread_buffer = 2Mwrite_buffer = 2M[myisamchk]key_buffer = 512Msort_buffer_size = 32Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout
2、初始化數(shù)據(jù)庫(kù)目錄：
shell>cd /usr/local/mysql/;./scripts/mysql_install_db --datadir=/mysqldata/data3307/ --user=mysqlshell>cd /usr/local/mysql/;./scripts/mysql_install_db --datadir=/mysqldata/data3306/ --user=mysql
初始話成功，會(huì)提示OK，否則查看數(shù)據(jù)庫(kù)目錄是否有權(quán)限。 不初始發(fā)數(shù)據(jù)庫(kù)目錄，mysql會(huì)啟動(dòng)不了！
3、啟動(dòng)多實(shí)例：
shell>/usr/local/mysql/bin/mysqld_multi start 1-2或shell>/usr/local/mysql/bin/mysqld_multi start 1shell>/usr/local/mysql/bin/mysqld_multi start 2
注意這里的1、2對(duì)應(yīng)my.cnf配置文件 mysqld1、mysqld2，以此來區(qū)分。
4、本機(jī)登錄Mysql，如3307端口：
shell>mysql -S /tmp/mysql3307.sockmysql> show variables like 'datadir';+---------------+----------------------+| Variable_name | Value |+---------------+----------------------+| datadir | /mysqldata/data3307/ |+---------------+----------------------+1 row in set (0.00 sec)
4、關(guān)閉數(shù)據(jù)庫(kù)實(shí)例
shell>/usr/local/mysql/bin/mysqld_multi stop 1-2或shell>/usr/local/mysql/bin/mysqld_multi stop 1shell>/usr/local/mysql/bin/mysqld_multi stop 2
聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Copyright ? 2019-2024 51dongshi.com 版權(quán)所有
違法及侵權(quán)請(qǐng)聯(lián)系：TEL:177 7030 7066 E-MAIL:11247931@qq.com 本站由北京市萬商天勤律師事務(wù)所王興未律師提供法律服務(wù)
