# Percona XtraDB Cluster 5.x **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=3 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 4 --- ## [Import mysql dump to PXC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104)
**Author:** [@Harery](https://forums.percona.com/u/Harery)\ **Replies:** 3\ **Last updated:** [May 7, 2018, 3:05am UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104 "2018-05-07T03:05:18Z")
\[root@nd1 ~\]# mysql -u root -p new\_test \< Dump20180101.sql Enter password: ERROR 1105 (HY000) at line 39: Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE WITH READ LOCK with pxc\_strict\_mode = ENFORCING … --- ## [Changing skip\_log\_bin on a v5.7 Percona Cluster](https://forums.percona.com/t/changing-skip-log-bin-on-a-v5-7-percona-cluster/21779)
**Author:** [@jimbo881](https://forums.percona.com/u/jimbo881)\ **Replies:** 1\ **Last updated:** [May 2, 2023, 4:32am UTC](https://forums.percona.com/t/changing-skip-log-bin-on-a-v5-7-percona-cluster/21779 "2023-05-02T04:32:34Z")
I have a vendor supplied Percona 3 node cluster v5.7. They have skip\_log\_bin set so binlogs are not captured. I want to turn binlogs on for all 3 nodes but my team and I do not have a whole lot of experience with Perco… --- ## [Percona XtraDB Cluster 5.7 and Storage Engine 'Memory'](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323)
**Author:** [@soprano](https://forums.percona.com/u/soprano)\ **Replies:** 10\ **Last updated:** [April 13, 2023, 4:09pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323 "2023-04-13T16:09:18Z")
Hi all, i would like to know if Storage Engine MEMORY is working with the percona xtraDB Cluster 5.7 master-master replication. I ask this because i have problems with a joomla installation when it try to execute some … --- ## [MySQL data directory move](https://forums.percona.com/t/mysql-data-directory-move/15460)
**Author:** [@bbalderman28](https://forums.percona.com/u/bbalderman28)\ **Replies:** 10\ **Last updated:** [April 10, 2023, 2:37pm UTC](https://forums.percona.com/t/mysql-data-directory-move/15460 "2023-04-10T14:37:22Z")
We’ve recently built a x3 XtraDB cluster and got all nodes online and syncing. My issue now is I want to move the datadir from the default location to a new raid disk set. I’ve followed the link below for the process whi… --- ## [Simulated a node C crash for MySQL Percona v8.0.27 and failed to rejoin cluster](https://forums.percona.com/t/simulated-a-node-c-crash-for-mysql-percona-v8-0-27-and-failed-to-rejoin-cluster/16715)
**Author:** [@squizzau](https://forums.percona.com/u/squizzau)\ **Replies:** 2\ **Last updated:** [April 10, 2023, 7:53am UTC](https://forums.percona.com/t/simulated-a-node-c-crash-for-mysql-percona-v8-0-27-and-failed-to-rejoin-cluster/16715 "2023-04-10T07:53:42Z")
G’day, I have prepared a new server stack to upgrade our live databases from Percona 5.6 to version 8.0.27-18.1 on new hardware. More version info: Percona XtraDB Cluster (GPL), Release rel18, Revision ac35177, WSREP v… --- ## [Failed to start mysql when adding node2 to my percona xtradb cluster 5.7](https://forums.percona.com/t/failed-to-start-mysql-when-adding-node2-to-my-percona-xtradb-cluster-5-7/21093)
**Author:** [@Aldrin\_John\_Lagrimas](https://forums.percona.com/u/Aldrin_John_Lagrimas)\ **Replies:** 2\ **Last updated:** [April 6, 2023, 5:26pm UTC](https://forums.percona.com/t/failed-to-start-mysql-when-adding-node2-to-my-percona-xtradb-cluster-5-7/21093 "2023-04-06T17:26:15Z")
Here is the error code 2023-03-31T08:37:20.941593Z 0 \[Warning\] WSREP: error while trying to listen ‘tcp://0.0.0.0:4567?socket.non\_blocking=1’, asio error ‘bind: Address already in use’ 2023-03-31T08:37:20.941822Z 0 \[ER… --- ## [Percona XtraDB Cluster 5.7.41-31.65 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-41-31-65-released/21217)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [April 5, 2023, 6:19pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-41-31-65-released/21217 "2023-04-05T18:19:30Z")
April 5, 2023 - Find release notes at Percona XtraDB Cluster 5.7.41-31.65 (2023-04-05) - Percona XtraDB Cluster --- ## [RIght version and Link](https://forums.percona.com/t/right-version-and-link/21097)
**Author:** [@Andre1976](https://forums.percona.com/u/Andre1976)\ **Replies:** 2\ **Last updated:** [April 1, 2023, 11:38am UTC](https://forums.percona.com/t/right-version-and-link/21097 "2023-04-01T11:38:02Z")
Hello Guys I am trying to perform a backup in mysql, however, I have got this error . So , Could you send the right version plus a link to Upgrade my xtrabackup and How can I do it without any impact for my Mysql Produ… --- ## [Error with both old and new nodes joining existing cluster](https://forums.percona.com/t/error-with-both-old-and-new-nodes-joining-existing-cluster/21085)
**Author:** [@Garrett](https://forums.percona.com/u/Garrett)\ **Replies:** 1\ **Last updated:** [March 31, 2023, 4:43pm UTC](https://forums.percona.com/t/error-with-both-old-and-new-nodes-joining-existing-cluster/21085 "2023-03-31T16:43:28Z")
Hello all, I have had an existing cluster of 5 nodes for over a year that has been totally solid. The datacenter had some hardware networking issues a few days ago, and since then only 3 of the nodes have been participa… --- ## [Best practice for percona cluster to connect with the app](https://forums.percona.com/t/best-practice-for-percona-cluster-to-connect-with-the-app/21054)
**Author:** [@RSub](https://forums.percona.com/u/RSub)\ **Replies:** 3\ **Last updated:** [March 31, 2023, 4:26pm UTC](https://forums.percona.com/t/best-practice-for-percona-cluster-to-connect-with-the-app/21054 "2023-03-31T16:26:23Z")
Hello all, I have a percona cluster of 3 and I am also using ProxySQL for monitoring the clusters. My apps are connecting to one of the cluster nodes which was bootstrapped and the data gets written to all the other nod… --- ## [Missing/Errant GTIDs in Multi-Master Galera Cluster](https://forums.percona.com/t/missing-errant-gtids-in-multi-master-galera-cluster/21092)
**Author:** [@ljfreke](https://forums.percona.com/u/ljfreke)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 8:38am UTC](https://forums.percona.com/t/missing-errant-gtids-in-multi-master-galera-cluster/21092 "2023-03-31T08:38:58Z")
Hi all, looking for some advice to the following problem. I have 4 PXC nodes with 3 masters (Galera cluster) and a slave node. I’ve been doing research into why the slave is unable to switch between masters and this is … --- ## [Not able to create PerconaXtraDBClusterRestore resource on kubernetes](https://forums.percona.com/t/not-able-to-create-perconaxtradbclusterrestore-resource-on-kubernetes/20564)
**Author:** [@Sai\_Shashank\_Bandela](https://forums.percona.com/u/Sai_Shashank_Bandela)\ **Replies:** 5\ **Last updated:** [March 30, 2023, 6:56am UTC](https://forums.percona.com/t/not-able-to-create-perconaxtradbclusterrestore-resource-on-kubernetes/20564 "2023-03-30T06:56:45Z")
Hi all, Using the following restore.yaml to create PerconaXtraDBClusterRestore apiVersion: pxc.percona.com/v1 kind: PerconaXtraDBClusterRestore metadata: name: restore namespace: dkube-infra spec: pxcCluster: mys… --- ## [XtraDB Operator version 1.13.0](https://forums.percona.com/t/xtradb-operator-version-1-13-0/21031)
**Author:** [@LTSmash](https://forums.percona.com/u/LTSmash)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 2:54pm UTC](https://forums.percona.com/t/xtradb-operator-version-1-13-0/21031 "2023-03-29T14:54:45Z")
Hey guys We’re using renovate to scan our docker images for available updates. It reports, that there’s an xtradb operator image with tag 1.13.0. That tag apparently exists on docker hub but there’s no documentation o… --- ## [WSREP: Failed to read uuid:seqno from joiner script (Operation not permitted)](https://forums.percona.com/t/wsrep-failed-to-read-uuid-seqno-from-joiner-script-operation-not-permitted/20965)
**Author:** [@Ishank\_Bansal](https://forums.percona.com/u/Ishank_Bansal)\ **Replies:** 1\ **Last updated:** [March 27, 2023, 4:50pm UTC](https://forums.percona.com/t/wsrep-failed-to-read-uuid-seqno-from-joiner-script-operation-not-permitted/20965 "2023-03-27T16:50:30Z")
Hi Guys, I am running MySQL cluster of 3 nodes using percona XtraDB cluster. It is running fine since very long. But now I need to expand the cluster by adding one more node to it. But while adding the node I am getting … --- ## [Node Not Performing IST](https://forums.percona.com/t/node-not-performing-ist/19778)
**Author:** [@daa](https://forums.percona.com/u/daa)\ **Replies:** 4\ **Last updated:** [March 13, 2023, 9:32pm UTC](https://forums.percona.com/t/node-not-performing-ist/19778 "2023-03-13T21:32:27Z")
I am working with a 3-node cluster that is already having SST issues and recently came up with a plan to run the cluster with a combination of IST and running Xtrabackup manually while we find a solution for SST (likely … --- ## [Cluster dies after update with signal 11 error](https://forums.percona.com/t/cluster-dies-after-update-with-signal-11-error/19836)
**Author:** [@nublaii](https://forums.percona.com/u/nublaii)\ **Replies:** 4\ **Last updated:** [March 10, 2023, 1:27am UTC](https://forums.percona.com/t/cluster-dies-after-update-with-signal-11-error/19836 "2023-03-10T01:27:50Z")
We just upgraded a small cluster (2 nodes + 1 garbd) from 5.7.39-31.61-1.focal to 5.7.40-31.63-1.focal. We are running ubuntu 20.04, all OS packages up to date. After the update we’ve had the cluster die on us twice y … --- ## [Why can't I add the primary node to Pxc5.7.40 compiled by myself，Please help me](https://forums.percona.com/t/why-cant-i-add-the-primary-node-to-pxc5-7-40-compiled-by-myself-please-help-me/20483)
**Author:** [@chenhuanhui](https://forums.percona.com/u/chenhuanhui)\ **Replies:** 5\ **Last updated:** [March 9, 2023, 1:47pm UTC](https://forums.percona.com/t/why-cant-i-add-the-primary-node-to-pxc5-7-40-compiled-by-myself-please-help-me/20483 "2023-03-09T13:47:37Z")
I have a machine with ARM architecture，I tried to compile it， Now I have two files：Percona-XtraDB-Cluster-5.7.40-rel43-63.1.Linux.aarch64-minimal.tar.gz Percona-XtraDB-Cluster-5.7.40-rel43-63.1.Linux.aarch64.tar.gz， I … --- ## [2 of 3 nodes crash](https://forums.percona.com/t/2-of-3-nodes-crash/4274)
**Author:** [@sergeym](https://forums.percona.com/u/sergeym)\ **Replies:** 7\ **Last updated:** [March 2, 2023, 6:58am UTC](https://forums.percona.com/t/2-of-3-nodes-crash/4274 "2023-03-02T06:58:05Z")
Hi, we have cluster in LAN, 3 nodes.We run group of test(create DB, create tables, run coherently a lot of transactions, Drop DB).All write/read requests are going to first node. Sometimes, other two nodes simultaneousl… --- ## [How to end a TOI action?](https://forums.percona.com/t/how-to-end-a-toi-action/20179)
**Author:** [@azuryy](https://forums.percona.com/u/azuryy)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 12:52am UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179 "2023-02-23T00:52:48Z")
I hava an action: alter table …, which is too slow and I want to cancel it. Found the Id from show processlist, but I cannot kill it: The query is in TOI/NBO and cannot be killed. so ,how to cancel it forcely? --- ## [Garb open file(./gvwstate.dat.tmp) failed(Permission denied)](https://forums.percona.com/t/garb-open-file-gvwstate-dat-tmp-failed-permission-denied/4226)
**Author:** [@umarzuki](https://forums.percona.com/u/umarzuki)\ **Replies:** 3\ **Last updated:** [February 16, 2023, 12:53am UTC](https://forums.percona.com/t/garb-open-file-gvwstate-dat-tmp-failed-permission-denied/4226 "2023-02-16T00:53:20Z")
when a node restarted its service, belwo warning message will appear 2015-05-19 12:35:28.097 WARN: open file(./gvwstate.dat.tmp) failed(Permission denied) $ ls -l /gvwstate.dat -rw-r--r-- 1 root root 265 Mei 13 06:31 /… --- ## [Error messages are being exposed intermittently](https://forums.percona.com/t/error-messages-are-being-exposed-intermittently/20007)
**Author:** [@views\_eos](https://forums.percona.com/u/views_eos)\ **Replies:** 1\ **Last updated:** [February 13, 2023, 4:43pm UTC](https://forums.percona.com/t/error-messages-are-being-exposed-intermittently/20007 "2023-02-13T16:43:56Z")
Install info Mariadb 10.5.5 wsrep\_provider\_version 26.4.5(rb3764ab) wsrep\_thread\_count 2 Error messages are being exposed intermittently. Error messages WA206 iid=6875765665427374123, Error Pre send fd=3, offset=48… --- ## [IST receiver unable to bind address to public IP](https://forums.percona.com/t/ist-receiver-unable-to-bind-address-to-public-ip/5020)
**Author:** [@Ben\_Chiu](https://forums.percona.com/u/Ben_Chiu)\ **Replies:** 1\ **Last updated:** [February 11, 2023, 3:10am UTC](https://forums.percona.com/t/ist-receiver-unable-to-bind-address-to-public-ip/5020 "2023-02-11T03:10:37Z")
In AWS ec2, applications are only allowed to listen private IP rather than public IP. Public IP is not visible on the host. Anything send to public IP will be forward to corresponding private IP. IST receiver will try to… --- ## [Unable to upgrade from Percona-XtraDB-Cluster 5.6 to 5.7](https://forums.percona.com/t/unable-to-upgrade-from-percona-xtradb-cluster-5-6-to-5-7/19806)
**Author:** [@pravingrane](https://forums.percona.com/u/pravingrane)\ **Replies:** 3\ **Last updated:** [January 29, 2023, 4:43pm UTC](https://forums.percona.com/t/unable-to-upgrade-from-percona-xtradb-cluster-5-6-to-5-7/19806 "2023-01-29T16:43:21Z")
I am having currently running 3 nodes Percona cluster Number of nodes : 3 Operating System: CentOS 6.10 RPMs: Percona-XtraDB-Cluster-galera-3-3.46-1.el6.x86\_64 percona-xtrabackup-2.3.10-1.el6.x86\_64 percona-toolki… --- ## [Scheduled backups are not deleted from Azure Blob](https://forums.percona.com/t/scheduled-backups-are-not-deleted-from-azure-blob/19743)
**Author:** [@Stu](https://forums.percona.com/u/Stu)\ **Replies:** 2\ **Last updated:** [January 25, 2023, 3:46pm UTC](https://forums.percona.com/t/scheduled-backups-are-not-deleted-from-azure-blob/19743 "2023-01-25T15:46:04Z")
Hello, I recently switched my Percona Backups to use Azure Blob Storage. However, now I noticed that all backups that were scheduled by the Operator using the backup.tasks options, will not get deleted from Azure Blob. … --- ## [How to sync XtraDB cluster with other database](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667)
**Author:** [@sa1eh](https://forums.percona.com/u/sa1eh)\ **Replies:** 3\ **Last updated:** [January 18, 2023, 5:34pm UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667 "2023-01-18T17:34:01Z")
Hi I’m looking for a way to create one instance of MYSQL 5.7 and sync the data from my production PXC in this way I can give developers access to this new instance and make sure data will be returned to production stat… --- ## [Transaction is accepted but lost due to cluster timeout](https://forums.percona.com/t/transaction-is-accepted-but-lost-due-to-cluster-timeout/19494)
**Author:** [@fernandomm](https://forums.percona.com/u/fernandomm)\ **Replies:** 1\ **Last updated:** [January 8, 2023, 2:55pm UTC](https://forums.percona.com/t/transaction-is-accepted-but-lost-due-to-cluster-timeout/19494 "2023-01-08T14:55:33Z")
Hi, I’m running a 3 node Percona XtraDB Cluster, version 5.7.35-38-57-log. It’s used for HA, meaning that our application only write/read from a single node and only switches to another node if the first one fails. We… --- ## [Xtradb Cluster 5.7, Can’t Connect Another Nodes](https://forums.percona.com/t/xtradb-cluster-5-7-can-t-connect-another-nodes/19451)
**Author:** [@Dmitriy](https://forums.percona.com/u/Dmitriy)\ **Replies:** 8\ **Last updated:** [January 6, 2023, 4:27am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-can-t-connect-another-nodes/19451 "2023-01-06T04:27:19Z")
Hello! I have following problem with Percona Xtradb Cluster 5.7: Test environment: 4 hosts: ipa01.test.local (CentOS 7) | 10.0.2.22 - DC/DNS per01.test.local (Ubuntu 20.04 LTS) | 10.0.2.30 - that host will be bootstr… --- ## [Xtradb Cluster 5.7, Can't Connect Nodes](https://forums.percona.com/t/xtradb-cluster-5-7-cant-connect-nodes/18998)
**Author:** [@madurange](https://forums.percona.com/u/madurange)\ **Replies:** 5\ **Last updated:** [January 4, 2023, 10:41am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-cant-connect-nodes/18998 "2023-01-04T10:41:04Z")
I Have Installed Percona 5.7 Xtradb Cluster According To The Documentation, But My First Node Starting Successfully, But Other Two Node’s Won’t Start, Those Show Some Errors, ##ERROR## Dec 07 20:07:31 Xtradb3 sudo\[723… --- ## [Percona XtraDB Cluster 5.7.40-31.63 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-40-31-63-released/19390)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [December 29, 2022, 7:51pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-40-31-63-released/19390 "2022-12-29T19:51:00Z")
December 29, 2022 - Find release notes at Percona XtraDB Cluster 5.7.40-31.63 (2022-12-29) - Percona XtraDB Cluster --- ## [PXC Operator v1.10.0 Webhook TLS Issue](https://forums.percona.com/t/pxc-operator-v1-10-0-webhook-tls-issue/19059)
**Author:** [@SridharJ](https://forums.percona.com/u/SridharJ)\ **Replies:** 0\ **Last updated:** [December 10, 2022, 12:00pm UTC](https://forums.percona.com/t/pxc-operator-v1-10-0-webhook-tls-issue/19059 "2022-12-10T12:00:48Z")
PXC Operator logs started throwing TLS verification error consistently when a PXC based CR is deployed. x509: certificate signed by unknown authority (possibly because of \\"crypto/rsa: verification error\\" while trying … [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=2) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=4)