小编给大家分享一下Mysql数据库多实例配置的示例分析，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

二进制安装：[root@lufengcentos~]#mkdir/home/lufeng/tools-p[root@lufengcentos~]#cd/home/lufeng/tools[root@lufengcentostools]#rz[root@lufengcentostools]#tarxfmysql-5.5.49-linux2.6-x86_64.tar.gz[root@lufengcentostools]#mkdir-p/application/mysql-5.5.49[root@lufengcentostools]#mvmysql-5.5.49-linux2.6-x86_64/application/mysql-5.5.49创建mysql用户|组[root@lufengcentostools]#groupaddmysql[root@lufengcentostools]#useraddmysql-gmysql-s/sbin/nologin-M[root@lufengcentostools]#ln-s/application/mysql-5.5.49//application/mysqlroot@lufengcentosmysql]#sed-i's#/usr/local/mysql#/application/mysql#g'/application/mysql/bin/mysqld_safe创建多实例数据文件目录[root@Mysql-server_2~]#mkdir-p/data/{3306,3307}/data配置相应的配置文件：[root@Mysql-server_2~]#cat/data/3306/my.cnf####################################################[client]#password=your_passwordport=3306socket=/data/3306/mysql.sock[mysqld]user=mysqlport=3306socket=/data/3306/mysql.sockbasedir=/application/mysqldatadir=/data/3306/datapid-file=/data/3306/mysql.pidrelay-log=/data/3306/relay-binrelay-log-info-file=/data/3306/relay-log.infoskip-external-lockingkey_buffer_size=16Kmax_allowed_packet=1Mtable_open_cache=4sort_buffer_size=64Kread_buffer_size=256Kread_rnd_buffer_size=256Knet_buffer_length=2Kthread_stack=128Kserver-id=1[mysqldump]quickmax_allowed_packet=2M[mysql]no-auto-rehash[mysql_safe]log-error=/data/3306/mysql_lufeng3306.errpid-file=/data/3306/mysqlf.pid##############################################[root@Mysql-server_2~]#cat/data/3307/my.cnf#############################################[client]#password=your_passwordport=3307socket=/data/3307/mysql.sock[mysqld]user=mysqlport=3307socket=/data/3307/mysql.sockbasedir=/application/mysqldatadir=/data/3307/datapid-file=/data/3307/mysql.pidrelay-log=/data/3307/relay-binrelay-log-info-file=/data/3307/relay-log.infoskip-external-lockingkey_buffer_size=16Kmax_allowed_packet=1Mtable_open_cache=4sort_buffer_size=64Kread_buffer_size=256Kread_rnd_buffer_size=256Knet_buffer_length=2Kthread_stack=128Kserver-id=2[mysqldump]quickmax_allowed_packet=2M[mysql]no-auto-rehash[mysql_safe]log-error=/data/3307/mysql_lufeng3307.errpid-file=/data/3307/mysqlf.pid##############################################创建启动文件[root@Mysql-server_2~]#cat/data/3306/mysql#!/bin/sh#################################mysql3306bylufeng@2017.4.3#################################intport=3306mysql_user="root"mysql_pwd="199429"CmdPath="/application/mysql/bin"mysql_sock="/data/${port}/mysql.sock"#startupfunctionfunction_start_mysql(){if[!-e"$mysql_sock"];thenprintf"StartingMySQL...\n"/bin/sh${CmdPath}/mysqld_safe--defaults-file=/data/${port}/my.cnf2>&1>/dev/null&elseprintf"MySQLisrunning...\n"exitfi}#stopfunctionfunction_stop_mysql(){if[!-e"$mysql_sock"];thenprintf"MySQLisstopped...\n"exitelseprintf"StopingMySQL...\n"${CmdPath}/mysqladmin-u${mysql_user}-p${mysql_pwd}-S/data/${port}/mysql.sockshutdownfi}#restartfunctionfunction_restart_mysql(){printf"RestartingMySQL...\n"function_stop_mysqlsleep2function_start_mysql}case$1instart)function_start_mysql;;stop)function_stop_mysql;;restart)function_restart_mysql;;*)printf"Usage:/data/${port}/mysql{start|stop|restart}\n"esac##########################################################[root@Mysql-server_2~]#cat/data/3307/mysql#!/bin/sh#################################mysql3307bylufeng@2017.4.3#################################intport=3307mysql_user="root"mysql_pwd="199429"CmdPath="/application/mysql/bin"mysql_sock="/data/${port}/mysql.sock"#startupfunctionfunction_start_mysql(){if[!-e"$mysql_sock"];thenprintf"StartingMySQL...\n"/bin/sh${CmdPath}/mysqld_safe--defaults-file=/data/${port}/my.cnf2>&1>/dev/null&elseprintf"MySQLisrunning...\n"exitfi}#stopfunctionfunction_stop_mysql(){if[!-e"$mysql_sock"];thenprintf"MySQLisstopped...\n"exitelseprintf"StopingMySQL...\n"${CmdPath}/mysqladmin-u${mysql_user}-p${mysql_pwd}-S/data/${port}/mysql.sockshutdownfi}#restartfunctionfunction_restart_mysql(){printf"RestartingMySQL...\n"function_stop_mysqlsleep2function_start_mysql}case$1instart)function_start_mysql;;stop)function_stop_mysql;;restart)function_restart_mysql;;*)printf"Usage:/data/${port}/mysql{start|stop|restart}\n"esac#######################################################配置多实例文件权限[root@Mysql-server_2~]#chown-Rmysql.mysql/data[root@Mysql-server_2~]#find/data-namemysql|xargschmod700[root@Mysql-server_2~]#find/data-namemysql-execls-l{}\;-rwx------1mysqlmysql9994月313:33/data/3306/mysql-rwx------1mysqlmysql12104月313:35/data/3307/mysql全局变量：[root@Mysql-server_2~]#ls/application/mysql/bin/mysql/application/mysql/bin/mysql[root@Mysql-server_2~]#echo'exportPATH=/application/mysql/bin:$PATH'>>/etc/profile[root@Mysql-server_2~]#tail-1/etc/profileexportPATH=/application/mysql/bin:$PATH[root@Mysql-server_2~]#source/etc/profile[root@Mysql-server_2~]#echo$PATH/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin初始化数据库文件[root@Mysql-server_2scripts]#cd/application/mysql/scripts/[root@Mysql-server_2scripts]#./mysql_install_db--basedir=/application/mysql--datadir=/data/3306/data--user=mysql[root@Mysql-server_2scripts]#./mysql_install_db--basedir=/application/mysql--datadir=/data/3307/data--user=mysqlInstallingMySQLsystemtables...17040313:47:58[Note]/application/mysql/bin/mysqld(mysqld5.5.49)startingasprocess2971...OKFillinghelptables...17040313:47:59[Note]/application/mysql/bin/mysqld(mysqld5.5.49)startingasprocess2980...OK============成功标志启动命令：[root@Mysql-server_2~]#/data/3306/mysqlstartStartingMySQL...[root@Mysql-server_2~]#/data/3307/mysqlstartStartingMySQL...[root@Mysql-server_2~]#netstat-lntup|grepmysqltcp000.0.0.0:33060.0.0.0:*LISTEN3638/mysqldtcp000.0.0.0:33070.0.0.0:*LISTEN3962/mysqld配置开机自启动：[root@Mysql-server_2~]#echo"mysqlmultiinstances">>/etc/rc.local[root@Mysql-server_2~]#echo"/data/3306/mysqlstart">>/etc/rc.local[root@Mysql-server_2~]#echo"/data/3307/mysqlstart">>/etc/rc.local[root@Mysql-server_2~]#tail-3/etc/rc.localmysqlmultiinstances/data/3306/mysqlstart/data/3307/mysqlstart登录：[root@lufengcentos~]#mysql-S/data/3306/mysql.sock安全配置：[root@lufengcentos~]#mysqladmin-uroot-S/data/3307/mysql.sockpassword'199429'[root@lufengcentos~]#mysql-S/data/3306/mysql.sock-uroot-pEnterpassword:

看完了这篇文章，相信你对“Mysql数据库多实例配置的示例分析”有了一定的了解，如果想了解更多相关知识，欢迎关注亿速云行业资讯频道，感谢各位的阅读！