# Percona XtraDB Cluster 5.x **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=4 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 5 --- ## [Nodes Failing to join cluster Percona xtradb on centos](https://forums.percona.com/t/nodes-failing-to-join-cluster-percona-xtradb-on-centos/18608)
**Author:** [@mercy\_maina](https://forums.percona.com/u/mercy_maina)\ **Replies:** 9\ **Last updated:** [December 7, 2022, 4:31pm UTC](https://forums.percona.com/t/nodes-failing-to-join-cluster-percona-xtradb-on-centos/18608 "2022-12-07T16:31:49Z")
I have installed percona extradb cluster 56 on centos, but when I bootstrap the first node and start MySQL in the other two nodes, they do not join the cluster. I have set SELinux to permissive mode and followed the p… --- ## [Receiving "\[Note\] Got packets out of order" messages after patching to 5.7.35 version](https://forums.percona.com/t/receiving-note-got-packets-out-of-order-messages-after-patching-to-5-7-35-version/13288)
**Author:** [@msutic](https://forums.percona.com/u/msutic)\ **Replies:** 9\ **Last updated:** [December 2, 2022, 11:04am UTC](https://forums.percona.com/t/receiving-note-got-packets-out-of-order-messages-after-patching-to-5-7-35-version/13288 "2022-12-02T11:04:46Z")
Hello, After patching Percona XtraDB Cluster from 5.7.33 → 5.7.35 we started to receive messages: \[Note\] Got packets out of order It looks like client - server communication problem. How can we troubleshoot this issu… --- ## [Process completed with error: wsrep\_sst\_xtrabackup-v2 22 (invalid argument)](https://forums.percona.com/t/process-completed-with-error-wsrep-sst-xtrabackup-v2-22-invalid-argument/5780)
**Author:** [@diego.maravankin](https://forums.percona.com/u/diego.maravankin)\ **Replies:** 4\ **Last updated:** [December 1, 2022, 1:00pm UTC](https://forums.percona.com/t/process-completed-with-error-wsrep-sst-xtrabackup-v2-22-invalid-argument/5780 "2022-12-01T13:00:04Z")
Hello guys, I am creating a XtraDB Cluster from scratch, following the instructions in the documentation: \[url\]https://www.percona.com/doc/percona-xtradb-cluster/5.7/install/apt.html\[/url\] The first node bootstraped co… --- ## [Recreating .frm files with mysqlfrm on Percona XtraDB cluster 5.7](https://forums.percona.com/t/recreating-frm-files-with-mysqlfrm-on-percona-xtradb-cluster-5-7/18636)
**Author:** [@MastaMike](https://forums.percona.com/u/MastaMike)\ **Replies:** 6\ **Last updated:** [November 21, 2022, 5:46am UTC](https://forums.percona.com/t/recreating-frm-files-with-mysqlfrm-on-percona-xtradb-cluster-5-7/18636 "2022-11-21T05:46:17Z")
Hello to everyone dedicating the time to read this thread. I have recently stumbled upon a problem while restoring a MySQL 5.7 database into a Percona XtraDB cluster 5.7. The restoration process was done with the mysql… --- ## [‘Error: mysql conflicts with MySQL’ when install Percona-XtraDB-Cluster-server-56](https://forums.percona.com/t/error-mysql-conflicts-with-mysql-when-install-percona-xtradb-cluster-server-56/6371)
**Author:** [@keith](https://forums.percona.com/u/keith)\ **Replies:** 1\ **Last updated:** [November 17, 2022, 8:42am UTC](https://forums.percona.com/t/error-mysql-conflicts-with-mysql-when-install-percona-xtradb-cluster-server-56/6371 "2022-11-17T08:42:19Z")
I use yum to install Percona-XtraDB-Cluster-server-56 on centos5 Loading "installonlyn" plugin Setting up Install Process Setting up repositories percona-release-i386 100% |=========================| 2.5 kB 00:00 C5.7-b… --- ## [\-98 (Address already in use) - cannot start node](https://forums.percona.com/t/98-address-already-in-use-cannot-start-node/18293)
**Author:** [@jimbo881](https://forums.percona.com/u/jimbo881)\ **Replies:** 6\ **Last updated:** [November 8, 2022, 2:00pm UTC](https://forums.percona.com/t/98-address-already-in-use-cannot-start-node/18293 "2022-11-08T14:00:20Z")
When trying to restart the 3rd node in our cluster, we are getting: 2022-11-01T11:30:00.721346Z 0 \[Warning\] WSREP: error while trying to listen ‘ssl://0.0.0.0:4567?socket.non\_blocking=1’, asio error ‘bind: Address alrea… --- ## [Percona xtraDB cluster fails to come up on IPv6](https://forums.percona.com/t/percona-xtradb-cluster-fails-to-come-up-on-ipv6/18365)
**Author:** [@Supreeth\_Shivanand](https://forums.percona.com/u/Supreeth_Shivanand)\ **Replies:** 3\ **Last updated:** [November 7, 2022, 7:02pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-fails-to-come-up-on-ipv6/18365 "2022-11-07T19:02:35Z")
We are using percone-xtradb-cluster version 5.7.36-31.55 running in kubernetes environment configured on IPv6. I have put this configuration in helm chart while bootstrapping: configuration: | \[mysqld\] pxc\_s… --- ## [Enforce TLS for replication](https://forums.percona.com/t/enforce-tls-for-replication/18139)
**Author:** [@ultrapain](https://forums.percona.com/u/ultrapain)\ **Replies:** 2\ **Last updated:** [October 24, 2022, 2:28pm UTC](https://forums.percona.com/t/enforce-tls-for-replication/18139 "2022-10-24T14:28:19Z")
I have been referencing the following document to try and enforce TLSv1.2 (minimum) for replication, to no avail: I have the following in the \[mysqld\] block of my.cnf: wsrep\_provider\_options=“socket.ssl\_cert=/path/to… --- ## [trying to install on Ubuntu - mysqld.log fPermission denied](https://forums.percona.com/t/trying-to-install-on-ubuntu-mysqld-log-fpermission-denied/6216)
**Author:** [@Ken\_Scott](https://forums.percona.com/u/Ken_Scott)\ **Replies:** 3\ **Last updated:** [October 18, 2022, 8:34am UTC](https://forums.percona.com/t/trying-to-install-on-ubuntu-mysqld-log-fpermission-denied/6216 "2022-10-18T08:34:48Z")
Hello, I’m trying to install “percona-xtradb-cluster-server-5.7” on Ubuntu, but keep running into the same error. I can install no problem on a fresh install og Ubuntu with no MySQL, however if MySQL already exists, I ca… --- ## [xtrabackup SST error](https://forums.percona.com/t/xtrabackup-sst-error/2544)
**Author:** [@dseira](https://forums.percona.com/u/dseira)\ **Replies:** 5\ **Last updated:** [October 9, 2022, 9:16am UTC](https://forums.percona.com/t/xtrabackup-sst-error/2544 "2022-10-09T09:16:13Z")
Hi, I’m trying the Percona XtraDB Cluster for testing purpose. I’ve used the wsrep\_sst\_method with rsync and mysqldump options, and works correctly. The problem comes when I want to try the xtrabackup method for avoid … --- ## [8.0 vs 5.7 INSERTs Performance issues](https://forums.percona.com/t/8-0-vs-5-7-inserts-performance-issues/17434)
**Author:** [@avgustin](https://forums.percona.com/u/avgustin)\ **Replies:** 6\ **Last updated:** [September 29, 2022, 10:16am UTC](https://forums.percona.com/t/8-0-vs-5-7-inserts-performance-issues/17434 "2022-09-29T10:16:48Z")
Hi, Me and my team are noticing quite a significant performance degradation from Percona 5.7 to 8.0 in terms of INSERTs/UPDATEs. Here is a test I’m using (straight from bash): Create a test DB and a test table mysql … --- ## [Unable to add mysql node to percona cluster](https://forums.percona.com/t/unable-to-add-mysql-node-to-percona-cluster/17607)
**Author:** [@maddy0429](https://forums.percona.com/u/maddy0429)\ **Replies:** 3\ **Last updated:** [September 22, 2022, 7:00am UTC](https://forums.percona.com/t/unable-to-add-mysql-node-to-percona-cluster/17607 "2022-09-22T07:00:55Z")
Getting the below error while trying to add a node to the cluster \[!\[enter image description here\]\[1\]\]\[1\] I have the below config settings Node1(boot strapped node) \[client\] socket=/var/lib/mysql/mysql.sock port … --- ## [Changing IP of nodes in XtraDB cluster](https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549)
**Author:** [@adi](https://forums.percona.com/u/adi)\ **Replies:** 1\ **Last updated:** [September 19, 2022, 5:42pm UTC](https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549 "2022-09-19T17:42:40Z")
Hi All, We need to change the IP/subnet of all nodes (Count - 3) in XtraDB cluster which are accessed through proxySQL, Can someone please suggest what is the best process of changing IPs of complete XtraDB cluster with… --- ## [Crashed Cluste, Nodes not Joinig](https://forums.percona.com/t/crashed-cluste-nodes-not-joinig/17348)
**Author:** [@vbkit](https://forums.percona.com/u/vbkit)\ **Replies:** 9\ **Last updated:** [September 8, 2022, 11:21am UTC](https://forums.percona.com/t/crashed-cluste-nodes-not-joinig/17348 "2022-09-08T11:21:29Z")
Hi there. My monitoring told me this morning, that my whole cluster ist down. I cloud bootstrap one Node, but the second and third node wont join the Cluster anymore. Here’s what my log tells me: 2022-09-07T09:26:17.675… --- ## [How can I downgrade PXC 5.7.39 to 5.7.38](https://forums.percona.com/t/how-can-i-downgrade-pxc-5-7-39-to-5-7-38/17358)
**Author:** [@Aleksandar\_Kostovsk1](https://forums.percona.com/u/Aleksandar_Kostovsk1)\ **Replies:** 4\ **Last updated:** [September 7, 2022, 6:53pm UTC](https://forums.percona.com/t/how-can-i-downgrade-pxc-5-7-39-to-5-7-38/17358 "2022-09-07T18:53:13Z")
I am trying to downgrade my PXC, but I get $ sudo apt policy percona-xtradb-cluster-server-5.7 percona-xtradb-cluster-server-5.7: Installed: 5.7.39-31.61-1.focal Candidate: 5.7.39-31.61-1.focal Version table: \*\*\*… --- ## [Recommended way to apply OS upgrades](https://forums.percona.com/t/recommended-way-to-apply-os-upgrades/17340)
**Author:** [@Edward\_Hibbert](https://forums.percona.com/u/Edward_Hibbert)\ **Replies:** 5\ **Last updated:** [September 7, 2022, 2:23pm UTC](https://forums.percona.com/t/recommended-way-to-apply-os-upgrades/17340 "2022-09-07T14:23:09Z")
I’m using 5.8. I’m having a lot of trouble recycling a cluster in order to apply OS upgrades, and I’m wondering if there is a recommended way. What I try to do: Stop my application accessing a node. Stop any automati… --- ## [After stopping mysql service it is not starting](https://forums.percona.com/t/after-stopping-mysql-service-it-is-not-starting/17346)
**Author:** [@Nanuka](https://forums.percona.com/u/Nanuka)\ **Replies:** 1\ **Last updated:** [September 7, 2022, 11:06am UTC](https://forums.percona.com/t/after-stopping-mysql-service-it-is-not-starting/17346 "2022-09-07T11:06:43Z")
WSREP: Ignorng trx(185516159) due to SST failure WSREP: Waiting for active wsrep applier to exit WSREP: rollbacker thread exiting getting above erros after trying to start mysql service on slave node of pxc --- ## [Anyone running XtraDB Cluster on CentOS Stream? Can I mix & match distros within a cluster?](https://forums.percona.com/t/anyone-running-xtradb-cluster-on-centos-stream-can-i-mix-match-distros-within-a-cluster/17335)
**Author:** [@duncan\_diamondl](https://forums.percona.com/u/duncan_diamondl)\ **Replies:** 1\ **Last updated:** [September 6, 2022, 4:01pm UTC](https://forums.percona.com/t/anyone-running-xtradb-cluster-on-centos-stream-can-i-mix-match-distros-within-a-cluster/17335 "2022-09-06T16:01:27Z")
We have been running an XtraDB cluster with 3 nodes on CentOS 7 for several years with no major issues. We are looking at server upgrades across the board and trying to come up with an upgrade plan for these servers. Is… --- ## [Failing to stop cluster nodes](https://forums.percona.com/t/failing-to-stop-cluster-nodes/17228)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 6\ **Last updated:** [September 5, 2022, 12:41pm UTC](https://forums.percona.com/t/failing-to-stop-cluster-nodes/17228 "2022-09-05T12:41:10Z")
I have three node Percona XtraDB cluster 5.7 ( one node as arbitrator ). I needed to stop the server for some maintenance and it is just not stopping. I have trying all the following commands systemctl stop mysql syste… --- ## [Analysing the cause of a replication related crash](https://forums.percona.com/t/analysing-the-cause-of-a-replication-related-crash/17192)
**Author:** [@Artem\_Baguinski](https://forums.percona.com/u/Artem_Baguinski)\ **Replies:** 4\ **Last updated:** [September 1, 2022, 10:59pm UTC](https://forums.percona.com/t/analysing-the-cause-of-a-replication-related-crash/17192 "2022-09-01T22:59:14Z")
Hello Our 3-node Percona XtraDB 5.7.35 cluster has recently crashed with the following log messages. First on both backup nodes: 2022-08-27T03:02:22.497450Z 1 \[ERROR\] Slave SQL: Could not execute Write\_rows event on … --- ## [Percona XtraDB Cluster 5.7.39-31.61 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-39-31-61-released/17214)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [August 30, 2022, 10:30am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-39-31-61-released/17214 "2022-08-30T10:30:54Z")
August 29, 2022 - Find release notes at Percona XtraDB Cluster 5.7.39-31.61 (2022-08-29) - Percona XtraDB Cluster --- ## [Percona XtraDB Cluster 5.7 nodes have different bin log information](https://forums.percona.com/t/percona-xtradb-cluster-5-7-nodes-have-different-bin-log-information/17166)
**Author:** [@Brian\_Leishman](https://forums.percona.com/u/Brian_Leishman)\ **Replies:** 1\ **Last updated:** [August 25, 2022, 8:21pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-nodes-have-different-bin-log-information/17166 "2022-08-25T20:21:17Z")
I lost a table yesterday due to some user error, but fortunately we have nightly backups using xtrabackup to S3, so I was able to restore as of midnight, yesterday. Also fortunately I have bin logs enabled! And so lies … --- ## [PerconaXtraDB Cluster 5.7.35 - 2 node (multi-master) + arbitrator node](https://forums.percona.com/t/perconaxtradb-cluster-5-7-35-2-node-multi-master-arbitrator-node/17069)
**Author:** [@Ivo](https://forums.percona.com/u/Ivo)\ **Replies:** 2\ **Last updated:** [August 18, 2022, 7:24am UTC](https://forums.percona.com/t/perconaxtradb-cluster-5-7-35-2-node-multi-master-arbitrator-node/17069 "2022-08-18T07:24:24Z")
Hello everyone! Is it necessary to use an arbiter node if 2 nodes in PXC (v.5.7.35) are using multi-master mode, and database entries are made to only one node via floating IP address? In such a case, can there be a s… --- ## [Upgrade percona mysql 5.6 to 5.7](https://forums.percona.com/t/upgrade-percona-mysql-5-6-to-5-7/16943)
**Author:** [@Daljit1](https://forums.percona.com/u/Daljit1)\ **Replies:** 2\ **Last updated:** [August 15, 2022, 12:59pm UTC](https://forums.percona.com/t/upgrade-percona-mysql-5-6-to-5-7/16943 "2022-08-15T12:59:03Z")
Hi Connection, Please someone can share the document for the upgradation from percona mysql 5.6 to 5.7. Below are the details of my database version. mysql --version mysql Ver 14.14 Distrib 5.6.34-79.1, for debian-li… --- ## [One of the xtraDB node is crashing again and again](https://forums.percona.com/t/one-of-the-xtradb-node-is-crashing-again-and-again/16944)
**Author:** [@ROHIT\_KHURANA](https://forums.percona.com/u/ROHIT_KHURANA)\ **Replies:** 2\ **Last updated:** [August 10, 2022, 2:14am UTC](https://forums.percona.com/t/one-of-the-xtradb-node-is-crashing-again-and-again/16944 "2022-08-10T02:14:10Z")
One of the nodes is getting crashed again and again in percona XtraDB cluster 5.7.36 mysqld got signal 11 ; \*This could be because you hit a bug. It is also possible that this binary or one of the libraries it was link… --- ## [One node crashing again and again](https://forums.percona.com/t/one-node-crashing-again-and-again/3651)
**Author:** [@jaigupta](https://forums.percona.com/u/jaigupta)\ **Replies:** 1\ **Last updated:** [August 9, 2022, 2:07am UTC](https://forums.percona.com/t/one-node-crashing-again-and-again/3651 "2022-08-09T02:07:08Z")
One node is crashing repeatedly. Thread pointer: 0x18910ba30 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong… --- ## [Failing with keyring config](https://forums.percona.com/t/failing-with-keyring-config/16562)
**Author:** [@MatzeyDevNinja](https://forums.percona.com/u/MatzeyDevNinja)\ **Replies:** 4\ **Last updated:** [August 5, 2022, 11:37pm UTC](https://forums.percona.com/t/failing-with-keyring-config/16562 "2022-08-05T23:37:50Z")
Hello there, I have some problem with master key from keyring but the thing is that everything was working pretty fine till one of my nodes didn’t fallout from cluster. I have 3 nodes in cluster: pxc1 pxc2 pxc3 (donor)… --- ## [Connecting app servers](https://forums.percona.com/t/connecting-app-servers/16718)
**Author:** [@lord125](https://forums.percona.com/u/lord125)\ **Replies:** 1\ **Last updated:** [July 25, 2022, 2:59pm UTC](https://forums.percona.com/t/connecting-app-servers/16718 "2022-07-25T14:59:05Z")
Question masters! How would I go about connecting an app server to my percona xtradb cluster? --- ## [Wsrep\_desync doesn't works as expected](https://forums.percona.com/t/wsrep-desync-doesnt-works-as-expected/16646)
**Author:** [@Marcos\_Vidal\_Tomas](https://forums.percona.com/u/Marcos_Vidal_Tomas)\ **Replies:** 3\ **Last updated:** [July 20, 2022, 12:49pm UTC](https://forums.percona.com/t/wsrep-desync-doesnt-works-as-expected/16646 "2022-07-20T12:49:18Z")
Hello Recently we are suffering table locks while backup is running. Before the backup is sent we change wsrep\_desync=TRUE, but we think that is not working fine. Other way when backup node is desynced is receiving d… --- ## [Percona XtraDB Cluster 5.7.38-31.59 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-38-31-59-released/16372)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 3:51pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-38-31-59-released/16372 "2022-06-29T15:51:58Z")
June 29, 2022 - Find release notes at Percona XtraDB Cluster 5.7.38-31.59 (2022-06-29) - Percona XtraDB Cluster [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=3) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=5)