单机多实例加入第二台时第一个直接蹦了( GreatSQL-8.0.32-24)
本帖最后由 周智林 于 2023-10-23 17:19 编辑先贴配置
第一个的my3306.cnf 配置
#mgr settings
loose-plugin_load_add = 'mysql_clone.so'
loose-plugin_load_add = 'group_replication.so'
loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"
#MGR本地节点IP:PORT，请自行替换
loose-group_replication_local_address = "192.168.188.60:33061"
#MGR集群所有节点IP:PORT，请自行替换
loose-group_replication_group_seeds = "192.168.188.60:33061,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091"
loose-group_replication_start_on_boot = OFF
loose-group_replication_bootstrap_group = OFF
loose-group_replication_exit_state_action = READ_ONLY
loose-group_replication_flow_control_mode = "DISABLED"
loose-group_replication_single_primary_mode = ON
loose-group_replication_majority_after_mode = ON
loose-group_replication_communication_max_message_size = 10M
loose-group_replication_arbitrator = 0
loose-group_replication_single_primary_fast_mode = 1
loose-group_replication_request_time_threshold = 100
loose-group_replication_primary_election_mode = GTID_FIRST
loose-group_replication_unreachable_majority_timeout = 30
loose-group_replication_member_expel_timeout = 5
loose-group_replication_autorejoin_tries = 288
#report_host = "192.168.188.60"
第二个3307.cnf的配置
#mgr settings
loose-plugin_load_add = 'mysql_clone.so'
loose-plugin_load_add = 'group_replication.so'
loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"
#MGR本地节点IP:PORT，请自行替换
loose-group_replication_local_address = "192.168.188.60:33071"
#MGR集群所有节点IP:PORT，请自行替换
loose-group_replication_group_seeds = "192.168.188.60:33061,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091"
loose-group_replication_start_on_boot = OFF
loose-group_replication_bootstrap_group = OFF
loose-group_replication_exit_state_action = READ_ONLY
loose-group_replication_flow_control_mode = "DISABLED"
loose-group_replication_single_primary_mode = ON
loose-group_replication_majority_after_mode = ON
loose-group_replication_communication_max_message_size = 10M
loose-group_replication_arbitrator = 0
loose-group_replication_single_primary_fast_mode = 1
loose-group_replication_request_time_threshold = 100
loose-group_replication_primary_election_mode = GTID_FIRST
loose-group_replication_unreachable_majority_timeout = 30
loose-group_replication_member_expel_timeout = 5
loose-group_replication_autorejoin_tries = 288
#report_host = "192.168.188.60"
3306的日志
# more error.log
2023-10-23T17:10:15.346694+08:00 0 Could not increase number of max_open_files to more than 10000 (request: 65535)
2023-10-23T17:10:15.544255+08:00 0 The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Plea
se use log_slow_replica_statements instead.
2023-10-23T17:10:15.544302+08:00 0 The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use
replica_parallel_type instead.
2023-10-23T17:10:15.544307+08:00 0 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2023-10-23T17:10:15.544315+08:00 0 The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please
use replica_parallel_workers instead.
2023-10-23T17:10:15.544325+08:00 0 The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Pl
ease use replica_preserve_commit_order instead.
2023-10-23T17:10:15.544335+08:00 0 The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please
use replica_checkpoint_period instead.
2023-10-23T17:10:15.544471+08:00 0 Insecure configuration for --secure-file-priv: Current value does not restrict location of generat
ed files. Consider setting it to a valid, non-empty path.
2023-10-23T17:10:15.544476+08:00 0 Insecure configuration for --secure-log-path: Current value does not restrict location of generate
d files. Consider setting it to a valid, non-empty path.
2023-10-23T17:10:15.544530+08:00 0 BuildID=5850d8e16b7845a955d11d6965d9d658fd24b257
2023-10-23T17:10:15.544535+08:00 0 Basedir set to /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/.
2023-10-23T17:10:15.544542+08:00 0 /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld (mysqld 8.0.32-24) starting as proc
ess 30223
2023-10-23T17:10:15.556405+08:00 0 innodb_open_files should not be greater than the open_files_limit.
2023-10-23T17:10:15.556445+08:00 0 Using Linux native AIO
2023-10-23T17:10:15.556469+08:00 0 Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity ins
tead.
2023-10-23T17:10:15.556480+08:00 0 Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacit
y instead.
2023-10-23T17:10:15.556793+08:00 0 Plugin 'FEDERATED' is disabled.
2023-10-23T17:10:15.556883+08:00 0 Plugin 'ndbcluster' is disabled.
2023-10-23T17:10:15.556905+08:00 0 Plugin 'ndbinfo' is disabled.
2023-10-23T17:10:15.556917+08:00 0 Plugin 'ndb_transid_mysql_connection_map' is disabled.
2023-10-23T17:10:15.561467+08:00 1 InnoDB initialization has started.
2023-10-23T17:10:15.561503+08:00 1 Atomic write enabled
2023-10-23T17:10:15.561533+08:00 1 PUNCH HOLE support available
2023-10-23T17:10:15.561548+08:00 1 Uses event mutexes
2023-10-23T17:10:15.561555+08:00 1 GCC builtin __atomic_thread_fence() is used for memory barrier
2023-10-23T17:10:15.561564+08:00 1 Compressed tables use zlib 1.2.13
2023-10-23T17:10:15.564106+08:00 1 Using hardware accelerated crc32 and polynomial multiplication.
2023-10-23T17:10:15.564505+08:00 1 Directories to scan './'
2023-10-23T17:10:15.564557+08:00 1 Scanning './'
2023-10-23T17:10:15.571617+08:00 1 Completed space ID check of 5 files.
2023-10-23T17:10:15.572741+08:00 1 Initializing buffer pool, total size = 2.000000G, instances = 8, chunk size =128.000000M
2023-10-23T17:10:15.572762+08:00 1 Setting NUMA memory policy to MPOL_INTERLEAVE
2023-10-23T17:10:20.767248+08:00 1 Setting NUMA memory policy to MPOL_DEFAULT
2023-10-23T17:10:20.822804+08:00 1 Completed initialization of buffer pool
2023-10-23T17:10:22.352134+08:00 0 If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be chang
ed. See the man page of setpriority().
2023-10-23T17:10:23.116978+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2023-10-23T17:10:23.183223+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2023-10-23T17:10:23.191288+08:00 1 Using './#ib_16384_2.dblwr' for doublewrite
2023-10-23T17:10:23.202994+08:00 1 Using './#ib_16384_3.dblwr' for doublewrite
2023-10-23T17:10:23.220992+08:00 1 Using './#ib_16384_4.dblwr' for doublewrite
2023-10-23T17:10:23.221441+08:00 1 Using './#ib_16384_5.dblwr' for doublewrite
2023-10-23T17:10:23.225543+08:00 1 Using './#ib_16384_6.dblwr' for doublewrite
2023-10-23T17:10:23.236496+08:00 1 Using './#ib_16384_7.dblwr' for doublewrite
2023-10-23T17:10:23.239336+08:00 1 Using './#ib_16384_8.dblwr' for doublewrite
2023-10-23T17:10:23.239745+08:00 1 Using './#ib_16384_9.dblwr' for doublewrite
2023-10-23T17:10:23.241927+08:00 1 Using './#ib_16384_10.dblwr' for doublewrite
2023-10-23T17:10:23.243484+08:00 1 Using './#ib_16384_11.dblwr' for doublewrite
2023-10-23T17:10:23.245607+08:00 1 Using './#ib_16384_12.dblwr' for doublewrite
2023-10-23T17:10:23.318329+08:00 1 Using './#ib_16384_13.dblwr' for doublewrite
2023-10-23T17:10:23.449407+08:00 1 Using './#ib_16384_14.dblwr' for doublewrite
2023-10-23T17:10:23.451398+08:00 1 Using './#ib_16384_15.dblwr' for doublewrite
2023-10-23T17:10:23.457437+08:00 1 Double write buffer files: 16
2023-10-23T17:10:23.457475+08:00 1 Double write buffer pages per instance: 4
2023-10-23T17:10:23.457505+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2023-10-23T17:10:23.457530+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2023-10-23T17:10:23.457547+08:00 1 Using './#ib_16384_2.dblwr' for doublewrite
2023-10-23T17:10:23.457564+08:00 1 Using './#ib_16384_3.dblwr' for doublewrite
2023-10-23T17:10:23.457581+08:00 1 Using './#ib_16384_4.dblwr' for doublewrite
2023-10-23T17:10:23.457596+08:00 1 Using './#ib_16384_5.dblwr' for doublewrite
2023-10-23T17:10:23.457612+08:00 1 Using './#ib_16384_6.dblwr' for doublewrite
2023-10-23T17:10:23.457628+08:00 1 Using './#ib_16384_7.dblwr' for doublewrite
2023-10-23T17:10:23.457645+08:00 1 Using './#ib_16384_8.dblwr' for doublewrite
2023-10-23T17:10:23.457661+08:00 1 Using './#ib_16384_9.dblwr' for doublewrite
2023-10-23T17:10:23.457677+08:00 1 Using './#ib_16384_10.dblwr' for doublewrite
2023-10-23T17:10:23.457693+08:00 1 Using './#ib_16384_11.dblwr' for doublewrite
2023-10-23T17:10:23.457710+08:00 1 Using './#ib_16384_12.dblwr' for doublewrite
2023-10-23T17:10:23.457726+08:00 1 Using './#ib_16384_13.dblwr' for doublewrite
2023-10-23T17:10:23.457749+08:00 1 Using './#ib_16384_14.dblwr' for doublewrite
2023-10-23T17:10:23.457765+08:00 1 Using './#ib_16384_15.dblwr' for doublewrite
2023-10-23T17:10:23.696425+08:00 1 The latest found checkpoint is at lsn = 20958876 in redo log file ./#innodb_redo/#ib_redo0.
2023-10-23T17:10:23.700597+08:00 1 The log sequence number 20055393 in the system tablespace does not match the log sequence number 2095
8876 in the redo log files!
2023-10-23T17:10:23.700630+08:00 1 Database was not shutdown normally!
2023-10-23T17:10:23.700638+08:00 1 Starting crash recovery.
2023-10-23T17:10:23.759786+08:00 1 Starting to parse redo log at lsn = 20958770, whereas checkpoint_lsn = 20958876 and start_lsn = 20958
720
2023-10-23T17:10:23.759873+08:00 1 Doing recovery: scanned up to log sequence number 20958876
2023-10-23T17:10:23.766719+08:00 1 Log background threads are being started...
2023-10-23T17:10:23.901795+08:00 1 Applying a batch of 0 redo log records ...
2023-10-23T17:10:23.901832+08:00 1 Apply batch completed!
2023-10-23T17:10:23.902343+08:00 1 Using undo tablespace './undo_001'.
2023-10-23T17:10:23.902901+08:00 1 Using undo tablespace './undo_002'.
2023-10-23T17:10:23.904097+08:00 1 Opened 2 existing undo tablespaces.
2023-10-23T17:10:23.904184+08:00 1 GTID recovery trx_no: 8818
2023-10-23T17:10:23.967782+08:00 1 Parallel initialization of rseg complete
2023-10-23T17:10:23.967848+08:00 1 Time taken to initialize rseg using 2 thread: 63669 ms.
2023-10-23T17:10:23.968278+08:00 1 Removed temporary tablespace data file: "ibtmp1"
2023-10-23T17:10:23.968299+08:00 1 Creating shared tablespace for temporary tables
2023-10-23T17:10:23.968332+08:00 1 Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-23T17:10:23.977301+08:00 1 File './ibtmp1' size is now 12 MB.
2023-10-23T17:10:23.977414+08:00 1 Scanning temp tablespace dir:'./#innodb_temp/'
2023-10-23T17:10:23.985654+08:00 1 Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-10-23T17:10:23.992697+08:00 1 Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 20958886
2023-10-23T17:10:23.993756+08:00 1 InnoDB initialization has ended.
2023-10-23T17:10:24.001916+08:00 1 Data dictionary restarting version '80023'.
2023-10-23T17:10:24.095437+08:00 1 Reading DD tablespace files
2023-10-23T17:10:24.096886+08:00 1 Scanned 7 tablespaces. Validated 7.
2023-10-23T17:10:24.110091+08:00 1 Using data dictionary with version '80023'.
2023-10-23T17:10:24.142006+08:00 0 Plugin mysqlx reported: 'IPv6 is available'
2023-10-23T17:10:24.142105+08:00 0 Plugin mysqlx reported: 'Retrying `bind()` on TCP/IP port 33060'
2023-10-23T17:10:25.144557+08:00 0 Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2023-10-23T17:10:25.144664+08:00 0 Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error:
Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
2023-10-23T17:10:25.144675+08:00 0 Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping
this value.'
2023-10-23T17:10:25.144703+08:00 0 Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID 28816
is using UNIX socket file'
2023-10-23T17:10:25.144710+08:00 0 Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_port,mysqlx_bind_address' sys
tem variables to fix the error'
2023-10-23T17:10:25.144720+08:00 0 Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to f
ix the error'
2023-10-23T17:10:25.219420+08:00 0 Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform
or insufficient privilege.
2023-10-23T17:10:25.223839+08:00 0 Recovering after a crash using binlog
2023-10-23T17:10:25.224071+08:00 0 Starting XA crash recovery...
2023-10-23T17:10:25.237938+08:00 0 Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions
.
2023-10-23T17:10:25.238085+08:00 0 Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions
.
2023-10-23T17:10:25.238113+08:00 0 XA crash recovery finished.
2023-10-23T17:10:25.248950+08:00 0 DDL log recovery : begin
2023-10-23T17:10:25.249473+08:00 0 DDL log recovery : end
2023-10-23T17:10:25.260595+08:00 0 Loading buffer pool(s) from /data/GreatSQL/3306/ib_buffer_pool
2023-10-23T17:10:25.357836+08:00 0 Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support usin
g them.
2023-10-23T17:10:25.357950+08:00 0 Skipping generation of SSL certificates as certificate files are present in data directory.
2023-10-23T17:10:25.362222+08:00 0 CA certificate ca.pem is self signed.
2023-10-23T17:10:25.362364+08:00 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this chan
nel.
2023-10-23T17:10:25.362512+08:00 0 Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are
present in data directory.
2023-10-23T17:10:25.362549+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key fil
es are present in data directory.
2023-10-23T17:10:25.363960+08:00 0 Server hostname (bind-address): '*'; port: 3306
2023-10-23T17:10:25.364028+08:00 0 IPv6 is available.
2023-10-23T17:10:25.364053+08:00 0 - '::' resolves to '::';
2023-10-23T17:10:25.364064+08:00 0 Server socket created on IP: '::'.
2023-10-23T17:10:25.426397+08:00 0 Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server
acts as a slave and has his hostname changed!! Please use '--relay-log=localhost-relay-bin' to avoid this problem.
2023-10-23T17:10:25.430412+08:00 0 Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
TID protocol will be used to replicate unapplied transactions.
2023-10-23T17:10:25.438915+08:00 0 Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
TID protocol will be used to replicate unapplied transactions.
2023-10-23T17:10:25.440935+08:00 0 Failed to start slave threads for channel ''.
2023-10-23T17:10:25.445123+08:00 0 /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld: ready for connections. Version: '8
.0.32-24'socket: '/data/GreatSQL/3306/mysql.sock'port: 3306GreatSQL, Release 24, Revision 3714067bc8c.
2023-10-23T17:10:25.445422+08:00 0 Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2023-10-23T17:10:25.445786+08:00 0 Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2023-10-23T17:10:25.449703+08:00 7 Event Scheduler: scheduler thread started with id 7
2023-10-23T17:10:25.497606+08:00 0 Buffer pool(s) load completed at 231023 17:10:25
3307的日志
# more /data/GreatSQL/3307/error.log
2023-10-23T17:10:13.833136+08:00 17 Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2023-10-23T17:10:13.833632+08:00 17 Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2023-10-23T17:10:13.839342+08:00 17 Plugin group_replication reported: 'Setting super_read_only=ON.'
2023-10-23T17:10:13.847596+08:00 17 Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode:
"DISABLED"'
2023-10-23T17:10:13.848869+08:00 17 Plugin group_replication reported: ' Debug messages will be sent to: asynchronous::/data/GreatSQL
/3307/GCS_DEBUG_TRACE'
2023-10-23T17:10:13.853125+08:00 17 Plugin group_replication reported: ' Added automatically IP ranges 127.0.0.1/8,192.168.188.60/24,
::1/128,fe80::5c30:c5fd:1c8d:a5e3/64 to the allowlist'
2023-10-23T17:10:13.854896+08:00 17 Plugin group_replication reported: ' SSL was not enabled'
2023-10-23T17:10:13.854984+08:00 17 Plugin group_replication reported: 'Initialized group communication with configuration: group_replicat
ion_group_name: 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1'; group_replication_local_address: '192.168.188.60:33071'; group_replication_group_seeds: '192.168.188.60:3306
1,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091'; group_replication_bootstrap_group: 'false'; group_replication_poll_spin_loops: 0; group_replicati
on_compression_threshold: 1000000; group_replication_ip_allowlist: 'AUTOMATIC'; group_replication_communication_debug_options: 'GCS_DEBUG_NONE'; group_replication_m
ember_expel_timeout: '5'; group_replication_communication_max_message_size: 10485760; group_replication_message_cache_size: '1073741824u; group_replication_communic
ation_stack: '0''
2023-10-23T17:10:13.855496+08:00 17 Plugin group_replication reported: 'Member configuration: member_id: 3307; member_uuid: "514668fd-7173
-11ee-b9b4-000c29e3b420"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; group_replication_view_change_uuid: "AUTOMATIC";'
2023-10-23T17:10:13.855559+08:00 17 Plugin group_replication reported: 'Init certifier broadcast thread'
2023-10-23T17:10:13.861469+08:00 19 Plugin group_replication reported: 'Detected previous RESET MASTER invocation or an issue exists in th
e group replication applier relay log. Purging existing applier logs.'
2023-10-23T17:10:13.874092+08:00 19 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NU
LL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4,
master_bind=''.
2023-10-23T17:10:14.046125+08:00 21 Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIR
ST' at position 0, relay log './localhost-relay-bin-group_replication_applier.000001' position: 4
2023-10-23T17:10:14.046877+08:00 17 Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-10-23T17:10:14.050156+08:00 17 Plugin group_replication reported: ' buckets:2000000, dec_threshold_length:1000000'
2023-10-23T17:10:14.051118+08:00 0 Plugin group_replication reported: ' 1698052214.051087 pid 28817 xcom_id 0 state xcom_fsm_init act
ion x_fsm_init'
2023-10-23T17:10:14.051154+08:00 0 Plugin group_replication reported: ' Init xcom thread'
2023-10-23T17:10:15.655314+08:00 0 Plugin group_replication reported: ' Using XCom as Communication Stack for XCom'
2023-10-23T17:10:15.656914+08:00 0 Plugin group_replication reported: ' XCom initialized and ready to accept incoming connections on
port 33071'
2023-10-23T17:10:15.657713+08:00 0 Plugin group_replication reported: ' Successfully connected to the local XCom via anonymous pipe'
2023-10-23T17:10:15.658697+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.658878+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.658981+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659079+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659179+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659269+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659325+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659345+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659361+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659375+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659391+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659406+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659426+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659442+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659541+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659632+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659693+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659743+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659839+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659918+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.659985+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660053+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660131+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660190+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660266+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660348+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660441+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660530+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
061 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660612+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
081 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660681+08:00 0 Plugin group_replication reported: ' Error on opening a connection to peer node 192.168.188.60:33
091 when joining a group. My local port is: 33071.'
2023-10-23T17:10:15.660708+08:00 0 Plugin group_replication reported: ' Error connecting to all peers. Member join failed. Local por
t: 33071'
2023-10-23T17:10:15.668077+08:00 0 Plugin group_replication reported: ' 1698052215.667896 pid 28817 xcom_id b039bd31 state xcom_fsm_s
tart action x_fsm_terminate'
2023-10-23T17:10:15.668258+08:00 0 Plugin group_replication reported: ' 1698052215.668241 pid 28817 xcom_id b039bd31 state xcom_fsm_s
tart action x_fsm_exit'
2023-10-23T17:10:15.668320+08:00 0 Plugin group_replication reported: ' Exiting xcom thread'
2023-10-23T17:10:15.668434+08:00 0 Plugin group_replication reported: ' set CON_NULL for fd:59 in close_connection'
2023-10-23T17:10:15.878116+08:00 0 Plugin group_replication reported: ' The member was unable to join the group. Local port: 33071'
2023-10-23T17:10:15.878296+08:00 0 Plugin group_replication reported: ' Sleeping for 5 seconds before retrying to join the group. The
re are 9 more attempt(s) before giving up.'
2023-10-23T17:10:21.075144+08:00 0 Plugin group_replication reported: ' 1698052221.040079 pid 28817 xcom_id b039bd31 state xcom_fsm_s
tart action x_fsm_init'
2023-10-23T17:10:24.265037+08:00 0 Could not increase number of max_open_files to more than 10000 (request: 65535)
2023-10-23T17:10:24.465777+08:00 0 The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Plea
se use log_slow_replica_statements instead.
2023-10-23T17:10:24.465809+08:00 0 The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use
replica_parallel_type instead.
2023-10-23T17:10:24.465812+08:00 0 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2023-10-23T17:10:24.465817+08:00 0 The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please
use replica_parallel_workers instead.
2023-10-23T17:10:24.465823+08:00 0 The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Pl
ease use replica_preserve_commit_order instead.
2023-10-23T17:10:24.465829+08:00 0 The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please
use replica_checkpoint_period instead.
2023-10-23T17:10:24.465908+08:00 0 Insecure configuration for --secure-file-priv: Current value does not restrict location of generat
ed files. Consider setting it to a valid, non-empty path.
2023-10-23T17:10:24.465911+08:00 0 Insecure configuration for --secure-log-path: Current value does not restrict location of generate
d files. Consider setting it to a valid, non-empty path.
2023-10-23T17:10:24.465951+08:00 0 BuildID=5850d8e16b7845a955d11d6965d9d658fd24b257
2023-10-23T17:10:24.465954+08:00 0 Basedir set to /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/.
2023-10-23T17:10:24.465958+08:00 0 /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld (mysqld 8.0.32-24) starting as proc
ess 30314
2023-10-23T17:10:24.473715+08:00 0 innodb_open_files should not be greater than the open_files_limit.
2023-10-23T17:10:24.473741+08:00 0 Using Linux native AIO
2023-10-23T17:10:24.473758+08:00 0 Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity ins
tead.
2023-10-23T17:10:24.473765+08:00 0 Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacit
y instead.
2023-10-23T17:10:24.473943+08:00 0 Plugin 'FEDERATED' is disabled.
2023-10-23T17:10:24.474012+08:00 0 Plugin 'ndbcluster' is disabled.
2023-10-23T17:10:24.474027+08:00 0 Plugin 'ndbinfo' is disabled.
2023-10-23T17:10:24.474034+08:00 0 Plugin 'ndb_transid_mysql_connection_map' is disabled.
2023-10-23T17:10:24.477236+08:00 1 InnoDB initialization has started.
2023-10-23T17:10:24.477267+08:00 1 Atomic write enabled
2023-10-23T17:10:24.477288+08:00 1 PUNCH HOLE support available
2023-10-23T17:10:24.477299+08:00 1 Uses event mutexes
2023-10-23T17:10:24.477304+08:00 1 GCC builtin __atomic_thread_fence() is used for memory barrier
2023-10-23T17:10:24.477310+08:00 1 Compressed tables use zlib 1.2.13
2023-10-23T17:10:24.479093+08:00 1 Using hardware accelerated crc32 and polynomial multiplication.
2023-10-23T17:10:24.479387+08:00 1 Directories to scan './'
2023-10-23T17:10:24.479426+08:00 1 Scanning './'
2023-10-23T17:10:24.485376+08:00 1 Completed space ID check of 5 files.
2023-10-23T17:10:24.486187+08:00 1 Initializing buffer pool, total size = 2.000000G, instances = 8, chunk size =128.000000M
2023-10-23T17:10:24.486209+08:00 1 Setting NUMA memory policy to MPOL_INTERLEAVE
2023-10-23T17:10:26.508289+08:00 1 Setting NUMA memory policy to MPOL_DEFAULT
2023-10-23T17:10:26.538786+08:00 1 Completed initialization of buffer pool
2023-10-23T17:10:26.664916+08:00 0 If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be chang
ed. See the man page of setpriority().
2023-10-23T17:10:26.731933+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2023-10-23T17:10:26.735804+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2023-10-23T17:10:26.738182+08:00 1 Using './#ib_16384_2.dblwr' for doublewrite
2023-10-23T17:10:26.738648+08:00 1 Using './#ib_16384_3.dblwr' for doublewrite
2023-10-23T17:10:26.740873+08:00 1 Using './#ib_16384_4.dblwr' for doublewrite
2023-10-23T17:10:26.741337+08:00 1 Using './#ib_16384_5.dblwr' for doublewrite
2023-10-23T17:10:26.743268+08:00 1 Using './#ib_16384_6.dblwr' for doublewrite
2023-10-23T17:10:26.743720+08:00 1 Using './#ib_16384_7.dblwr' for doublewrite
2023-10-23T17:10:26.746396+08:00 1 Using './#ib_16384_8.dblwr' for doublewrite
2023-10-23T17:10:26.746802+08:00 1 Using './#ib_16384_9.dblwr' for doublewrite
2023-10-23T17:10:26.754946+08:00 1 Using './#ib_16384_10.dblwr' for doublewrite
2023-10-23T17:10:26.755899+08:00 1 Using './#ib_16384_11.dblwr' for doublewrite
2023-10-23T17:10:26.758893+08:00 1 Using './#ib_16384_12.dblwr' for doublewrite
2023-10-23T17:10:26.759725+08:00 1 Using './#ib_16384_13.dblwr' for doublewrite
2023-10-23T17:10:26.762937+08:00 1 Using './#ib_16384_14.dblwr' for doublewrite
2023-10-23T17:10:26.763194+08:00 1 Using './#ib_16384_15.dblwr' for doublewrite
2023-10-23T17:10:26.791103+08:00 1 Double write buffer files: 16
2023-10-23T17:10:26.791182+08:00 1 Double write buffer pages per instance: 4
2023-10-23T17:10:26.791231+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2023-10-23T17:10:26.791259+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2023-10-23T17:10:26.791278+08:00 1 Using './#ib_16384_2.dblwr' for doublewrite
2023-10-23T17:10:26.791297+08:00 1 Using './#ib_16384_3.dblwr' for doublewrite
2023-10-23T17:10:26.791316+08:00 1 Using './#ib_16384_4.dblwr' for doublewrite
2023-10-23T17:10:26.791335+08:00 1 Using './#ib_16384_5.dblwr' for doublewrite
2023-10-23T17:10:26.791355+08:00 1 Using './#ib_16384_6.dblwr' for doublewrite
2023-10-23T17:10:26.791422+08:00 1 Using './#ib_16384_7.dblwr' for doublewrite
2023-10-23T17:10:26.791453+08:00 1 Using './#ib_16384_8.dblwr' for doublewrite
2023-10-23T17:10:26.791470+08:00 1 Using './#ib_16384_9.dblwr' for doublewrite
2023-10-23T17:10:26.791489+08:00 1 Using './#ib_16384_10.dblwr' for doublewrite
2023-10-23T17:10:26.791506+08:00 1 Using './#ib_16384_11.dblwr' for doublewrite
2023-10-23T17:10:26.791523+08:00 1 Using './#ib_16384_12.dblwr' for doublewrite
2023-10-23T17:10:26.791540+08:00 1 Using './#ib_16384_13.dblwr' for doublewrite
2023-10-23T17:10:26.791557+08:00 1 Using './#ib_16384_14.dblwr' for doublewrite
2023-10-23T17:10:26.791587+08:00 1 Using './#ib_16384_15.dblwr' for doublewrite
2023-10-23T17:10:26.962970+08:00 1 The latest found checkpoint is at lsn = 20671660 in redo log file ./#innodb_redo/#ib_redo0.
2023-10-23T17:10:26.995701+08:00 1 The log sequence number 20053481 in the system tablespace does not match the log sequence number 2067
1660 in the redo log files!
2023-10-23T17:10:27.000907+08:00 1 Database was not shutdown normally!
2023-10-23T17:10:27.000944+08:00 1 Starting crash recovery.
2023-10-23T17:10:27.061646+08:00 1 Starting to parse redo log at lsn = 20671529, whereas checkpoint_lsn = 20671660 and start_lsn = 20671
488
2023-10-23T17:10:27.061690+08:00 1 Doing recovery: scanned up to log sequence number 20671660
2023-10-23T17:10:27.121076+08:00 1 Log background threads are being started...
2023-10-23T17:10:27.282804+08:00 1 Applying a batch of 0 redo log records ...
2023-10-23T17:10:27.284115+08:00 1 Apply batch completed!
2023-10-23T17:10:27.284716+08:00 1 Using undo tablespace './undo_001'.
2023-10-23T17:10:27.285180+08:00 1 Using undo tablespace './undo_002'.
2023-10-23T17:10:27.285856+08:00 1 Opened 2 existing undo tablespaces.
2023-10-23T17:10:27.287149+08:00 1 GTID recovery trx_no: 7318
2023-10-23T17:10:27.384809+08:00 1 Parallel initialization of rseg complete
2023-10-23T17:10:27.386421+08:00 1 Time taken to initialize rseg using 2 thread: 99275 ms.
2023-10-23T17:10:27.386560+08:00 1 Removed temporary tablespace data file: "ibtmp1"
2023-10-23T17:10:27.386578+08:00 1 Creating shared tablespace for temporary tables
2023-10-23T17:10:27.386607+08:00 1 Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-23T17:10:27.396242+08:00 1 File './ibtmp1' size is now 12 MB.
2023-10-23T17:10:27.396455+08:00 1 Scanning temp tablespace dir:'./#innodb_temp/'
2023-10-23T17:10:27.401950+08:00 1 Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-10-23T17:10:27.402244+08:00 1 Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 20671670
2023-10-23T17:10:27.406307+08:00 1 InnoDB initialization has ended.
2023-10-23T17:10:27.439941+08:00 1 Data dictionary restarting version '80023'.
2023-10-23T17:10:27.531815+08:00 1 Reading DD tablespace files
2023-10-23T17:10:27.534356+08:00 1 Scanned 7 tablespaces. Validated 7.
2023-10-23T17:10:27.560140+08:00 1 Using data dictionary with version '80023'.
2023-10-23T17:10:27.603406+08:00 0 Plugin mysqlx reported: 'IPv6 is available'
2023-10-23T17:10:27.603493+08:00 0 Plugin mysqlx reported: 'Retrying `bind()` on TCP/IP port 33060'
2023-10-23T17:10:28.604094+08:00 0 Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2023-10-23T17:10:28.604142+08:00 0 Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error:
Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
2023-10-23T17:10:28.604151+08:00 0 Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping
this value.'
2023-10-23T17:10:28.604170+08:00 0 Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID 28816
is using UNIX socket file'
2023-10-23T17:10:28.604177+08:00 0 Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_port,mysqlx_bind_address' sys
tem variables to fix the error'
2023-10-23T17:10:28.604183+08:00 0 Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to f
ix the error'
2023-10-23T17:10:28.642641+08:00 0 Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform
or insufficient privilege.
2023-10-23T17:10:28.645404+08:00 0 Recovering after a crash using binlog
2023-10-23T17:10:28.645447+08:00 0 Starting XA crash recovery...
2023-10-23T17:10:28.664329+08:00 0 Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions
.
2023-10-23T17:10:28.664395+08:00 0 Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions
.
2023-10-23T17:10:28.664403+08:00 0 XA crash recovery finished.
2023-10-23T17:10:28.667744+08:00 0 DDL log recovery : begin
2023-10-23T17:10:28.667944+08:00 0 DDL log recovery : end
2023-10-23T17:10:28.668071+08:00 0 Loading buffer pool(s) from /data/GreatSQL/3307/ib_buffer_pool
2023-10-23T17:10:28.737188+08:00 0 Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support usin
g them.
2023-10-23T17:10:28.737228+08:00 0 Skipping generation of SSL certificates as certificate files are present in data directory.
2023-10-23T17:10:28.739371+08:00 0 CA certificate ca.pem is self signed.
2023-10-23T17:10:28.739475+08:00 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this chan
nel.
2023-10-23T17:10:28.739527+08:00 0 Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are
present in data directory.
2023-10-23T17:10:28.739542+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key fil
es are present in data directory.
2023-10-23T17:10:28.740062+08:00 0 Server hostname (bind-address): '*'; port: 3307
2023-10-23T17:10:28.740094+08:00 0 IPv6 is available.
2023-10-23T17:10:28.740110+08:00 0 - '::' resolves to '::';
2023-10-23T17:10:28.740121+08:00 0 Server socket created on IP: '::'.
2023-10-23T17:10:28.753812+08:00 0 Buffer pool(s) load completed at 231023 17:10:28
2023-10-23T17:10:28.757085+08:00 0 Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server
acts as a slave and has his hostname changed!! Please use '--relay-log=localhost-relay-bin' to avoid this problem.
2023-10-23T17:10:28.758776+08:00 0 Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
TID protocol will be used to replicate unapplied transactions.
2023-10-23T17:10:28.763140+08:00 0 Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
TID protocol will be used to replicate unapplied transactions.
2023-10-23T17:10:28.763878+08:00 0 Failed to start slave threads for channel ''.
2023-10-23T17:10:28.765145+08:00 7 Event Scheduler: scheduler thread started with id 7
2023-10-23T17:10:28.765251+08:00 0 /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld: ready for connections. Version: '8
.0.32-24'socket: '/data/GreatSQL/3307/mysql.sock'port: 3307GreatSQL, Release 24, Revision 3714067bc8c.
2023-10-23T17:10:28.765355+08:00 0 Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2023-10-23T17:10:28.765798+08:00 0 Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
看起来关于MGR这部分似乎没设置正确，可以参考手册再做一遍
RPM安装并构建MGR集群 | GreatSQL官方手册
页:
[1]