Advertisement
Guest User

Untitled

a guest
Jul 18th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. sudo mysqld_multi report
  2. Reporting MySQL servers
  3. MySQL server from group: mysqld1 is not running
  4. MySQL server from group: mysqld2 is not running
  5. MySQL server from group: mysqld2 is not running
  6.  
  7. [client]
  8. port = 3306
  9. socket = /var/lib/mysql/mysql.sock
  10.  
  11. [mysqld_safe]
  12. socket = /var/lib/mysql/mysql.sock
  13. nice = 0
  14.  
  15. [mysqld]
  16. user = mysql
  17. pid-file = /var/run/mysqld/mysqld.pid
  18. socket = /var/lib/mysql/mysql.sock
  19. port = 3306
  20. basedir = /usr
  21. datadir = /var/lib/mysql
  22. tmpdir = /tmp
  23. lc-messages-dir = /usr/share/mysql
  24. skip-external-locking
  25. key_buffer = 16M
  26. max_allowed_packet = 16M
  27. thread_stack = 192K
  28. thread_cache_size = 8
  29. myisam-recover = BACKUP
  30. query_cache_limit = 1M
  31. query_cache_size = 16M
  32. log_error = /var/log/mysql/error.log
  33.  
  34. [mysqld_multi]
  35. mysqld = /usr/bin/mysqld_safe
  36. mysqladmin = /usr/bin/mysqladmin
  37. user = root
  38. password =
  39.  
  40. [mysqld1]
  41. server-id = 3
  42. socket = /var/run/mysqld/mysqld_1.sock
  43. port = 3307
  44. pid-file = /var/run/mysqld/mysqld_1.pid
  45. datadir = /var/lib/mysql_1
  46. user = mysql
  47. log_bin = /var/log/mysql_1/mysql-bin.log
  48. expire_logs_days = 10
  49. max_binlog_size = 100M
  50. binlog_do_db = db1
  51.  
  52. [mysqld2]
  53. server-id = 4
  54. socket = /var/run/mysqld/mysqld_2.sock
  55. port = 3308
  56. pid-file = /var/run/mysqld/mysqld_2.pid
  57. datadir = /var/lib/mysql_2
  58. user = mysql
  59. log_bin = /var/log/mysql_2/mysql-bin.log
  60. expire_logs_days = 10
  61. max_binlog_size = 100M
  62. binlog_do_db = db3
  63. binlog_do_db = db4
  64.  
  65. [mysqldump]
  66. quick
  67. quote-names
  68. max_allowed_packet = 1600M
  69.  
  70. [mysql]
  71. #no-auto-rehash # faster start of mysql but no tab completition
  72.  
  73. [isamchk]
  74. key_buffer = 16M
  75.  
  76. !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement