Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
212
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. port = 3306
  3. sql-mode = NO_ENGINE_SUBSTITUTION
  4. innodb_flush_log_at_trx_commit = 1
  5. sync_binlog = 1
  6. innodb_file_per_table = 1
  7. innodb_log_buffer_size = 64M
  8. innodb_buffer_pool_size = 512M
  9. table_open_cache = 8192
  10. open_files_limit = 65500
  11. read_buffer_size = 1M
  12. wait_timeout = 300
  13. key_buffer_size = 128M
  14.  
  15. max_connections = 3072
  16. max_user_connections = 3072
  17. thread_cache_size = 96
  18. tmp_table_size = 192M
  19. max_heap_table_size = 192M
  20. sort_buffer_size = 4M
  21. read_rnd_buffer_size = 2M
  22. read_buffer_size = 2M
  23. join_buffer_size = 32M
  24. innodb_buffer_pool_size = 32G
  25. innodb_flush_method = O_DIRECT
  26. net_buffer_length = 256K
  27. thread_stack = 256K
  28. delayed_insert_timeout = 8
  29. connect_timeout = 8
  30. open_files_limit = 20480
  31. innodb_thread_concurrency = 12
  32.  
  33.  
  34. wait_timeout = 720
  35. interactive_timeout = 720
  36. innodb_log_buffer_size = 128M
  37. innodb_log_file_size = 256M
  38. innodb_lock_wait_timeout = 120
  39.  
  40.  
  41. # General replication settings
  42. gtid_mode = ON
  43. enforce_gtid_consistency = ON
  44. master_info_repository = TABLE
  45. relay_log_info_repository = TABLE
  46. binlog_checksum = NONE
  47. log_slave_updates = ON
  48. log_bin = binlog
  49. binlog_format = ROW
  50. binlog_expire_logs_seconds=604800
  51. transaction_write_set_extraction = XXHASH64
  52. group_replication_bootstrap_group = OFF
  53. group_replication_ssl_mode = REQUIRED
  54. group_replication_recovery_use_ssl = 1
  55. relay-log=vm7990-relay-bin
  56. transaction-isolation = "READ-COMMITTED"
  57.  
  58.  
  59. plugin_load_add ="group_replication.so"
  60. #plugin-load-add ="mysql_clone.so"
  61.  
  62. group_replication_start_on_boot = ON
  63.  
  64. # Shared replication group configuration
  65. group_replication_group_name = "c7bdb6a5-746f-4eab-a21d-9d9c08578322"
  66. group_replication_ip_whitelist = "vm1,vm2,vm3"
  67. group_replication_group_seeds = "vm1:33061,vm2:33061,vm3:33061"
  68. group_replication_single_primary_mode = OFF
  69. group_replication_enforce_update_everywhere_checks = ON
  70.  
  71. # Host specific replication configuration
  72. server_id = 1
  73. bind-address = "vm1"
  74. report_host = "vm1"
  75. group_replication_local_address = "vm1:33061"
  76.  
  77. # Default collation UTF8
  78. #collation-server = utf8_unicode_ci
  79. #init-connect='SET NAMES utf8'
  80. #character-set-server = utf8
  81. character-set-server = latin1
  82. collation-server = latin1_swedish_ci
Advertisement
RAW Paste Data Copied
Advertisement