Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sudo mysqld_multi report
- Reporting MySQL servers
- MySQL server from group: mysqld1 is not running
- MySQL server from group: mysqld2 is not running
- MySQL server from group: mysqld2 is not running
- [client]
- port = 3306
- socket = /var/lib/mysql/mysql.sock
- [mysqld_safe]
- socket = /var/lib/mysql/mysql.sock
- nice = 0
- [mysqld]
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/lib/mysql/mysql.sock
- port = 3306
- basedir = /usr
- datadir = /var/lib/mysql
- tmpdir = /tmp
- lc-messages-dir = /usr/share/mysql
- skip-external-locking
- key_buffer = 16M
- max_allowed_packet = 16M
- thread_stack = 192K
- thread_cache_size = 8
- myisam-recover = BACKUP
- query_cache_limit = 1M
- query_cache_size = 16M
- log_error = /var/log/mysql/error.log
- [mysqld_multi]
- mysqld = /usr/bin/mysqld_safe
- mysqladmin = /usr/bin/mysqladmin
- user = root
- password =
- [mysqld1]
- server-id = 3
- socket = /var/run/mysqld/mysqld_1.sock
- port = 3307
- pid-file = /var/run/mysqld/mysqld_1.pid
- datadir = /var/lib/mysql_1
- user = mysql
- log_bin = /var/log/mysql_1/mysql-bin.log
- expire_logs_days = 10
- max_binlog_size = 100M
- binlog_do_db = db1
- [mysqld2]
- server-id = 4
- socket = /var/run/mysqld/mysqld_2.sock
- port = 3308
- pid-file = /var/run/mysqld/mysqld_2.pid
- datadir = /var/lib/mysql_2
- user = mysql
- log_bin = /var/log/mysql_2/mysql-bin.log
- expire_logs_days = 10
- max_binlog_size = 100M
- binlog_do_db = db3
- binlog_do_db = db4
- [mysqldump]
- quick
- quote-names
- max_allowed_packet = 1600M
- [mysql]
- #no-auto-rehash # faster start of mysql but no tab completition
- [isamchk]
- key_buffer = 16M
- !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement