Not the answer you need?
Register and ask your own question!

How can I add 8.0 node into 5.7 cluster?

brotherbrother Current User Role Beginner
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_position
2020-06-15T09:42:31.098949Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-9) starting as process 35526
2020-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:6551394
2020-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 <[email protected]> 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: 0
2020-06-15T09:42:31.103741Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble:
Version: 2
UUID: a2d02704-eb0d-11e9-9701-2ac72da01b71
Seqno: -1 - -1
Offset: -1
Synced: 0
2020-06-15T09:42:31.103809Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: version: 2, UUID: a2d02704-eb0d-11e9-9701-2ac72da01b71, offset: -1
2020-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 cache
2020-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: -1
2020-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:6551394
2020-06-15T09:42:31.431618Z 0 [Note] [MY-000000] [WSREP] Starting replication
2020-06-15T09:42:31.431697Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 0
2020-06-15T09:42:31.431788Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 00000000-0000-0000-0000-000000000000:6551394
2020-06-15T09:42:31.431934Z 0 [ERROR] [MY-000000] [Galera] Non-negative state seqno requires non-nil history UUID: 00000000-0000-0000-0000-000000000000:6551394
2020-06-15T09:42:31.431969Z 0 [ERROR] [MY-000000] [Galera] gcs init failed:Invalid argument
2020-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] Aborting
2020-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: CLOSED
2020-06-15T09:42:31.432613Z 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2020-06-15T09:42:31.434407Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0
2020-06-15T09:42:31.436224Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0
2020-06-15T09:42:31.438306Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0
2020-06-15T09:42:31.438330Z 0 [Note] [MY-000000] [Galera] cert index usage at exit 0
2020-06-15T09:42:31.438339Z 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 0
2020-06-15T09:42:31.438346Z 0 [Note] [MY-000000] [Galera] deps set usage at exit 0
2020-06-15T09:42:31.438360Z 0 [Note] [MY-000000] [Galera] avg deps dist 0
2020-06-15T09:42:31.438368Z 0 [Note] [MY-000000] [Galera] avg cert interval 0
2020-06-15T09:42:31.438375Z 0 [Note] [MY-000000] [Galera] cert index size 0
2020-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 0
2020-06-15T09:42:31.438504Z 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2020-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.

Answers

  • George LorchGeorge Lorch Percona Percona Moderator Role Patron
    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#id6

    --
    George O. Lorch III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
  • brotherbrother Current User Role Beginner
    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#id6

    --
    George O. Lorch III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
    Hi, thanks for your response. And I have another question to confirm.
    The  'mixed' version cluster means that I even can not add a 5.7 node to a 5.6 cluster. Is that right?
  • George LorchGeorge Lorch Percona Percona Moderator Role Patron
    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 III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.