https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/ Tue, 20 Feb 2024 16:54:50 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/#comment-10973281 Wed, 28 Jul 2021 10:47:17 +0000 https://www.percona.com/blog/?p=77286#comment-10973281 This procedure fails with PXC 8.0, or at least I could not find any way to make it work.

]]> https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/#comment-10973280 Wed, 28 Jul 2021 10:45:06 +0000 https://www.percona.com/blog/?p=77286#comment-10973280 Thanks! Yes, without GTID is it very similar, just also the initial replication binlog position needs to be found out from the binary log , based on relevant Xid. Fortunately, Xid are consistent across all cluster nodes.

]]> https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/#comment-10973278 Thu, 22 Jul 2021 18:32:33 +0000 https://www.percona.com/blog/?p=77286#comment-10973278 Does it only work for 5.7 or would similar procedure work for Percona XtraDB Cluster 8.0 too ?

]]> https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/#comment-10973271 Thu, 15 Jul 2021 09:03:11 +0000 https://www.percona.com/blog/?p=77286#comment-10973271 Great post thanks ! If GTID is not enabled, how would you do it ? I guess parsing binary logs, grep Xid= to get the next correct position ?

]]>