点击参与 GreatSQL 8.0.32-26 文档捉虫~~~

GreatSQL社区

搜索

[待回复] 8.4.4-4 手工部署mgr集群时无法绑定vip

21 1 昨天 16:21
8.4.4-4 手工部署mgr集群时无法绑定vip


环境介绍

  1. [root@db81 ~]# cat /etc/redhat-release
  2. CentOS Linux release 8.5.2111
  3. [root@db81 ~]# free -h
  4.               total        used        free      shared  buff/cache   available
  5. Mem:          4.8Gi       1.9Gi       199Mi       8.0Mi       2.7Gi       2.7Gi
  6. Swap:          15Gi          0B        15Gi
  7. [root@db81 ~]# cat /etc/hosts
  8. 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
  9. ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
  10. 192.168.43.81  db81
  11. 192.168.43.82  db82
  12. 192.168.43.83  db83
  13. [root@db81 ~]#
复制代码
my.cnf配置-db81

  1. [root@db81 ~]# cat /etc/my.cnf
  2. # my.cnf example for GreatSQL 8.4.4-4
  3. # 下面参数选项设置仅作为参考，假定服务器配置为128C256G
  4. [client]
  5. socket    = /tmp/mysql.sock

  7. [mysql]
  8. loose-skip-binary-as-hex
  9. #prompt = "(\\D)[\\u@GreatSQL][\\d]>"
  10. no-auto-rehash

  12. [mysqld]
  13. # MySQL 8.4.x需用该参数启用插件
  14. mysql-native-password=ON
  15. # 指定默认认证插件为mysql_native_password
  16. #default_authentication_plugin=mysql_native_password
  17. lower_case_table_names=1
  18. user    = mysql
  19. port    = 3306
  20. server_id = 81
  21. basedir = /usr/local/mysql
  22. datadir    = /data/Greate/data/data
  23. socket    = /tmp/mysql.sock
  24. pid-file = mysql.pid
  25. character-set-server = UTF8MB4
  26. skip_name_resolve = ON
  27. default_time_zone = "+8:00"
  28. bind_address = "0.0.0.0"
  29. secure_file_priv = /data/Greate/data

  31. # Performance
  32. lock_wait_timeout = 3600
  33. open_files_limit    = 65535
  34. back_log = 1024
  35. max_connections = 2048
  36. max_connect_errors = 1000000
  37. table_open_cache = 2048
  38. table_definition_cache = 2048
  39. sort_buffer_size = 4M
  40. join_buffer_size = 4M
  41. read_buffer_size = 8M
  42. read_rnd_buffer_size = 4M
  43. bulk_insert_buffer_size = 64M
  44. thread_cache_size = 768
  45. interactive_timeout = 600
  46. wait_timeout = 600
  47. tmp_table_size = 96M
  48. max_heap_table_size = 128M
  49. max_allowed_packet = 256M
  50. net_buffer_shrink_interval = 180
  51. sql_generate_invisible_primary_key = ON
  52. loose-lock_ddl_polling_mode = ON
  53. loose-lock_ddl_polling_runtime = 200

  55. # Logs
  56. log_timestamps = SYSTEM
  57. log_error = /data/Greate/log/error.log
  58. log_error_verbosity = 3
  59. slow_query_log = ON
  60. log_slow_extra = ON
  61. slow_query_log_file = /data/Greate/log/slow.log
  62. long_query_time = 0.01
  63. log_queries_not_using_indexes = ON
  64. log_throttle_queries_not_using_indexes = 60
  65. min_examined_row_limit = 100
  66. log_slow_admin_statements = ON
  67. log_slow_replica_statements = ON
  68. log_slow_verbosity = FULL
  69. log_bin = /data/Greate/log/mysql-bin
  70. log-bin-index = /data/Greate/log/mysql-bin.index
  71. binlog_format = ROW
  72. sync_binlog = 1
  73. binlog_cache_size = 4M
  74. max_binlog_cache_size = 6G
  75. max_binlog_size = 1G
  76. binlog_space_limit = 500G
  77. binlog_rows_query_log_events = ON
  78. binlog_expire_logs_seconds = 604800
  79. binlog_checksum = CRC32
  80. binlog_order_commits = OFF
  81. gtid_mode = ON
  82. enforce_gtid_consistency = ON

  84. # Replication
  85. relay_log = /data/Greate/log/relay-bin
  86. relay_log_index = /data/Greate/log/relay-bin.index
  87. relay_log_recovery = ON
  88. #replica_parallel_type = LOGICAL_CLOCK
  89. replica_parallel_workers = 16
  90. #binlog_transaction_dependency_tracking = WRITESET
  91. replica_preserve_commit_order = ON
  92. replica_checkpoint_period = 2
  93. loose-rpl_read_binlog_speed_limit = 100

  95. # Disalbe InnoDB PQ
  96. loose-force_parallel_execute = OFF

  98. # Parallel LOAD DATA
  99. loose-gdb_parallel_load = ON
  100. loose-innodb_optimize_no_pk_parallel_load = ON

  102. # Rapid
  103. #loose-plugin_load_add = 'ha_rapid.so'
  104. #loose-rapid_memory_limit = 64G
  105. #loose-rapid_worker_threads = 32
  106. #loose-secondary_engine_parallel_load_workers = 16

  108. # Turbo
  109. #loose-plugin_load_add = 'turbo.so'
  110. loose-turbo_memory_limit= 64G
  111. loose-turbo_worker_threads = 32

  113. # Clone
  114. loose-plugin_load_add = 'mysql_clone.so'

  116. # MGR
  117. loose-plugin_load_add = 'group_replication.so'
  118. loose-group_replication_group_name = "f97cd7db-2b26-4011-b3fa-78118462cf02"
  119. #loose-group_replication_view_change_uuid = "5b20893d-9a54-48d5-90c7-21a248956118"
  120. loose-group_replication_local_address = "192.168.43.81:33061"
  121. loose-group_replication_group_seeds = '192.168.43.81:33061,192.168.43.82:33061,192.168.43.83:33061'
  122. loose-group_replication_ip_allowlist = '172.160.16.0/8,192.168.43.0/24,::1/128'
  123. loose-group_replication_communication_stack = "XCOM"
  124. loose-group_replication_recovery_use_ssl = OFF
  125. loose-group_replication_ssl_mode = DISABLED
  126. loose-group_replication_start_on_boot = OFF
  127. loose-group_replication_bootstrap_group = OFF
  128. loose-group_replication_exit_state_action = READ_ONLY
  129. loose-group_replication_flow_control_mode = "DISABLED"
  130. loose-group_replication_single_primary_mode = ON
  131. loose-group_replication_enforce_update_everywhere_checks = OFF
  132. loose-group_replication_majority_after_mode = ON
  133. loose-group_replication_communication_max_message_size = 10M
  134. loose-group_replication_arbitrator = OFF
  135. loose-group_replication_single_primary_fast_mode = 1
  136. loose-group_replication_request_time_threshold = 100
  137. loose-group_replication_primary_election_mode = GTID_FIRST
  138. loose-group_replication_unreachable_majority_timeout = 0
  139. loose-group_replication_member_expel_timeout = 5
  140. loose-group_replication_autorejoin_tries = 288
  141. loose-group_replication_recovery_get_public_key = ON
  142. loose-group_replication_donor_threshold = 100

  144. # greatdb_ha
  145. loose-plugin_load_add = 'greatdb_ha.so'
  146. loose-greatdb_ha_enable_mgr_vip = ON
  147. loose-greatdb_ha_mgr_vip_nic = 'ens160'
  148. loose-greatdb_ha_mgr_vip_ip = '192.168.43.80'
  149. loose-greatdb_ha_mgr_vip_mask = '255.255.255.0'
  150. loose-greatdb_ha_port = 33062
  151. loose-greatdb_ha_mgr_read_vip_ips = "192.168.43.78,192.168.43.79"
  152. loose-greatdb_ha_mgr_read_vip_floating_type = "TO_ANOTHER_SECONDARY"
  153. loose-greatdb_ha_send_arp_packge_times = 5
  154. loose-greatdb_ha_mgr_exit_primary_kill_connection_mode = OFF
  155. report_host = 192.168.43.81
  156. report_port = 3306

  158. # InnoDB
  159. innodb_buffer_pool_size = 2G
  160. innodb_buffer_pool_instances = 2
  161. innodb_data_file_path = ibdata1:12M:autoextend
  162. innodb_flush_log_at_trx_commit = 1
  163. innodb_log_buffer_size = 32M
  164. innodb_redo_log_capacity = 4G
  165. innodb_doublewrite_files = 2
  166. innodb_max_undo_log_size = 4G
  167. innodb_io_capacity = 4000
  168. innodb_io_capacity_max = 8000
  169. innodb_open_files = 65534
  170. innodb_flush_method = O_DIRECT
  171. innodb_lru_scan_depth = 4000
  172. innodb_lock_wait_timeout = 10
  173. innodb_rollback_on_timeout = ON
  174. innodb_print_all_deadlocks = ON
  175. innodb_online_alter_log_max_size = 4G
  176. innodb_print_ddl_logs = ON
  177. innodb_status_file = ON
  178. innodb_status_output = OFF
  179. innodb_status_output_locks = ON
  180. innodb_sort_buffer_size = 64M
  181. innodb_adaptive_hash_index = OFF
  182. innodb_numa_interleave = OFF
  183. innodb_spin_wait_delay = 20
  184. innodb_print_lock_wait_timeout_info = ON
  185. innodb_change_buffering = none
  186. kill_idle_transaction = 300
  187. innodb_data_file_async_purge = ON

  189. [mysqldump]
  190. quick
  191. max_allowed_packet=256M
  192. [root@db81 ~]#
复制代码
my.cnf配置-db82

  1. [root@db82 ~]# cat /etc/my.cnf
  2. # my.cnf example for GreatSQL 8.4.4-4
  3. # 下面参数选项设置仅作为参考，假定服务器配置为128C256G
  4. [client]
  5. socket    = /tmp/mysql.sock

  7. [mysql]
  8. loose-skip-binary-as-hex
  9. #prompt = "(\\D)[\\u@GreatSQL][\\d]>"
  10. no-auto-rehash

  12. [mysqld]
  13. # MySQL 8.4.x需用该参数启用插件
  14. mysql-native-password=ON
  15. # 指定默认认证插件为mysql_native_password
  16. #default_authentication_plugin=mysql_native_password
  17. lower_case_table_names=1
  18. user    = mysql
  19. port    = 3306
  20. server_id = 82
  21. basedir = /usr/local/mysql
  22. datadir    = /data/Greate/data/data
  23. socket    = /tmp/mysql.sock
  24. pid-file = mysql.pid
  25. character-set-server = UTF8MB4
  26. skip_name_resolve = ON
  27. default_time_zone = "+8:00"
  28. bind_address = "0.0.0.0"
  29. secure_file_priv = /data/Greate/data

  31. # Performance
  32. lock_wait_timeout = 3600
  33. open_files_limit    = 65535
  34. back_log = 1024
  35. max_connections = 2048
  36. max_connect_errors = 1000000
  37. table_open_cache = 2048
  38. table_definition_cache = 2048
  39. sort_buffer_size = 4M
  40. join_buffer_size = 4M
  41. read_buffer_size = 8M
  42. read_rnd_buffer_size = 4M
  43. bulk_insert_buffer_size = 64M
  44. thread_cache_size = 768
  45. interactive_timeout = 600
  46. wait_timeout = 600
  47. tmp_table_size = 96M
  48. max_heap_table_size = 128M
  49. max_allowed_packet = 256M
  50. net_buffer_shrink_interval = 180
  51. sql_generate_invisible_primary_key = ON
  52. loose-lock_ddl_polling_mode = ON
  53. loose-lock_ddl_polling_runtime = 200

  55. # Logs
  56. log_timestamps = SYSTEM
  57. log_error = /data/Greate/log/error.log
  58. log_error_verbosity = 3
  59. slow_query_log = ON
  60. log_slow_extra = ON
  61. slow_query_log_file = /data/Greate/log/slow.log
  62. long_query_time = 0.01
  63. log_queries_not_using_indexes = ON
  64. log_throttle_queries_not_using_indexes = 60
  65. min_examined_row_limit = 100
  66. log_slow_admin_statements = ON
  67. log_slow_replica_statements = ON
  68. log_slow_verbosity = FULL
  69. log_bin = /data/Greate/log/mysql-bin
  70. log-bin-index = /data/Greate/log/mysql-bin.index
  71. binlog_format = ROW
  72. sync_binlog = 1
  73. binlog_cache_size = 4M
  74. max_binlog_cache_size = 6G
  75. max_binlog_size = 1G
  76. binlog_space_limit = 500G
  77. binlog_rows_query_log_events = ON
  78. binlog_expire_logs_seconds = 604800
  79. binlog_checksum = CRC32
  80. binlog_order_commits = OFF
  81. gtid_mode = ON
  82. enforce_gtid_consistency = ON

  84. # Replication
  85. relay_log = /data/Greate/log/relay-bin
  86. relay_log_index = /data/Greate/log/relay-bin.index
  87. relay_log_recovery = ON
  88. #replica_parallel_type = LOGICAL_CLOCK
  89. replica_parallel_workers = 16
  90. #binlog_transaction_dependency_tracking = WRITESET
  91. replica_preserve_commit_order = ON
  92. replica_checkpoint_period = 2
  93. loose-rpl_read_binlog_speed_limit = 100

  95. # Disalbe InnoDB PQ
  96. loose-force_parallel_execute = OFF

  98. # Parallel LOAD DATA
  99. loose-gdb_parallel_load = ON
  100. loose-innodb_optimize_no_pk_parallel_load = ON

  102. # Rapid
  103. #loose-plugin_load_add = 'ha_rapid.so'
  104. #loose-rapid_memory_limit = 64G
  105. #loose-rapid_worker_threads = 32
  106. #loose-secondary_engine_parallel_load_workers = 16

  108. # Turbo
  109. #loose-plugin_load_add = 'turbo.so'
  110. loose-turbo_memory_limit= 64G
  111. loose-turbo_worker_threads = 32

  113. # Clone
  114. loose-plugin_load_add = 'mysql_clone.so'

  116. # MGR
  117. loose-plugin_load_add = 'group_replication.so'
  118. loose-group_replication_group_name = "f97cd7db-2b26-4011-b3fa-78118462cf02"
  119. #loose-group_replication_view_change_uuid = "5b20893d-9a54-48d5-90c7-21a248956118"
  120. loose-group_replication_local_address = "192.168.43.82:33061"
  121. loose-group_replication_group_seeds = '192.168.43.81:33061,192.168.43.82:33061,192.168.43.83:33061'
  122. loose-group_replication_ip_allowlist = '172.160.16.0/8,192.168.43.0/24,::1/128'
  123. loose-group_replication_communication_stack = "XCOM"
  124. loose-group_replication_recovery_use_ssl = OFF
  125. loose-group_replication_ssl_mode = DISABLED
  126. loose-group_replication_start_on_boot = OFF
  127. loose-group_replication_bootstrap_group = OFF
  128. loose-group_replication_exit_state_action = READ_ONLY
  129. loose-group_replication_flow_control_mode = "DISABLED"
  130. loose-group_replication_single_primary_mode = ON
  131. loose-group_replication_enforce_update_everywhere_checks = OFF
  132. loose-group_replication_majority_after_mode = ON
  133. loose-group_replication_communication_max_message_size = 10M
  134. loose-group_replication_arbitrator = OFF
  135. loose-group_replication_single_primary_fast_mode = 1
  136. loose-group_replication_request_time_threshold = 100
  137. loose-group_replication_primary_election_mode = GTID_FIRST
  138. loose-group_replication_unreachable_majority_timeout = 0
  139. loose-group_replication_member_expel_timeout = 5
  140. loose-group_replication_autorejoin_tries = 288
  141. loose-group_replication_recovery_get_public_key = ON
  142. loose-group_replication_donor_threshold = 100

  144. # greatdb_ha
  145. loose-plugin_load_add = 'greatdb_ha.so'
  146. loose-greatdb_ha_enable_mgr_vip = ON
  147. loose-greatdb_ha_mgr_vip_nic = 'ens160'
  148. loose-greatdb_ha_mgr_vip_ip = '192.168.43.80'
  149. loose-greatdb_ha_mgr_vip_mask = '255.255.255.0'
  150. loose-greatdb_ha_port = 33062
  151. loose-greatdb_ha_mgr_read_vip_ips = "192.168.43.78,192.168.43.79"
  152. loose-greatdb_ha_mgr_read_vip_floating_type = "TO_ANOTHER_SECONDARY"
  153. loose-greatdb_ha_send_arp_packge_times = 5
  154. loose-greatdb_ha_mgr_exit_primary_kill_connection_mode = OFF
  155. report_host = 192.168.43.82
  156. report_port = 3306

  158. # InnoDB
  159. innodb_buffer_pool_size = 2G
  160. innodb_buffer_pool_instances = 2
  161. innodb_data_file_path = ibdata1:12M:autoextend
  162. innodb_flush_log_at_trx_commit = 1
  163. innodb_log_buffer_size = 32M
  164. innodb_redo_log_capacity = 4G
  165. innodb_doublewrite_files = 2
  166. innodb_max_undo_log_size = 4G
  167. innodb_io_capacity = 4000
  168. innodb_io_capacity_max = 8000
  169. innodb_open_files = 65534
  170. innodb_flush_method = O_DIRECT
  171. innodb_lru_scan_depth = 4000
  172. innodb_lock_wait_timeout = 10
  173. innodb_rollback_on_timeout = ON
  174. innodb_print_all_deadlocks = ON
  175. innodb_online_alter_log_max_size = 4G
  176. innodb_print_ddl_logs = ON
  177. innodb_status_file = ON
  178. innodb_status_output = OFF
  179. innodb_status_output_locks = ON
  180. innodb_sort_buffer_size = 64M
  181. innodb_adaptive_hash_index = OFF
  182. innodb_numa_interleave = OFF
  183. innodb_spin_wait_delay = 20
  184. innodb_print_lock_wait_timeout_info = ON
  185. innodb_change_buffering = none
  186. kill_idle_transaction = 300
  187. innodb_data_file_async_purge = ON

  189. [mysqldump]
  190. quick
  191. max_allowed_packet=256M
  192. [root@db82 ~]#
复制代码




my.cnf配置-db83

  1. [root@db83 ~]# cat /etc/my.cnf
  2. # my.cnf example for GreatSQL 8.4.4-4
  3. # 下面参数选项设置仅作为参考，假定服务器配置为128C256G
  4. [client]
  5. socket    = /tmp/mysql.sock

  7. [mysql]
  8. loose-skip-binary-as-hex
  9. #prompt = "(\\D)[\\u@GreatSQL][\\d]>"
  10. no-auto-rehash

  12. [mysqld]
  13. # MySQL 8.4.x需用该参数启用插件
  14. mysql-native-password=ON
  15. # 指定默认认证插件为mysql_native_password
  16. #default_authentication_plugin=mysql_native_password
  17. lower_case_table_names=1
  18. user    = mysql
  19. port    = 3306
  20. server_id = 83
  21. basedir = /usr/local/mysql
  22. datadir    = /data/Greate/data/data
  23. socket    = /tmp/mysql.sock
  24. pid-file = mysql.pid
  25. character-set-server = UTF8MB4
  26. skip_name_resolve = ON
  27. default_time_zone = "+8:00"
  28. bind_address = "0.0.0.0"
  29. secure_file_priv = /data/Greate/data

  31. # Performance
  32. lock_wait_timeout = 3600
  33. open_files_limit    = 65535
  34. back_log = 1024
  35. max_connections = 2048
  36. max_connect_errors = 1000000
  37. table_open_cache = 2048
  38. table_definition_cache = 2048
  39. sort_buffer_size = 4M
  40. join_buffer_size = 4M
  41. read_buffer_size = 8M
  42. read_rnd_buffer_size = 4M
  43. bulk_insert_buffer_size = 64M
  44. thread_cache_size = 768
  45. interactive_timeout = 600
  46. wait_timeout = 600
  47. tmp_table_size = 96M
  48. max_heap_table_size = 128M
  49. max_allowed_packet = 256M
  50. net_buffer_shrink_interval = 180
  51. sql_generate_invisible_primary_key = ON
  52. loose-lock_ddl_polling_mode = ON
  53. loose-lock_ddl_polling_runtime = 200

  55. # Logs
  56. log_timestamps = SYSTEM
  57. log_error = /data/Greate/log/error.log
  58. log_error_verbosity = 3
  59. slow_query_log = ON
  60. log_slow_extra = ON
  61. slow_query_log_file = /data/Greate/log/slow.log
  62. long_query_time = 0.01
  63. log_queries_not_using_indexes = ON
  64. log_throttle_queries_not_using_indexes = 60
  65. min_examined_row_limit = 100
  66. log_slow_admin_statements = ON
  67. log_slow_replica_statements = ON
  68. log_slow_verbosity = FULL
  69. log_bin = /data/Greate/log/mysql-bin
  70. log-bin-index = /data/Greate/log/mysql-bin.index
  71. binlog_format = ROW
  72. sync_binlog = 1
  73. binlog_cache_size = 4M
  74. max_binlog_cache_size = 6G
  75. max_binlog_size = 1G
  76. binlog_space_limit = 500G
  77. binlog_rows_query_log_events = ON
  78. binlog_expire_logs_seconds = 604800
  79. binlog_checksum = CRC32
  80. binlog_order_commits = OFF
  81. gtid_mode = ON
  82. enforce_gtid_consistency = ON

  84. # Replication
  85. relay_log = /data/Greate/log/relay-bin
  86. relay_log_index = /data/Greate/log/relay-bin.index
  87. relay_log_recovery = ON
  88. #replica_parallel_type = LOGICAL_CLOCK
  89. replica_parallel_workers = 16
  90. #binlog_transaction_dependency_tracking = WRITESET
  91. replica_preserve_commit_order = ON
  92. replica_checkpoint_period = 2
  93. loose-rpl_read_binlog_speed_limit = 100

  95. # Disalbe InnoDB PQ
  96. loose-force_parallel_execute = OFF

  98. # Parallel LOAD DATA
  99. loose-gdb_parallel_load = ON
  100. loose-innodb_optimize_no_pk_parallel_load = ON

  102. # Rapid
  103. #loose-plugin_load_add = 'ha_rapid.so'
  104. #loose-rapid_memory_limit = 64G
  105. #loose-rapid_worker_threads = 32
  106. #loose-secondary_engine_parallel_load_workers = 16

  108. # Turbo
  109. #loose-plugin_load_add = 'turbo.so'
  110. loose-turbo_memory_limit= 64G
  111. loose-turbo_worker_threads = 32

  113. # Clone
  114. loose-plugin_load_add = 'mysql_clone.so'

  116. # MGR
  117. loose-plugin_load_add = 'group_replication.so'
  118. loose-group_replication_group_name = "f97cd7db-2b26-4011-b3fa-78118462cf02"
  119. #loose-group_replication_view_change_uuid = "5b20893d-9a54-48d5-90c7-21a248956118"
  120. loose-group_replication_local_address = "192.168.43.83:33061"
  121. loose-group_replication_group_seeds = '192.168.43.81:33061,192.168.43.82:33061,192.168.43.83:33061'
  122. loose-group_replication_ip_allowlist = '172.160.16.0/8,192.168.43.0/24,::1/128'
  123. loose-group_replication_communication_stack = "XCOM"
  124. loose-group_replication_recovery_use_ssl = OFF
  125. loose-group_replication_ssl_mode = DISABLED
  126. loose-group_replication_start_on_boot = OFF
  127. loose-group_replication_bootstrap_group = OFF
  128. loose-group_replication_exit_state_action = READ_ONLY
  129. loose-group_replication_flow_control_mode = "DISABLED"
  130. loose-group_replication_single_primary_mode = ON
  131. loose-group_replication_enforce_update_everywhere_checks = OFF
  132. loose-group_replication_majority_after_mode = ON
  133. loose-group_replication_communication_max_message_size = 10M
  134. loose-group_replication_arbitrator = OFF
  135. loose-group_replication_single_primary_fast_mode = 1
  136. loose-group_replication_request_time_threshold = 100
  137. loose-group_replication_primary_election_mode = GTID_FIRST
  138. loose-group_replication_unreachable_majority_timeout = 0
  139. loose-group_replication_member_expel_timeout = 5
  140. loose-group_replication_autorejoin_tries = 288
  141. loose-group_replication_recovery_get_public_key = ON
  142. loose-group_replication_donor_threshold = 100

  144. # greatdb_ha
  145. loose-plugin_load_add = 'greatdb_ha.so'
  146. loose-greatdb_ha_enable_mgr_vip = ON
  147. loose-greatdb_ha_mgr_vip_nic = 'ens160'
  148. loose-greatdb_ha_mgr_vip_ip = '192.168.43.80'
  149. loose-greatdb_ha_mgr_vip_mask = '255.255.255.0'
  150. loose-greatdb_ha_port = 33062
  151. loose-greatdb_ha_mgr_read_vip_ips = "192.168.43.78,192.168.43.79"
  152. loose-greatdb_ha_mgr_read_vip_floating_type = "TO_ANOTHER_SECONDARY"
  153. loose-greatdb_ha_send_arp_packge_times = 5
  154. loose-greatdb_ha_mgr_exit_primary_kill_connection_mode = OFF
  155. report_host = 192.168.43.83
  156. report_port = 3306

  158. # InnoDB
  159. innodb_buffer_pool_size = 2G
  160. innodb_buffer_pool_instances = 2
  161. innodb_data_file_path = ibdata1:12M:autoextend
  162. innodb_flush_log_at_trx_commit = 1
  163. innodb_log_buffer_size = 32M
  164. innodb_redo_log_capacity = 4G
  165. innodb_doublewrite_files = 2
  166. innodb_max_undo_log_size = 4G
  167. innodb_io_capacity = 4000
  168. innodb_io_capacity_max = 8000
  169. innodb_open_files = 65534
  170. innodb_flush_method = O_DIRECT
  171. innodb_lru_scan_depth = 4000
  172. innodb_lock_wait_timeout = 10
  173. innodb_rollback_on_timeout = ON
  174. innodb_print_all_deadlocks = ON
  175. innodb_online_alter_log_max_size = 4G
  176. innodb_print_ddl_logs = ON
  177. innodb_status_file = ON
  178. innodb_status_output = OFF
  179. innodb_status_output_locks = ON
  180. innodb_sort_buffer_size = 64M
  181. innodb_adaptive_hash_index = OFF
  182. innodb_numa_interleave = OFF
  183. innodb_spin_wait_delay = 20
  184. innodb_print_lock_wait_timeout_info = ON
  185. innodb_change_buffering = none
  186. kill_idle_transaction = 300
  187. innodb_data_file_async_purge = ON

  189. [mysqldump]
  190. quick
  191. max_allowed_packet=256M
  192. [root@db83 ~]#
复制代码
启动脚本文件内容

  1. [root@db82 ~]# cat /usr/lib/systemd/system/mysqld.service
  2. [Unit]
  3. Description=MySQL Server
  4. Documentation=https://dev.mysql.com/doc/
  5. After=network.target
  6. After=syslog.target

  8. [Install]
  9. WantedBy=multi-user.target

  11. [Service]
  12. # some limits
  13. # file size
  14. LimitFSIZE=infinity
  15. # cpu time
  16. LimitCPU=infinity
  17. # virtual memory size
  18. LimitAS=infinity
  19. # open files
  20. LimitNOFILE=65535
  21. # processes/threads
  22. LimitNPROC=65535
  23. # locked memory
  24. LimitMEMLOCK=infinity
  25. # total threads (user+kernel)
  26. TasksMax=infinity
  27. TasksAccounting=false

  29. User=mysql
  30. Group=mysql
  31. # 如果是 MySQL 5.7 版本，此处可以使用 simple 模式
  32. # 如果是 MySQL 8.0 版本，可以使用 notify 模式
  33. Type=notify
  34. TimeoutSec=10
  35. PermissionsStartOnly=true
  36. ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf $MYSQLD_OPTS
  37. EnvironmentFile=-/etc/sysconfig/mysql
  38. LimitNOFILE = 65536
  39. Restart=on-failure
  40. RestartPreventExitStatus=1
  41. Environment=MYSQLD_PARENT_PID=1
  42. PrivateTmp=false
  43. [root@db82 ~]#
复制代码
当前MGR状态-手工部署

  1. mysql> SELECT * FROM performance_schema.replication_group_members;
  2. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  3. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  4. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  5. | group_replication_applier | 0de00816-ba0e-11f0-aab7-000c290e14b3 | 192.168.43.82 |        3306 | ONLINE       | SECONDARY   | 8.4.4          | XCom                       |
  6. | group_replication_applier | 0f9a0445-ba0e-11f0-abf7-000c29fb24ce | 192.168.43.83 |        3306 | ONLINE       | SECONDARY   | 8.4.4          | XCom                       |
  7. | group_replication_applier | f058754b-ba0d-11f0-b2cc-000c2941d820 | 192.168.43.81 |        3306 | ONLINE       | PRIMARY     | 8.4.4          | XCom                       |
  8. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  9. 3 rows in set (0.00 sec)

  11. mysql>
复制代码
报错日志部分内容

  1. 2025-11-05T16:16:13.231812+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  2. 2025-11-05T16:16:13.231897+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  3. 2025-11-05T16:16:33.238400+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  4. 2025-11-05T16:16:33.238450+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  5. 2025-11-05T16:16:53.245691+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  6. 2025-11-05T16:16:53.245754+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  7. 2025-11-05T16:17:13.249749+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  8. 2025-11-05T16:17:13.249801+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  9. 2025-11-05T16:17:33.256485+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  10. 2025-11-05T16:17:33.256538+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  11. 2025-11-05T16:17:53.264334+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  12. 2025-11-05T16:17:53.264386+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  13. 2025-11-05T16:18:13.271149+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  14. 2025-11-05T16:18:13.271212+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  15. 2025-11-05T16:18:33.277527+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  16. 2025-11-05T16:18:33.277591+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  17. 2025-11-05T16:18:53.281874+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  18. 2025-11-05T16:18:53.281935+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  19. 2025-11-05T16:19:13.290201+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  20. 2025-11-05T16:19:13.290255+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  21. 2025-11-05T16:19:33.294307+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  22. 2025-11-05T16:19:33.294364+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.80 failed on nic: '
  23. [root@db81 ~]#

  25. 2025-11-05T16:16:31.028688+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  26. 2025-11-05T16:16:51.033360+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  27. 2025-11-05T16:16:51.033469+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  28. 2025-11-05T16:17:11.037260+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  29. 2025-11-05T16:17:11.037482+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  30. 2025-11-05T16:17:31.044125+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  31. 2025-11-05T16:17:31.044241+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  32. 2025-11-05T16:17:51.052419+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  33. 2025-11-05T16:17:51.052524+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  34. 2025-11-05T16:18:11.059460+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  35. 2025-11-05T16:18:11.059656+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  36. 2025-11-05T16:18:31.065266+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  37. 2025-11-05T16:18:31.065414+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '
  38. 2025-11-05T16:18:51.069674+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  39. 2025-11-05T16:18:51.069806+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.78 failed on nic: '

  41. [root@db83 ~]# tail /data/Greate/log/error.log
  42. 2025-11-05T16:19:13.259831+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  43. 2025-11-05T16:19:13.259881+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.79 failed on nic: '
  44. 2025-11-05T16:19:33.263588+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  45. 2025-11-05T16:19:33.263638+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.79 failed on nic: '
  46. 2025-11-05T16:19:53.270807+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  47. 2025-11-05T16:19:53.270866+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.79 failed on nic: '
  48. 2025-11-05T16:20:13.275100+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  49. 2025-11-05T16:20:13.275155+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.79 failed on nic: '
  50. 2025-11-05T16:20:33.279774+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'bind AF_INET SIOCSIFADDR Operation not permitted'
  51. 2025-11-05T16:20:33.279840+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.43.79 failed on nic: '
  52. [root@db83 ~]#
复制代码





测试, MGR, 数据库, GreatSQL
全部回复(1)
只看楼主
yejr 昨天 17:27
请参考VIP功能文档说明：https://greatsql.cn/docs/8.4.4-4/5-enhance/5-2-ha-mgr-vip.html#启动说明

需要在用systemd启动时添加一行参数：

修改systemd服务文件，增加AmbientCapabilities参数，例如：
  1. #增加这行以保证MGR VIP功能可用
  2. AmbientCapabilities=CAP_NET_ADMIN CAP_NET_RAW
复制代码


这样应该就可以了
回复 采纳

举报

davie

4

主题

0

博客

14

贡献

新手上路

Rank: 1

积分
18
发消息
互动与交流
社区活动
论坛问答
加入社区
贡献者指南
学习与应用
文章博客
文档资料
视频资料
常见问题
发现社区
社区准则
建议反馈
社区之星

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

社区公众号
社区小助手
QQ群
友情链接
万里数据库开源中国墨天轮开放原子开源基金会OpenEuler
©2022 GreatSQL All Rights Reserved. ( 京ICP备06057874号 )
GMT+8, 2025-11-6 17:24 , Processed in 0.206295 second(s), 14 queries , Redis On.
快速回复 返回顶部 返回列表