一台机器搭建两个MySQL实例配置文件_一台机器配置两个mysql-优快云博客

本文详细介绍了 MySQL 多实例的配置方法，包括不同实例的端口设置、socket 文件路径、PID 文件位置、数据目录、用户权限及各种性能参数如连接数限制、InnoDB 线程并发数等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[mysqld_multi]
mysqld = /mysql/app/mysql/bin/mysqld_safe
mysqladmin = /mysql/app/mysql/bin/mysqladmin
user = root

[mysqld1]
socket = /tmp/mysql_3301.sock
port = 3301
pid-file = /usr/local/percona-mysql/mysql_3301/data/mysql_3301.pid
datadir = /usr/local/percona-mysql/mysql_3301/data/
user = mysql
server-id = 100
log-bin=mysql-bin
max_connections=1024
innodb_thread_concurrency=8
binlog_format=row
innodb_flush_log_at_trx_commit=2
sync_binlog=1
innodb_flush_method=O_DIRECT
innodb_buffer_pool_size=1024M
innodb_log_file_size=256M
max_allowed_packet=16M
max_heap_table_size=256M
tmp_table_size=256M
max_user_connections=512
wait_timeout=31536000
interactive_timeout=31536000
sort_buffer_size=32m
read_buffer_size=32m
table_open_cache=1024
join_buffer_size=32m
lower_case_table_names=1
log-slow-queries = /tmp/slowquery1.log
long_query_time = 1
log_queries_not_using_indexes
query_cache_size = 256M
query_cache_type = 1
log_slave_updates = 1

[mysqld2]
socket = /tmp/mysql_3302.sock
port = 3302
pid-file = /usr/local/percona-mysql/mysql_3302/data/mysql_3301.pid
datadir = /usr/local/percona-mysql/mysql_3302/data/
user = mysql
server-id = 200
log-bin=mysql-bin
max_connections=1024
innodb_thread_concurrency=8
binlog_format=row
innodb_flush_log_at_trx_commit=2
sync_binlog=1
innodb_flush_method=O_DIRECT
innodb_buffer_pool_size=1024M
innodb_log_file_size=256M
max_allowed_packet=16M
max_heap_table_size=256M
tmp_table_size=256M
max_user_connections=512
wait_timeout=31536000
interactive_timeout=31536000
sort_buffer_size=32m
read_buffer_size=32m
table_open_cache=1024
join_buffer_size=32m
lower_case_table_names=1
log-slow-queries = /tmp/slowquery1.log
long_query_time = 1
log_queries_not_using_indexes
query_cache_size = 256M
query_cache_type = 1
log_slave_updates = 1