MYSQL多实例配置方法
作者:应用开发 来源:人工智能 浏览: 【大中小】 发布时间:2025-11-04 19:25:52 评论数:
实例复制[mysqld_multi] mysqld = /usr/local/mysql/bin/mysqld_safe mysqladmin = /usr/local/mysql/bin/mysqladmin user = your_user password = your_password [mysqld1] datadir = /data/db/my1 #连接 port = 3306 socket = /tmp/mysql3306.sock #binlog log-bin=/data/db/mylog1/mysql-bin binlog_format=mixed binlog_cache_size = 32M expire_logs_days = 30 [mysqld2] datadir = /data/db/my2 #连接 port = 3307 socket = /tmp/mysql3307.sock #binlog log-bin=/data/db/mylog2/mysql-bin binlog_format=mixed binlog_cache_size = 32M expire_logs_days = 3 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.