Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. symbolic-links=0
  5.  
  6. bind-address=Master 1
  7. port=3306
  8. query_cache_size=16M
  9. query_cache_limit=4M
  10. tmp_table_size=64M
  11. max_heap_table_size=64M
  12. key_buffer_size=32M
  13. table_open_cache=32
  14. innodb_file_per_table=1
  15. max_connections=1000
  16. server_id=2
  17. binlog_format='MIXED'
  18. log-bin=/var/log/mariadb/mariadb-bin.log
  19. max_allowed_packet=1000M
  20. general_log=1
  21. auto_increment_increment=2
  22. auto_increment_offset=2
  23.  
  24.  
  25.  
  26. [mysqld_safe]
  27. log-error=/var/log/mariadb/mariadb.log
  28. pid-file=/var/run/mariadb/mariadb.pid
  29.  
  30. !includedir /etc/my.cnf.d
  31.  
  32. [mysqld]
  33. datadir=/var/lib/mysql
  34. socket=/var/lib/mysql/mysql.sock
  35. bind-address=Master2
  36. port=3306
  37. query_cache_size=16M
  38. query_cache_limit=4M
  39. tmp_table_size=64M
  40. max_heap_table_size=64M
  41. key_buffer_size=32M
  42. table_open_cache=32
  43. innodb_file_per_table=1
  44. #innodb_force_recovery=5
  45. max_connections=1000
  46. server_id=1
  47. binlog_format='MIXED'
  48. log-bin=/var/log/mariadb/mariadb-bin.log
  49. max_allowed_packet=1000M
  50. general_log=1
  51. auto_increment_increment=2
  52. auto_increment_offset=1
  53.  
  54. [mysqld_safe]
  55. log-error=/var/log/mariadb/mariadb.log
  56. pid-file=/var/run/mariadb/mariadb.pid
  57.  
  58. !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement