mysql5.5多实例搭建

回复 收藏
先把之前的配置停掉,然后创建实例目录
#pkill  mysqld
#rm -rf /etc/init.d/mysqld
# mkdir -p /data/{3306,3307}/data
blob.png


http://C:\\Users\\Administrator\\AppData\\Local\\YNote\\data\\qq915D90F174F75FFA575F012977B78C06\\83ba4cb129544e7086eca1405f487310\\fa91026088b64a28aff10b35ffe4fa3d.jpg
配置多实例的配置文件
#vim /data/3306/my.cnf
[client]
port = 3306
socket = /data/3306/mysql.sock

[mysql]
no-auto-rehash

[mysqld]
socket = /data/3306/mysql.sock
port = 3306
pid-file = /data/3306/data/mysql.pid
basedir = /usr/local/mysql
datadir = /data/3306/data
server-id=1
log-bin = /data/3306/mysql-bin
#log-bin-index= mysql-bin.index
# LOGGING
log_error=/data/3306/log/mysql-error.log
slow_query_log_file=/data/3306/log/mysql-slow.log
slow_query_log=1
#vim /data/3307/my.cnf
[client]
port = 3307
socket = /data/3307/mysql.sock

[mysql]
no-auto-rehash

[mysqld]
socket = /data/3307/mysql.sock
port = 3307
pid-file = /data/3307/data/mysql.pid
basedir = /usr/local/mysql
datadir = /data/3307/data
server-id=3
#log-bin = /data/3307/mysql-bin
#log-bin-index= mysql-bin.index
# LOGGING
log_error=/data/3307/log/mysql-error.log
slow_query_log_file=/data/3307/log/mysql-slow.log
slow_query_log=1
配置启动脚本:
#vim /data/3306/mysqld
#!/bin/bash
mysql_port=3306
mysql_username="root"
mysql_password="123123"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/${mysql_port}/my.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/usr/local/mysql/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /data/${mysql_port}/mysql.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/${mysql_port}/mysqld {start|stop|restart|kill}";;
esac
#vim /data/3307/mysqld
#!/bin/bash
mysql_port=3307
mysql_username="root"
mysql_password="123123"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/${mysql_port}/my.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/usr/local/mysql/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /data/${mysql_port}/mysql.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/${mysql_port}/mysqld {start|stop|restart|kill}";;
esac

授权mysql管理多个实例数据库
#chown -R mysql:mysql /data
授权可执行
# find /data/ -type f -name "mysqld"|xargs chmod +x
# find /data/ -type f -name "mysqld"|xargs ls -l
QQ图片20170106191931.png


http://C:\\Users\\Administrator\\AppData\\Local\\YNote\\data\\qq915D90F174F75FFA575F012977B78C06\\33ac57b5a24746329c1ce928891ac886\\308a65d346164937a69bbbbdba3cc572.jpg
初始化数据库
#cd /usr/local/mysql/scripts
# ./mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3306/data --user=mysql
# ./mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3307/data --user=mysql
http://C:\\Users\\Administrator\\AppData\\Local\\YNote\\data\\qq915D90F174F75FFA575F012977B78C06\\3752d38229f6457793827dea3f14a689\\clipboard.png
blob.png


http://C:\\Users\\Administrator\\AppData\\Local\\YNote\\data\\qq915D90F174F75FFA575F012977B78C06\\ba37abd887a1479ca8c7b07f4ab013ce\\8a989e0079e04a93b21591c45c528f39.jpg
启动数据库
# /data/3306/mysqld start
# /data/3307/mysqld start
# netstat -lnp|grep 330
http://C:\\Users\\Administrator\\AppData\\Local\\YNote\\data\\qq915D90F174F75FFA575F012977B78C06\\2487df26404f4adbb4562837b386224d\\a73ee6a09e444a45baf8eff13d70d23b.jpg
QQ截图20170106215612.png




2016-09-11 19:17 举报
已邀请:
0

平弟

赞同来自:

不错,学习了

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: