多实例
-多套后台进程+线程+内存结构
-多个配置文件
多端口
多socket文件
多个日志文件
多个server_id
-多套数据
实战配置
#创建数据目录
[root@servera ~]# mkdir -p /data/330{8..9}
#创建配置文件
[root@servera ~]# touch /data/330{8..9}/my.cnf
[root@servera ~]# touch /data/330{8..9}/mysql.log
#编辑3308配置文件
vim /data/3308/my.cnf
[mysqld]
basedir=/application/mysql
datadir=/data/3308/data
socket=/data/3308/mysql.sock
log_error=/data/3308/mysql.log
log-bin=/data/3308/mysql-bin
server_id=8
port=3308
[client]
socket=/data/3308/mysql.sock
#编辑3309配置文件
vim /data/3309/my.cnf
[mysqld]
basedir=/application/mysql
datadir=/data/3309/data
socket=/data/3309/mysql.sock
log_error=/data/3309/mysql.log
log-bin=/data/3309/mysql-bin
server_id=9
port=3309
[client]
socket=/data/3309/mysql.sock
#初始化3308数据
[root@servera data]# /application/mysql/scripts/mysql_install_db \
--user=mysql \
--defaults-file=/data/3308/my.cnf \
--basedir=/application/mysql --datadir=/data/3308/data
#初始化3309数据
[root@servera data]# /application/mysql/scripts/mysql_install_db \
--user=mysql \
--defaults-file=/data/3309/my.cnf \
--basedir=/application/mysql --datadir=/data/3309/data
#修改目录权限
[root@servera data]# chown -R mysql.mysql /data/330*
#启动多实例
[root@servera data]# mysqld_safe --defaults-file=/data/3308/my.cnf &
[root@servera data]# mysqld_safe --defaults-file=/data/3309/my.cnf &
#查看server_id
[root@servera data]# mysql -S /data/3308/mysql.sock -e "show variables like 'server_id'"
[root@servera data]# mysql -S /data/3309/mysql.sock -e "show variables like 'server_id'"
# 进入单独的mysql实例
mysql -S /data/3307/mysql.sock -uroot
# 关闭实例
mysqladmin -S /data/3308/mysql.sock -uroot shutdown
mysqladmin -S /data/3309/mysql.sock -uroot shutdown报错
在初始化新的数据库时
WARNING: Found existing config file /application/mysql/my.cnf on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as /application/mysql/my-new.cnf,
please compare it with your file and take the changes you need.
暂时无法解决
Comments | NOTHING