Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- port = 3306
- sql-mode = NO_ENGINE_SUBSTITUTION
- innodb_flush_log_at_trx_commit = 1
- sync_binlog = 1
- innodb_file_per_table = 1
- innodb_log_buffer_size = 64M
- innodb_buffer_pool_size = 512M
- table_open_cache = 8192
- open_files_limit = 65500
- read_buffer_size = 1M
- wait_timeout = 300
- key_buffer_size = 128M
- max_connections = 3072
- max_user_connections = 3072
- thread_cache_size = 96
- tmp_table_size = 192M
- max_heap_table_size = 192M
- sort_buffer_size = 4M
- read_rnd_buffer_size = 2M
- read_buffer_size = 2M
- join_buffer_size = 32M
- innodb_buffer_pool_size = 32G
- innodb_flush_method = O_DIRECT
- net_buffer_length = 256K
- thread_stack = 256K
- delayed_insert_timeout = 8
- connect_timeout = 8
- open_files_limit = 20480
- innodb_thread_concurrency = 12
- wait_timeout = 720
- interactive_timeout = 720
- innodb_log_buffer_size = 128M
- innodb_log_file_size = 256M
- innodb_lock_wait_timeout = 120
- # General replication settings
- gtid_mode = ON
- enforce_gtid_consistency = ON
- master_info_repository = TABLE
- relay_log_info_repository = TABLE
- binlog_checksum = NONE
- log_slave_updates = ON
- log_bin = binlog
- binlog_format = ROW
- binlog_expire_logs_seconds=604800
- transaction_write_set_extraction = XXHASH64
- group_replication_bootstrap_group = OFF
- group_replication_ssl_mode = REQUIRED
- group_replication_recovery_use_ssl = 1
- relay-log=vm7990-relay-bin
- transaction-isolation = "READ-COMMITTED"
- plugin_load_add ="group_replication.so"
- #plugin-load-add ="mysql_clone.so"
- group_replication_start_on_boot = ON
- # Shared replication group configuration
- group_replication_group_name = "c7bdb6a5-746f-4eab-a21d-9d9c08578322"
- group_replication_ip_whitelist = "vm1,vm2,vm3"
- group_replication_group_seeds = "vm1:33061,vm2:33061,vm3:33061"
- group_replication_single_primary_mode = OFF
- group_replication_enforce_update_everywhere_checks = ON
- # Host specific replication configuration
- server_id = 1
- bind-address = "vm1"
- report_host = "vm1"
- group_replication_local_address = "vm1:33061"
- # Default collation UTF8
- #collation-server = utf8_unicode_ci
- #init-connect='SET NAMES utf8'
- #character-set-server = utf8
- character-set-server = latin1
- collation-server = latin1_swedish_ci
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement