mysqld_multi被设计为了管理实现多个mysqld服务进程
配置如下：
1.创建数据目录
[root@mysqldb test]# cd /u01/mysql
[root@mysqldb test]# mkdir data1
[root@mysqldb test]# mkdir data2
2.初始化数据库
[root@mysqldb test]# mysql_install_db --datadir=/mysql/data1/ --user=mysql
[root@mysqldb test]# mysql_install_db --datadir=/mysql/data2/ --user=mysql
3.配置mysqld的多实例my.cnf文件
[mysqld_multi]
mysqld =/usr/bin/mysqld_safe
mysqladmin =/usr/bin/mysqladmin
#user =test
#password =test
[mysqld1]
port = 3307
socket = /tmp/mysql1.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
datadir = /u01/mysql/data1
server-id = 1
[mysqld2]
port = 3308
socket = /tmp/mysql2.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
datadir = /u01/mysql/data2
server-id = 1
4.多实例数据库的启停
---启动单个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf start 1
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8388 1 3 02:12 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3307 --socket=/tmp/mysql1.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data1 --server-id=1
mysql 8782 8388 20 02:12 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data1 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data1/mysqldb.err --pid-file=/u01/mysql/data1/mysqldb.pid --socket=/tmp/mysql1.sock --port=3307
root 8807 5772 0 02:12 pts/1 00:00:00 grep mysql
---停止单个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf stop 1
[root@mysqldb mysql]#
[root@mysqldb mysql]#
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8382 5772 0 02:12 pts/1 00:00:00 grep mysql
--启动多个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf start 1-2
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8388 1 0 02:12 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3307 --socket=/tmp/mysql1.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data1 --server-id=1
mysql 8782 8388 0 02:12 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data1 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data1/mysqldb.err --pid-file=/u01/mysql/data1/mysqldb.pid --socket=/tmp/mysql1.sock --port=3307
root 8827 1 0 02:13 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3308 --socket=/tmp/mysql2.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data2 --server-id=1
mysql 9588 8827 4 02:13 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data2 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data2/mysqldb.err --pid-file=/u01/mysql/data2/mysqldb.pid --socket=/tmp/mysql2.sock --port=3308
root 9613 5772 0 02:13 pts/1 00:00:00 grep mysql
--停止多个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf stop 1-2
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 9634 5772 0 02:14 pts/1 00:00:00 grep mysql
配置如下：
1.创建数据目录
[root@mysqldb test]# cd /u01/mysql
[root@mysqldb test]# mkdir data1
[root@mysqldb test]# mkdir data2
2.初始化数据库
[root@mysqldb test]# mysql_install_db --datadir=/mysql/data1/ --user=mysql
[root@mysqldb test]# mysql_install_db --datadir=/mysql/data2/ --user=mysql
3.配置mysqld的多实例my.cnf文件
[mysqld_multi]
mysqld =/usr/bin/mysqld_safe
mysqladmin =/usr/bin/mysqladmin
#user =test
#password =test
[mysqld1]
port = 3307
socket = /tmp/mysql1.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
datadir = /u01/mysql/data1
server-id = 1
[mysqld2]
port = 3308
socket = /tmp/mysql2.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
datadir = /u01/mysql/data2
server-id = 1
4.多实例数据库的启停
---启动单个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf start 1
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8388 1 3 02:12 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3307 --socket=/tmp/mysql1.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data1 --server-id=1
mysql 8782 8388 20 02:12 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data1 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data1/mysqldb.err --pid-file=/u01/mysql/data1/mysqldb.pid --socket=/tmp/mysql1.sock --port=3307
root 8807 5772 0 02:12 pts/1 00:00:00 grep mysql
---停止单个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf stop 1
[root@mysqldb mysql]#
[root@mysqldb mysql]#
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8382 5772 0 02:12 pts/1 00:00:00 grep mysql
--启动多个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf start 1-2
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 8388 1 0 02:12 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3307 --socket=/tmp/mysql1.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data1 --server-id=1
mysql 8782 8388 0 02:12 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data1 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data1/mysqldb.err --pid-file=/u01/mysql/data1/mysqldb.pid --socket=/tmp/mysql1.sock --port=3307
root 8827 1 0 02:13 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --port=3308 --socket=/tmp/mysql2.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --datadir=/u01/mysql/data2 --server-id=1
mysql 9588 8827 4 02:13 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u01/mysql/data2 --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-external-locking --key-buffer-size=16M --max-allowed-packet=1M --table-open-cache=64 --sort-buffer-size=512K --net-buffer-length=8K --read-buffer-size=256K --read-rnd-buffer-size=512K --myisam-sort-buffer-size=8M --log-bin=mysql-bin --binlog-format=mixed --server-id=1 --log-error=/u01/mysql/data2/mysqldb.err --pid-file=/u01/mysql/data2/mysqldb.pid --socket=/tmp/mysql2.sock --port=3308
root 9613 5772 0 02:13 pts/1 00:00:00 grep mysql
--停止多个实例
[root@mysqldb mysql]# mysqld_multi --defaults-file=/etc/my.cnf stop 1-2
[root@mysqldb mysql]# ps -ef|grep mysql
avahi 2689 1 0 Aug16 ? 00:00:00 avahi-daemon: running [mysqldb.local]
root 9634 5772 0 02:14 pts/1 00:00:00 grep mysql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-1774045/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mysql的二进制日志
下一篇：
管理mysql二进制日志
请登录后发表评论
登录
全部评论
