一、MySQL多实例部署
版本:5.7.18
1.软件安装# tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local
# cd /usr/local
# chown -R root.root mysql-5.7.18-linux-glibc2.5-x86_64
# ln -sv mysql-5.7.18-linux-glibc2.5-x86_64 mysql5.7.18
# mkdir /data/{mydata3307,mydata3308}
# chown -R mysql.mysql /data/mydata33*
2.提供多实例服务启动脚本# cd /usr/local/mysql5.7.18
# cp support-files/mysqld_multi.server /etc/init.d/mysqld_multi
# chmod +x /etc/init.d/mysqld_multi
# chkconfig --add mysqld_multi
# vi /etc/init.d/mysqld_multi
export PATH=$PATH:/usr/local/mysql5.7.18/bin
basedir=/usr/local/mysql5.7.18
bindir=/usr/local/mysql5.7.18/bin
3.提供配置文件# cat /etc/my.cnf
[mysql]
#password = 123456
#prompt = [\\u@\\h][\\d]>\\_
socket = /tmp/mysql5.7.18.sock
[client]
#password = 123456
#prompt = [\\u@\\h][\\d]>\\_
socket = /tmp/mysql5.7.18.sock
[mysqld_multi]
mysqld = /usr/local/mysql5.7.18/bin/mysqld_safe
mysqladmin =/usr/local/mysql5.7.18/bin/mysqladmin
log =/data/mydata3307/mysqld_multi.log
# 每个实例都设置统一管理密码,方便使用服务脚本停止实例
user = root
pass = 123456
#初始化需要[mysqld]段配置,否则初始化的时候加载不到[mysqld3307]及[mysqld3308]段中关于设置独立undo表空间及共享表空间大小
[mysqld]
innodb_buffer_pool_size = 4096M
#innodb_buffer_pool_size = 16384M
innodb_undo_log_truncate=ON
innodb_undo_tablespaces = 2
innodb_data_file_path=ibdata1:1G:autoextend
[mysqld3307]
innodb_buffer_pool_size &