mysql for linux 配置多服务
1.修改/usr/my.cnf参数文件
修改完成后如下:
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = mysql
password = xxxx
[mysqld1]
port = 3307
socket = /u02/mysqldata/mysql.sock1
pid-file=/u02/mysqldata/mysql01.pid
datadir =/u02/mysqldata
innodb_buffer_pool_size=8G
innodb_additional_mem_pool_size=20M
innodb_log_file_size=256M
innodb_log_files_in_group=3
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld2]
port = 3308
socket = /u02/mysqldata2/mysql.sock1
pid-file=/u02/mysqldata2/mysql02.pid
datadir =/u02/mysqldata2
innodb_buffer_pool_size=8G
innodb_additional_mem_pool_size=20M
innodb_log_file_size=256M
innodb_log_files_in_group=3
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
2.把mysql的数据文件移到/usr/my.cnf参数文件中对应的目录.
3.启动/停止数据库通过下面命令.
mysqld_multi --defaults-file=/usr/my.cnf start/stop 1,2
修改完成后如下:
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = mysql
password = xxxx
[mysqld1]
port = 3307
socket = /u02/mysqldata/mysql.sock1
pid-file=/u02/mysqldata/mysql01.pid
datadir =/u02/mysqldata
innodb_buffer_pool_size=8G
innodb_additional_mem_pool_size=20M
innodb_log_file_size=256M
innodb_log_files_in_group=3
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld2]
port = 3308
socket = /u02/mysqldata2/mysql.sock1
pid-file=/u02/mysqldata2/mysql02.pid
datadir =/u02/mysqldata2
innodb_buffer_pool_size=8G
innodb_additional_mem_pool_size=20M
innodb_log_file_size=256M
innodb_log_files_in_group=3
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
2.把mysql的数据文件移到/usr/my.cnf参数文件中对应的目录.
3.启动/停止数据库通过下面命令.
mysqld_multi --defaults-file=/usr/my.cnf start/stop 1,2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28539951/viewspace-1309656/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
