[mysqld1] # 實例 1 (原默認)
user = mysql
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld1.sock
port = 3306
log-error = /var/log/mysql/mysqld1.error.log
[mysqld2] # 實例 2 (新增)
user = mysql
datadir = /var/lib/mysql2
socket = /var/run/mysqld/mysqld2.sock
port = 3307
pid-file = /var/run/mysqld/mysqld2.pid
bind-address = 127.0.0.1
log-error = /var/log/mysql/mysqld2.error.log
cp -R /var/lib/mysql /var/lib/mysql2
chown -R mysql:mysql /var/lib/mysql2
mkdir -p /var/run/mysqld /var/log/mysql
chown mysql:mysql /var/run/mysqld /var/log/mysql
# 啟動雙實例
mysqld_multi start 1,2
# 檢查進程
ps aux | grep mysql
# 停止雙實例
mysqld_multi stop 1,2
# 針對性操作
mysqld_multi start 2
mysqld_multi report 1,2
# 通過端口
mysql -P 3307 -u root -p
# 通過 Socket (無網絡開銷)
mysql -u root -S /var/run/mysqld/mysqld2.sock -p
在 my.cnf 追加 [mysqld3]、[mysqld4]...,對應創建 datadir、socket、pid-file、port、log-error,mysqld_multi start 1,2,3,4 即可。
innodb_buffer_pool_size,總和 ≤ 物理內存 70%。innodb_log_file_size、innodb_log_files_in_group。tmpdir 避免磁盤爭用。port/socket 標識實例。