一台主机部署多个mysqld实例配置

我会带着你远行 2022-01-16 23:07 173阅读 0赞

[为什么80%的码农都做不了架构师？>>> ][80_]  ![hot3.png][]

一台主机部署多个mysqld实例配置 配置选项说明： mysqld\_multi：配置mysqld\_multi命令参数信息 client：客户端参数信息 mysqld：每个实例配置的参数 mysql：命令行工具mysql配置参数 mysqld\_safe：mysqld启动的配置参数 mysqldump：数据备份时参数 myisamchk：myisamchk命令配置参数 \# vim /etc/my.cnf \[mysqld\_multi\] mysqld=/usr/local/mysql-5.5.14/bin/mysqld\_safe mysqladmin=/usr/local/mysql-5.5.14/bin/mysqladmin user=admin password=mysqladmin log=/var/log/multi.log \[client\] \[mysqld3306\] user            = mysql port            = 3306 socket          = /data/mydata3306/mysql.sock pid-file        = /data/mydata3306/mysql.pid datadir         = /data/mydata3306 skip-external-locking skip-name-resolve key\_buffer\_size = 16K max\_allowed\_packet = 1M table\_open\_cache = 4 sort\_buffer\_size = 64K read\_buffer\_size = 256K read\_rnd\_buffer\_size = 256K net\_buffer\_length = 2K thread\_stack = 128K server-id       = 3306 log-bin=mysql-bin-3306 log-bin-index=mysql-bin-3306.index binlog\_format=row \[mysqld3307\] user            = mysql port            = 3307 socket          = /data/mydata3307/mysql.sock pid-file        = /data/mydata3307/mysql.pid datadir         = /data/mydata3307 tmpdir          = /data/mydata3307 skip\_external\_locking skip-name-resolve back\_log        = 100 default-storage-engine = INNODB collation = utf8\_general\_ci max\_connections = 800 max\_connect\_errors = 100000 interactive\_timeout = 172800 connect\_timeout = 10 max\_allowed\_packet = 4M max\_heap\_table\_size = 128M tmp\_table\_size = 128M max\_length\_for\_sort\_data = 4096 net\_buffer\_length = 8K sort\_buffer\_size = 8M join\_buffer\_size = 1M read\_buffer\_size = 1M read\_rnd\_buffer\_size = 2M table\_cache = 1024 thread\_cache\_size = 64 thread\_concurrency = 8 query\_cache\_type = 0 query\_cache\_size = 64M query\_cache\_limit = 1M log-error = /data/mydata3307/error.log log\_warnings long\_query\_time = 1 slow\_query\_log slow\_query\_log\_file = /data/mydata3307/slow-query.log \#log\_slow\_queries = /data/mysqldata3307/log/slow-query.log log\_queries\_not\_using\_indexes binlog\_cache\_size = 8M max\_binlog\_size = 512M log-bin = /data/mydata3307/mysql-bin-3307 log-bin-index = /data/mydata3307/mysql-bin-3307.index expire\_logs\_days = 3 server-id               = 3307 key\_buffer\_size = 32M bulk\_insert\_buffer\_size = 16M myisam\_sort\_buffer\_size = 64M myisam\_max\_sort\_file\_size = 10G myisam\_repair\_threads = 1 myisam\_recover innodb\_file\_per\_table innodb\_flush\_method=O\_DIRECT \[mysqldump\] quick max\_allowed\_packet = 1G \[mysqld\_safe\] open-files-limit = 8192 \[mysql\] no-auto-rehash \[myisamchk\] key\_buffer\_size = 8M sort\_buffer\_size = 8M \[mysqlhotcopy\] interactive-timeout \# ./scripts/mysql\_install\_db --datadir=/data/mydata3306 --user=mysql \# ./scripts/mysql\_install\_db --datadir=/data/mydata3307 --user=mysql \# ./bin/mysqld\_multi start 3306,3307 \# ./bin/mysqld\_multi report 3306,3307 Reporting MySQL servers MySQL server from group: mysqld3306 is running MySQL server from group: mysqld3307 is running \# mysql -uroot -P3306 -S /data/mydata3306/mysql.sock >grant shutdown on \*.\* to ['admin'@'localhost'][admin_localhost] identified by 'mysqladmin'; \# mysql -uroot -P3307 -S /data/mydata3307/mysql.sock >grant shutdown on \*.\* to ['admin'@'localhost'][admin_localhost] identified by 'mysqladmin';

转载于:https://my.oschina.net/766/blog/210982

[80_]: https://my.oschina.net/u/2663968/blog/3051541
[hot3.png]: /images/20220117/46261d46219e4c83babe41942e1cd327.png
[admin_localhost]: mailto:'%20rel=