How To Config more Mysql on GUN/Linux
Mysql应用体系结构及端口
/Data/apps:3306
/app_1:9306
/app_2:8306
/app_3:7306
+++++++++++++
1、 建立app_X文件夹
建立app_1、app_2、app_3
#cd /Data
#mkdir app_1,mkdir app_2,mkdir app_3
复制缺省的mysql/var/mysql到 /data/app_1/目录下，
#cd /Data/apps/mysql/var/
#cd /Data/apps/mysql/var/
#cp –r ./mysql /Data/app_1/
#cd /Data/app_1/
#cp –r * ../app_2/
#cp –r * ../app_3/
2、 建立开启、关闭脚本并修改相应的权限
/Data/app_1/下建立start_mysql.sh和stop_mysql.sh
#vi start_mysql.sh
#!/bin/sh
rundir=`dirname “$0″`
echo “$rundir”
/Data/apps/mysql/bin/mysqld_safe –user=root –pid-file=”$rundir”/mysql.pid –datadir=”$rundir” “$@”\
-O max_connections=500 -O wait_timeout=600 -O key_buffer=32M –port=9306 –socket=”$rundir”/mysql.sock &
#vi stop_mysql.sh
#vi stop_mysql.sh
#!/bin/sh
rundir=`dirname “$0″`
echo “$rundir”
/Data/apps/mysql/bin/mysqladmin -u root -p -S”$rundir”/mysql.sock shutdown
#chmod 755 st*
#cp st* ../app_2/
#cp st* ../app_3/
修改/Data/app_2/中start_mysql.sh对应端口为8306
/Data/app_3/中start_mysql.sh对应端口为7306
3、 启动、连接、停止9306,8306,7306 mysql服务器
#cd /Data/app_1
#./start_mysql.sh
#mysql –user=root –port=9306 –socket=./mysql.sock
#./stop_mysql.sh
同样/app_2,/app_3
#cd /Data/app_2
#./start_mysql.sh
#mysql –user=root –port=8360 –socket=./mysql.sock
#cd /Data/app_3
#mysql –user=root –port=7306 –socket=./mysql.sock
[root@localhost app_4]# netstat -ltunp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:6306 0.0.0.0:* LISTEN 3427/mysqld
tcp 0 0 0.0.0.0:7306 0.0.0.0:* LISTEN 3333/mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 29572/mysqld
tcp 0 0 0.0.0.0:8306 0.0.0.0:* LISTEN 3263/mysqld
tcp 0 0 0.0.0.0:9306 0.0.0.0:* LISTEN 3099/mysqld
tcp 0 0 :::80 :::* LISTEN 2548/httpd
tcp 0 0 :::22 :::* LISTEN 2459/sshd
[root@localhost app_4]#
4、常见问题
A、如果启动时候出现A mysqld process already exists,请删除mysql.pid让其自动生成一个
rm mysql.pid
然后运行./start_mysql.sh
B、当启动时出现
-bash: ./start_mysql.sh: Permission denied
Starting mysqld daemon with databases from .
STOPPING server from pid file ././mysql.pid
051119 16:35:59 mysqld ended
运行chown -R mysql.mysql /Data
3、 启动、连接、停止9306,8306,7306 mysql服务器
#cd /Data/app_1
#./start_mysql.sh
#mysql –user=root –port=9306 –socket=./mysql.sock
#./stop_mysql.sh
同样/app_2,/app_3
#cd /Data/app_2
#./start_mysql.sh
#mysql –user=root –port=8360 –socket=./mysql.sock
#cd /Data/app_3
#mysql –user=root –port=7306 –socket=./mysql.sock
[root@localhost app_4]# netstat -ltunp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:6306 0.0.0.0:* LISTEN 3427/mysqld
tcp 0 0 0.0.0.0:7306 0.0.0.0:* LISTEN 3333/mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 29572/mysqld
tcp 0 0 0.0.0.0:8306 0.0.0.0:* LISTEN 3263/mysqld
tcp 0 0 0.0.0.0:9306 0.0.0.0:* LISTEN 3099/mysqld
tcp 0 0 :::80 :::* LISTEN 2548/httpd
tcp 0 0 :::22 :::* LISTEN 2459/sshd
[root@localhost app_4]#
4、常见问题
A、如果启动时候出现A mysqld process already exists,请删除mysql.pid让其自动生成一个
rm mysql.pid
然后运行./start_mysql.sh
B、当启动时出现
-bash: ./start_mysql.sh: Permission denied
Starting mysqld daemon with databases from .
STOPPING server from pid file ././mysql.pid
051119 16:35:59 mysqld ended
运行chown -R mysql.mysql /Data
3、 启动、连接、停止9306,8306,7306 mysql服务器
#cd /Data/app_1
#./start_mysql.sh
#mysql –user=root –port=9306 –socket=./mysql.sock
#./stop_mysql.sh
同样/app_2,/app_3
#cd /Data/app_2
#./start_mysql.sh
#mysql –user=root –port=8360 –socket=./mysql.sock
#cd /Data/app_3
#mysql –user=root –port=7306 –socket=./mysql.sock
[root@localhost app_4]# netstat -ltunp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:6306 0.0.0.0:* LISTEN 3427/mysqld
tcp 0 0 0.0.0.0:7306 0.0.0.0:* LISTEN 3333/mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 29572/mysqld
tcp 0 0 0.0.0.0:8306 0.0.0.0:* LISTEN 3263/mysqld
tcp 0 0 0.0.0.0:9306 0.0.0.0:* LISTEN 3099/mysqld
tcp 0 0 :::80 :::* LISTEN 2548/httpd
tcp 0 0 :::22 :::* LISTEN 2459/sshd
[root@localhost app_4]#
4、常见问题
A、如果启动时候出现A mysqld process already exists,请删除mysql.pid让其自动生成一个
rm mysql.pid
然后运行./start_mysql.sh
B、当启动时出现
-bash: ./start_mysql.sh: Permission denied
Starting mysqld daemon with databases from .
STOPPING server from pid file ././mysql.pid
051119 16:35:59 mysqld ended
运行chown -R mysql.mysql /Data
没有评论▼