About PXC-8.0, I have some questions to ask for help.
Currently, I have deployed a three-nodes PXC with version 5.7. To increase the cluster size, I deployed another server with PXC-8.0.Now I want to add this 8.0 node into the 5.7 cluster, but failed.
Before this, I have tried some ways in ‘/etc/mysql/mysql.conf.d/mysqld.cnf’, such as set ‘pxc-encrypt-cluster-traffic’ to OFF, set ‘wsrep_sst_auth’ and then through auth.At last, percona returned some errors:
INFO: Skipping wsrep-recover for 00000000-0000-0000-0000-000000000000:6551394 pair INFO: Assigning 00000000-0000-0000-0000-000000000000:6551394 to wsrep_start_position2020-06-15T09:42:31.098949Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-9) starting as process 355262020-06-15T09:42:31.101089Z 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib/galera4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:65513942020-06-15T09:42:31.101166Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library '/usr/lib/galera4/libgalera_smm.so’2020-06-15T09:42:31.103196Z 0 [Note] [MY-000000] [Galera] wsrep_load(): Galera 4.3(r752664d) by Codership Oy <info@codership.com> loaded successfully.2020-06-15T09:42:31.103258Z 0 [Note] [MY-000000] [Galera] CRC-32C: using hardware acceleration.2020-06-15T09:42:31.103609Z 0 [Note] [MY-000000] [Galera] Found saved state: 00000000-0000-0000-0000-000000000000:6551394, safe_to_bootstrap: 02020-06-15T09:42:31.103741Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble:Version: 2UUID: a2d02704-eb0d-11e9-9701-2ac72da01b71Seqno: -1 - -1Offset: -1Synced: 02020-06-15T09:42:31.103809Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: version: 2, UUID: a2d02704-eb0d-11e9-9701-2ac72da01b71, offset: -12020-06-15T09:42:31.103948Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan… 0.0% ( 0/134217752 bytes) complete.2020-06-15T09:42:31.156815Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan…100.0% (134217752/134217752 bytes) complete.2020-06-15T09:42:31.156934Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: didn’t recover any events.2020-06-15T09:42:31.157697Z 0 [Note] [MY-000000] [Galera] Complete reset of the galera cache2020-06-15T09:42:31.244757Z 0 [Note] [MY-000000] [Galera] Flushing memory map to disk…2020-06-15T09:42:31.415345Z 0 [Note] [MY-000000] [Galera] Passing config to GCS: base_dir = /srv/mysql/; base_host = 172.31.32.114; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /srv/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 10; socket.checksum = 2; socket.recv_buf_size = 212992;2020-06-15T09:42:31.430504Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed.2020-06-15T09:42:31.430673Z 0 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:6551394, protocol version: -12020-06-15T09:42:31.430762Z 0 [Note] [MY-000000] [Galera] GCache history reset: old(a2d02704-eb0d-11e9-9701-2ac72da01b71:0 -> 00000000-0000-0000-0000-000000000000:65513942020-06-15T09:42:31.431618Z 0 [Note] [MY-000000] [WSREP] Starting replication2020-06-15T09:42:31.431697Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 02020-06-15T09:42:31.431788Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 00000000-0000-0000-0000-000000000000:65513942020-06-15T09:42:31.431934Z 0 [ERROR] [MY-000000] [Galera] Non-negative state seqno requires non-nil history UUID: 00000000-0000-0000-0000-000000000000:65513942020-06-15T09:42:31.431969Z 0 [ERROR] [MY-000000] [Galera] gcs init failed:Invalid argument2020-06-15T09:42:31.431991Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://45.79.37.191) failed to establish connection with cluster (reason: 7)2020-06-15T09:42:31.432012Z 0 [ERROR] [MY-010119] [Server] Aborting2020-06-15T09:42:31.432256Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-9) Percona XtraDB Cluster (GPL), Release rel9, Revision 6490e00, WSREP version 26.4.3.2020-06-15T09:42:31.432565Z 0 [Note] [MY-000000] [Galera] dtor state: CLOSED2020-06-15T09:42:31.432613Z 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 02020-06-15T09:42:31.434407Z 0 [Note] [MY-000000] [Galera] apply mon: entered 02020-06-15T09:42:31.436224Z 0 [Note] [MY-000000] [Galera] apply mon: entered 02020-06-15T09:42:31.438306Z 0 [Note] [MY-000000] [Galera] apply mon: entered 02020-06-15T09:42:31.438330Z 0 [Note] [MY-000000] [Galera] cert index usage at exit 02020-06-15T09:42:31.438339Z 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 02020-06-15T09:42:31.438346Z 0 [Note] [MY-000000] [Galera] deps set usage at exit 02020-06-15T09:42:31.438360Z 0 [Note] [MY-000000] [Galera] avg deps dist 02020-06-15T09:42:31.438368Z 0 [Note] [MY-000000] [Galera] avg cert interval 02020-06-15T09:42:31.438375Z 0 [Note] [MY-000000] [Galera] cert index size 02020-06-15T09:42:31.438412Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed.2020-06-15T09:42:31.438470Z 0 [Note] [MY-000000] [Galera] wsdb trx map usage 0 conn query map usage 02020-06-15T09:42:31.438504Z 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 02020-06-15T09:42:31.439233Z 0 [Note] [MY-000000] [Galera] Flushing memory map to disk…
If I don’t upgrade 5.7 nodes to 8.0, what should I do?
Thanks a lot.
Currently, you can not add an 8.0 node to a 5.7 cluster, or rather, you can not have a ‘mixed’ version cluster. You must bootstrap a new 8.0 cluster. This situation is referred to as a “rolling upgrade”. We are working on this process and will be providing documentation and guidance soon. Redirecting
–George O. Lorch IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
George Lorch said: Currently, you can not add an 8.0 node to a 5.7 cluster, or rather, you can not have a 'mixed' version cluster. You must bootstrap a new 8.0 cluster. This situation is referred to as a "rolling upgrade". We are working on this process and will be providing documentation and guidance soon. https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/upgrade_guide.html#id6Hi, thanks for your response. And I have another question to confirm.
--George O. Lorch IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
The 'mixed' version cluster means that I even can not add a 5.7 node to a 5.6 cluster. Is that right?
For Percona XtraDB Cluster 5.6 and 5.7, yes, you can perform a rolling upgrade as described here https://www.percona.com/doc/percona-xtradb-cluster/5.7/howtos/upgrade_guide.html. It is not advisable though to run a cluster in a mixed major version mode for any length of time.
The challenge with 8.0 is due to the major changes in the Galera 4.x series Writeset Replication protocol which limits the compatibility with the 3.x series protocol used in Percona XtraDB Cluster 5.6 and 5.7 series.
–George O. Lorch IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup