SHARE
TWEET

InnoDB cluster config file my.cnf

a guest May 22nd, 2018 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #
  2. # The MySQL database server configuration file.
  3. #
  4. # You can copy this to one of:
  5. # - "/etc/mysql/my.cnf" to set global options,
  6. # - "~/.my.cnf" to set user-specific options.
  7. #
  8. # One can use all long options that the program supports.
  9. # Run program with --help to get a list of available options and with
  10. # --print-defaults to see which it would actually understand and use.
  11. #
  12. # For explanations see
  13. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  14.  
  15. #
  16. # * IMPORTANT: Additional settings that can override those from this file!
  17. #   The files must end with '.cnf', otherwise they'll be ignored.
  18. #
  19.  
  20. !includedir /etc/mysql/conf.d/
  21. !includedir /etc/mysql/mysql.conf.d/
  22.  
  23. # my.cnf from DigitalOcean help PDF.
  24. ## going for: multi-primary replication group
  25. ## sudo vi /etc/mysql/my.cnf
  26. ## By default, this file is only used to source additional files from subdirectories. We will have to add
  27. ## our own configuration beneath the !includedir lines. This allows us to easily override any
  28. ## settings from the included files.
  29. ## settings here overide the include files
  30.  
  31. ## The loose- prefix allows MySQL to gracefully handle options it does not recognize gracefully without failure.
  32.  
  33. [mysqld]
  34. # General replication settings
  35. gtid_mode = ON
  36. enforce_gtid_consistency = ON
  37. master_info_repository = TABLE
  38. relay_log_info_repository = TABLE
  39. binlog_checksum = NONE
  40. log_slave_updates = ON
  41. log_bin = binlog
  42. binlog_format = ROW
  43. transaction_write_set_extraction = XXHASH64
  44. loose-group_replication_bootstrap_group = OFF
  45. loose-group_replication_start_on_boot = OFF
  46. loose-group_replication_ssl_mode = REQUIRED
  47. loose-group_replication_recovery_use_ssl = 1
  48.  
  49. # Shared replication group configuration
  50. ## This section should be the same on each of your MySQL servers...
  51. ## uuidgen
  52. loose-group_replication_group_name = "de991111-f29d-46fa-8054-7529a19eada6"
  53. loose-group_replication_ip_whitelist = "192.168.2.0/24, 10.10.10.0/24"
  54. loose-group_replication_group_seeds = "192.168.2.220:33061, 192.168.2.221:33061, 192.168.2.222:33061, 192.168.2.223:33061, 192.168.2.10:33061, 192.168.2.11:33061"
  55.  
  56. # Single or Multi-primary mode? Uncomment these two lines
  57. # for multi-primary mode, where any host can accept writes
  58. # comment out for single primary mode
  59. ## These settings must be the same on each of your MySQL servers ...
  60. ## A multi-primary group allows writes to any of the group members.
  61. loose-group_replication_single_primary_mode = OFF
  62. loose-group_replication_enforce_update_everywhere_checks = ON
  63.  
  64. # Host specific replication configuration
  65. ## settings that will be different on each of the servers...
  66. ### sql[0-9] -- 22[0-9]
  67. ### rep[0-20 -- 2[10-29]
  68.  
  69. ### SQL0 ###
  70. server_id = 220
  71. bind-address = "192.168.2.220"
  72. report_host = "192.168.2.220"
  73. loose-group_replication_local_address = "192.168.2.220:33061"
  74.  
  75. ## fix warnings
  76. relay-log=sql0-relay-bin
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top