怎么在mysql中使用mysqld_multi部署一个单机

2025-03-28 技术教程 151

这期内容当中小编将会给大家带来有关怎么在mysql中使用mysqld_multi部署一个单机，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。

一、mysql编译安装：

cd/usr/local/srcwgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gztarzxvfmysql-5.6.35-linux-glibc2.5-x86_64.tar.gzmvmysql-5.6.35-linux-glibc2.5-x86_64/usr/local/mysqlcd/usr/local/mysqluseraddmysqlmkdir-p/data/mysqlchown-Rmysql:mysql/data/mysql./scripts/mysql_install_db--user=mysql--datadir=/data/mysqlcpsupport-files/my-default.cnf/etc/my.cnfcpsupport-files/mysql.server/etc/init.d/mysqld二、准备第一个多实例3307

2.1 创建目录：

mkdir/usr/local/mysql3307chown-Rmysql.mysql/usr/local/mysql3307/mkdir-p/data/mysql3307chown-Rmysql.mysql/data/mysql3307mkdir-p/home/data/mysql3307/binlogchown-Rmysql.mysql/home/data/mysql3307

2.2 配置文件

[root@zhdya01~]#vim/etc/my.cnf#Foradviceonhowtochangesettingspleasesee#http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html#***DONOTEDITTHISFILE.It'satemplatewhichwillbecopiedtothe#***defaultlocationduringinstall,andwillbereplacedifyou#***upgradetoanewerversionofMySQL.[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminlog=/var/log/mysqld_multi.log[mysqld1]socket=/usr/local/mysql3307/mysql.sockport=3307pid-file=/usr/local/mysql3307/mysql.piddatadir=/data/mysql3307log_bin=/home/data/mysql3307/binlogserver-id=1innodb_buffer_pool_size=128Minnodb_flush_log_at_trx_commit=0

2.3 初始化数据库

/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql3307三、准备第二个多实例3308

3.1 创建目录：

mkdir/usr/local/mysql3308chown-Rmysql.mysql/usr/local/mysql3308/mkdir-p/data/mysql3308chown-Rmysql.mysql/data/mysql3308mkdir-p/home/data/mysql3308/binlogchown-Rmysql.mysql/home/data/mysql3308

3.2 配置文件

3.3 初始化数据库

/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql3308四、启动多实例

/etc/init.d/mysqldstartmysqld_multi--defaults-extra-file=/etc/my.cnfstart1,2[root@zhdya01bin]#!netnetstat-lntp-lntpActiveInternetconnections(onlyservers)ProtoRecv-QSend-QLocalAddressForeignAddressStatePID/Programnametcp000.0.0.0:220.0.0.0:*LISTEN1241/sshdtcp00127.0.0.1:250.0.0.0:*LISTEN2087/mastertcp600:::3306:::*LISTEN4406/mysqldtcp600:::3307:::*LISTEN4197/mysqldtcp600:::3308:::*LISTEN3359/mysqldtcp600:::8080:::*LISTEN2222/javatcp600:::22:::*LISTEN1241/sshdtcp600::1:25:::*LISTEN2087/master五、查看启动状态

[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfreportReportingMySQLserversMySQLserverfromgroup:mysqld1isrunningMySQLserverfromgroup:mysqld2isrunning六、停止多实例

[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfstop1,2[root@zhdya01bin]#mysqld_multi--defaults-extra-file=/etc/my.cnfreportReportingMySQLserversMySQLserverfromgroup:mysqld1isnotrunningMySQLserverfromgroup:mysqld2isnotrunning七、各自登录mysql实例

[root@zhdya01bin]#mysql--socket=/usr/local/mysql3307/mysql.sockWelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis1Serverversion:5.6.35-logMySQLCommunityServer(GPL)Copyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>

上述就是小编为大家分享的怎么在mysql中使用mysqld_multi部署一个单机了，如果刚好有类似的疑惑，不妨参照上述分析进行理解。如果想知道更多相关知识，欢迎关注亿速云行业资讯频道。