linux mysql 多个实例配置

最新推荐文章于 2021-05-07 17:05:55 发布

chechione

最新推荐文章于 2021-05-07 17:05:55 发布

阅读量96

点赞数

分类专栏： mysql管理文章标签： MySQL Linux Socket

本文链接：https://blog.csdn.net/chechione/article/details/83891764

版权

mysql管理专栏收录该内容

4 篇文章 0 订阅

订阅专栏

[mysqld_multi]
mysqld     = /opt/server/db/mysql/bin/mysqld_safe
mysqladmin = /opt/server/db/mysql/bin/mysqladmin
user = root

[mysqld1]
server-id = 1
socket = /tmp/mysql-test.sock
port = 3306
pid-file = /var/lib/dbdata/test/mysqld-test.pid
datadir = /var/lib/dbdata/test
log-err = /var/lib/dbdata/test/mysql-test-err
log =      /var/lib/dbdata/test/mysql-test-log
character_set_client = utf8
character_set_server = utf8
default-character-set=utf8
default_table_type = InnoDB
log-queries-not-using-indexes = false
innodb_data_home_dir = /var/lib/dbdata/test
user = mysql

[mysqld2]
server-id = 2
socket = /tmp/mysql-dev.sock
port = 3307
pid-file = /var/lib/dbdata/dev/mysqld-dev.pid
datadir = /var/lib/dbdata/dev
log-err = /var/lib/dbdata/dev/mysql-dev-err
log     = /var/lib/dbdata/dev/mysql-dev-log
character_set_client = utf8
character_set_server = utf8
default-character-set=utf8
default_table_type = InnoDB
log-queries-not-using-indexes = false
innodb_data_home_dir = /var/lib/dbdata/dev
user = mysql

"/etc/my.cnf" 42L, 1097C written