Advertisement
Guest User

Untitled

a guest
Oct 15th, 2016
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.35 KB | None | 0 0
  1. mysql> change master to
  2. -> master_host = 'master.com',
  3. -> master_user = 'replica',
  4. -> master_password = 'password',
  5. -> master_port = 3306,
  6. -> MASTER_CONNECT_RETRY = 5,
  7. -> MASTER_RETRY_COUNT = 0,
  8. -> MASTER_AUTO_POSITION=1;
  9.  
  10. [mysqld]
  11. user = mysql
  12. pid-file = /var/run/mysqld/mysqld.pid
  13. socket = /var/run/mysqld/mysqld.sock
  14. port = 3306
  15. basedir = /usr
  16. datadir = /data/mysql_data
  17. tmpdir = /tmp
  18. lc-messages-dir = /usr/share/mysql
  19. skip-external-locking
  20.  
  21. binlog-format = MIXED
  22.  
  23. interactive_timeout=180
  24. wait_timeout=180
  25.  
  26. key_buffer = 16M
  27. max_allowed_packet = 16M
  28. thread_stack = 192K
  29. thread_cache_size = 8
  30.  
  31. myisam-recover = BACKUP
  32. max_connections = 300
  33.  
  34. query_cache_limit = 1M
  35. query_cache_size = 16M
  36.  
  37. general_log = 1
  38. log_error = /var/log/mysql/error.log
  39. server-id = 1
  40. log_bin = /var/log/mysql/mysql-bin.log
  41. log_bin_trust_function_creators = 1
  42. log-slave-updates = true
  43.  
  44. # enable GTID
  45. gtid-mode = on
  46. enforce-gtid-consistency = true
  47. master-info-repository=TABLE
  48. relay-log-info-repository=TABLE
  49. sync-master-info=1
  50. binlog-checksum=CRC32
  51. master-verify-checksum=1
  52.  
  53. expire_logs_days = 10
  54. max_binlog_size = 100M
  55.  
  56. [mysqld]
  57. user = mysql
  58. pid-file = /var/run/mysqld/mysqld.pid
  59. socket = /var/run/mysqld/mysqld.sock
  60. port = 3306
  61. basedir = /usr
  62. datadir = /data/mysql_data
  63. tmpdir = /data/mysql_data/tmp
  64. lc-messages-dir = /usr/share/mysql
  65. skip-external-locking
  66.  
  67. binlog-format = MIXED
  68.  
  69. interactive_timeout=180
  70. wait_timeout=180
  71.  
  72. key_buffer = 16M
  73. max_allowed_packet = 16M
  74. thread_stack = 192K
  75. thread_cache_size = 8
  76. myisam-recover = BACKUP
  77. max_connections = 100
  78.  
  79. query_cache_limit = 1M
  80. query_cache_size = 16M
  81.  
  82. general_log = 1
  83. log_error = /var/log/mysql/error.log
  84. server-id = 2
  85.  
  86. log_bin = /var/log/mysql/mysql-bin.log
  87. log_bin_trust_function_creators = 1
  88. log-slave-updates = true
  89.  
  90. # enable GTID
  91. gtid-mode = on
  92. enforce-gtid-consistency = true
  93. sync-master-info=1
  94. binlog-checksum=CRC32
  95. master-verify-checksum=1
  96. slave-sql-verify-checksum=1
  97. binlog-rows-query-log_events=1
  98.  
  99. expire_logs_days = 10
  100. max_binlog_size = 100M
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement