Guest User

Untitled

a guest
Apr 22nd, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. [mysqld_multi]
  2. mysqld = /usr/bin/mysqld_safe
  3. mysqladmin = /usr/bin/mysqladmin
  4. user = multi_admin
  5. password = multipass
  6.  
  7. [mysqld1]
  8. server-id = 1
  9. port = 3306
  10. user = mysql
  11. pid-file = /var/run/mysqld/mysqld.pid
  12. socket = /var/run/mysqld/mysqld.sock
  13. datadir = /var/lib/mysql
  14. log-error = /var/log/mysql/error.log
  15. ...
  16.  
  17. [mysqld2]
  18. basedir = /usr
  19. server-id = 2
  20. port = 3307
  21. user = mysql
  22. pid-file = /var/run/mysqld/mysqld_blackhole_slave.pid
  23. socket = /var/run/mysqld/mysqld_blackhole_slave.sock
  24. datadir = /var/lib/mysql_blackhole_slave
  25. log-error = /var/log/mysql_blackhole_slave/error.log
  26. ...
  27.  
  28. sudo mkdir /var/run/mysqld
  29. sudo chown mysql:mysql /var/run/mysqld
Add Comment
Please, Sign In to add comment