Advertisement
tkdhanasekar

mysql config file

Aug 16th, 2021
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. first master server config file
  2.  
  3. [mysqld]
  4. user = mysql
  5. bind-address = 0.0.0.0
  6. mysqlx-bind-address = 127.0.0.1
  7. key_buffer_size = 16M
  8. myisam-recover-options = BACKUP
  9. log_error = /var/log/mysql/error.log
  10. server-id = 1
  11. log_bin = /var/log/mysql/mysql-bin.log
  12. max_binlog_size = 100M
  13.  
  14.  
  15. second master server config file
  16.  
  17. [mysqld]
  18. user = mysql
  19. bind-address = 0.0.0.0
  20. mysqlx-bind-address = 127.0.0.1
  21. key_buffer_size = 16M
  22. myisam-recover-options = BACKUP
  23. log_error = /var/log/mysql/error.log
  24. server-id = 2:wq
  25. log_bin = /var/log/mysql/mysql-bin.log
  26. max_binlog_size = 100M
  27.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement