# Percona XtraDB Cluster 5.x **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=1 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 2 --- ## [Master/Master between two clusters](https://forums.percona.com/t/master-master-between-two-clusters/2535)
**Author:** [@ac1dr41n](https://forums.percona.com/u/ac1dr41n)\ **Replies:** 7\ **Last updated:** [July 25, 2024, 10:21am UTC](https://forums.percona.com/t/master-master-between-two-clusters/2535 "2024-07-25T10:21:25Z")
I’m trying to set up a cross-datacenter replication topology. I was looking at Percona for its multi-node capabilities. I’m trying to see if I can set up two independent clusters, one in each data center, and then pick o… --- ## [SST synchronization failed](https://forums.percona.com/t/sst-synchronization-failed/31524)
**Author:** [@Eryk\_Michalik](https://forums.percona.com/u/Eryk_Michalik)\ **Replies:** 2\ **Last updated:** [July 9, 2024, 2:35pm UTC](https://forums.percona.com/t/sst-synchronization-failed/31524 "2024-07-09T14:35:49Z")
In the production environment, one node in the cluster failed. After several attempts to restart it, we couldn’t restore it to operation. Finally, a full synchronization of the node had to be performed. Currently, we ha… --- ## [Force kill "ALTER TABLE" safely?](https://forums.percona.com/t/force-kill-alter-table-safely/12599)
**Author:** [@mwood](https://forums.percona.com/u/mwood)\ **Replies:** 5\ **Last updated:** [July 8, 2024, 6:07am UTC](https://forums.percona.com/t/force-kill-alter-table-safely/12599 "2024-07-08T06:07:47Z")
I tried to add an index to a 192GB InnoDB table. There is 434GB available space on the server. There was very little going on in the database at the time. Several hours later it was still going, so I tried to KILL it. N… --- ## [ERROR! MySQL (Percona XtraDB Cluster) server startup failed](https://forums.percona.com/t/error-mysql-percona-xtradb-cluster-server-startup-failed/7311)
**Author:** [@NPXDBCls](https://forums.percona.com/u/NPXDBCls)\ **Replies:** 4\ **Last updated:** [June 6, 2024, 6:54am UTC](https://forums.percona.com/t/error-mysql-percona-xtradb-cluster-server-startup-failed/7311 "2024-06-06T06:54:01Z")
Hello All, I am new to Percona XtraDB Cluster, so thank you in advance for any help. I have a 3 cluster nodes. the 1st node I started with /etc/init.d/mysql bootstrap-pxc the 2nd node I tried starting with /etc/init.… --- ## [Migrate 2 DC MySQL cluster to 3 DC](https://forums.percona.com/t/migrate-2-dc-mysql-cluster-to-3-dc/29948)
**Author:** [@shirisha](https://forums.percona.com/u/shirisha)\ **Replies:** 10\ **Last updated:** [May 30, 2024, 5:10pm UTC](https://forums.percona.com/t/migrate-2-dc-mysql-cluster-to-3-dc/29948 "2024-05-30T17:10:03Z")
Hello I have two DC MySQL cluster with master-master setup. So I have one master and two slaves in each dc. Currently I want to add third DC so that I have a backup in a scenario such as a DC goes down. MySQL Ver 14.14… --- ## [WSREP: State transfer request failed unrecoverably: 113 (No route to host)](https://forums.percona.com/t/wsrep-state-transfer-request-failed-unrecoverably-113-no-route-to-host/3450)
**Author:** [@shenglin](https://forums.percona.com/u/shenglin)\ **Replies:** 1\ **Last updated:** [May 30, 2024, 1:38pm UTC](https://forums.percona.com/t/wsrep-state-transfer-request-failed-unrecoverably-113-no-route-to-host/3450 "2024-05-30T13:38:07Z")
I am using Percona XtraDB Cluster 5.5.34-25.9. When I set the wsrep\_sst\_donor using CNAME(mymisc2db2.db.stratus.com) instead of hostname, it failed to state transfer with the error 140505 15:13:35 \[ERROR\] WSREP: Request… --- ## [Main purpose for having wsrep sst donor rejects queries option](https://forums.percona.com/t/main-purpose-for-having-wsrep-sst-donor-rejects-queries-option/30610)
**Author:** [@asker](https://forums.percona.com/u/asker)\ **Replies:** 1\ **Last updated:** [May 27, 2024, 3:30pm UTC](https://forums.percona.com/t/main-purpose-for-having-wsrep-sst-donor-rejects-queries-option/30610 "2024-05-27T15:30:28Z")
What is the main purpose for having wsrep\_sst\_donor\_rejects\_queries option? When we switch this option to ON (and disable any lock options), our sst through xtrabackup crashes on query “FLUSH BINARY LOGS” So, as i corr… --- ## [Migration from PS5.7.31 to PXC5.7.44 issues warnings regarding replicating pending GTID event](https://forums.percona.com/t/migration-from-ps5-7-31-to-pxc5-7-44-issues-warnings-regarding-replicating-pending-gtid-event/30022)
**Author:** [@MartinM](https://forums.percona.com/u/MartinM)\ **Replies:** 15\ **Last updated:** [May 23, 2024, 4:00pm UTC](https://forums.percona.com/t/migration-from-ps5-7-31-to-pxc5-7-44-issues-warnings-regarding-replicating-pending-gtid-event/30022 "2024-05-23T16:00:32Z")
Hello! We are in progress of upgrading from PS5.7.31 async replication to 3-node PXC5.7.44 with this replication chain: PS-M – MIXED → PS-S – ROW → PXC-1 (WSREP to PXC-2 and PXC-3) The PS-S writes binlog for all DBs, … --- ## [Calculating gcache.size value](https://forums.percona.com/t/calculating-gcache-size-value/30201)
**Author:** [@brucehvn](https://forums.percona.com/u/brucehvn)\ **Replies:** 2\ **Last updated:** [May 13, 2024, 1:20pm UTC](https://forums.percona.com/t/calculating-gcache-size-value/30201 "2024-05-13T13:20:18Z")
Is there some formula for determining how large I should set the gcache.size value to? I have a db that looks like it is too large for the default 128M, so IST transfers won’t happen. The total size of the .ibd files i… --- ## [Upgrading PXC 5.6-\>5.7 SST Transfer always resets performance\_schema db](https://forums.percona.com/t/upgrading-pxc-5-6-5-7-sst-transfer-always-resets-performance-schema-db/30193)
**Author:** [@brucehvn](https://forums.percona.com/u/brucehvn)\ **Replies:** 2\ **Last updated:** [May 10, 2024, 12:31am UTC](https://forums.percona.com/t/upgrading-pxc-5-6-5-7-sst-transfer-always-resets-performance-schema-db/30193 "2024-05-10T00:31:42Z")
We are in the process of upgrading all our clusters from PXC 5.6 to 5.7 and it has gone well, except we’ve hit a case where one instance is very high volume and we can’t seem to get it to sync properly. Here’s the scena… --- ## [I am not able to connect to mysql using proxySQL](https://forums.percona.com/t/i-am-not-able-to-connect-to-mysql-using-proxysql/29742)
**Author:** [@erpramodprajapat](https://forums.percona.com/u/erpramodprajapat)\ **Replies:** 2\ **Last updated:** [April 23, 2024, 4:48am UTC](https://forums.percona.com/t/i-am-not-able-to-connect-to-mysql-using-proxysql/29742 "2024-04-23T04:48:05Z")
I have AWS application pods , I have deployed ProxySQL pods in AWS Kubernetes, I am able to connect to MySQL from inside the proxySQL pods like mysql -uuser -ppassw0rd -h 127.0.0.1 -P 6033 but I am not able to connect… --- ## [Restoring Incrementals, with full backup stored on remote location](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556)
**Author:** [@AK\_Work](https://forums.percona.com/u/AK_Work)\ **Replies:** 4\ **Last updated:** [April 7, 2024, 5:41pm UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556 "2024-04-07T17:41:53Z")
Hello All, My use case is as follows, I need to store the backups taken to a remote location for which I stream the output of the backup to another host storage location using the xbstream binary. Now when I need to tak… --- ## [State transfer falling back to SST](https://forums.percona.com/t/state-transfer-falling-back-to-sst/29575)
**Author:** [@donkeykong](https://forums.percona.com/u/donkeykong)\ **Replies:** 2\ **Last updated:** [April 7, 2024, 7:14am UTC](https://forums.percona.com/t/state-transfer-falling-back-to-sst/29575 "2024-04-07T07:14:35Z")
I am busy testing an upgrade of a cluster from 5.7 to 8.0. After cloning the 3x DB nodes and bootstrapping the first node (I selected galera-db2, as it had the highest seqno), I try to join one of the other nodes, but g… --- ## [How do I convert a single file from .idb to .sql?](https://forums.percona.com/t/how-do-i-convert-a-single-file-from-idb-to-sql/29374)
**Author:** [@neverm2](https://forums.percona.com/u/neverm2)\ **Replies:** 32\ **Last updated:** [March 30, 2024, 1:14am UTC](https://forums.percona.com/t/how-do-i-convert-a-single-file-from-idb-to-sql/29374 "2024-03-30T01:14:05Z")
I need the database of my own site, (I backed it up with xtrabackup,) which I ended the service last year, the data is 2gb in size, but it has an .idb extension, I have not been able to convert it to .sql for about 6 hou… --- ## [Percona XtraDB Node not able to start up - k8s](https://forums.percona.com/t/percona-xtradb-node-not-able-to-start-up-k8s/28928)
**Author:** [@batman](https://forums.percona.com/u/batman)\ **Replies:** 1\ **Last updated:** [March 18, 2024, 10:28am UTC](https://forums.percona.com/t/percona-xtradb-node-not-able-to-start-up-k8s/28928 "2024-03-18T10:28:22Z")
Hi, We are using the Percona Operator on a self managed Kubernetes Cluster to deploy XtraDB. The cluster consists of 3 nodes (pods) and was running just fine until it run into a memory limitation and the one pod got OOM… --- ## [Percona cluster upgrades from 5.7.39 to 5.7.44 problems](https://forums.percona.com/t/percona-cluster-upgrades-from-5-7-39-to-5-7-44-problems/29042)
**Author:** [@sgales](https://forums.percona.com/u/sgales)\ **Replies:** 1\ **Last updated:** [March 9, 2024, 12:08am UTC](https://forums.percona.com/t/percona-cluster-upgrades-from-5-7-39-to-5-7-44-problems/29042 "2024-03-09T00:08:48Z")
Hello, We’ve been trying to get to the latest release of percona cluster 5.7 - until we are able to spend time upgrading from 5.7 =\> 8.0. We built the new image and deployed and we ran into an interesting issue where i… --- ## [Percona XtraDB Cluster crashes after updating to version 8.0.35-27.1](https://forums.percona.com/t/percona-xtradb-cluster-crashes-after-updating-to-version-8-0-35-27-1/28458)
**Author:** [@ofrias](https://forums.percona.com/u/ofrias)\ **Replies:** 5\ **Last updated:** [March 1, 2024, 10:19am UTC](https://forums.percona.com/t/percona-xtradb-cluster-crashes-after-updating-to-version-8-0-35-27-1/28458 "2024-03-01T10:19:35Z")
Hello. We have a Percona XtraDB Cluster with 2 nodes and an arbitrator that has been running successfully for years. Starting a few weeks ago, and apparently coinciding with the update to version 8.0.35-27.1 (from vers… --- ## [PXC cluster CrashLoopBackOff](https://forums.percona.com/t/pxc-cluster-crashloopbackoff/13151)
**Author:** [@Antoine](https://forums.percona.com/u/Antoine)\ **Replies:** 6\ **Last updated:** [February 27, 2024, 4:54am UTC](https://forums.percona.com/t/pxc-cluster-crashloopbackoff/13151 "2024-02-27T04:54:35Z")
Hi! My PXC 5.7 cluster is crash looping with the following error: 2021-11-22T08:57:27.796235Z 0 \[Note\] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.34-37 started; log sequence number 2264189188 2021-11-22T08:57:2… --- ## [Percona XtraDB Cluster backup retention not working as expected](https://forums.percona.com/t/percona-xtradb-cluster-backup-retention-not-working-as-expected/28185)
**Author:** [@santosh240](https://forums.percona.com/u/santosh240)\ **Replies:** 1\ **Last updated:** [February 20, 2024, 12:40am UTC](https://forums.percona.com/t/percona-xtradb-cluster-backup-retention-not-working-as-expected/28185 "2024-02-20T00:40:12Z")
Hi Team, We have installed the MySQL cluster using the Percona-xtradb-cluster-operator in redhat Openshift cluster. I have configured to backup the database to S3 storage and backup is working fine but retention I kept … --- ## [Error when I try to activate valiables in xtradb percona](https://forums.percona.com/t/error-when-i-try-to-activate-valiables-in-xtradb-percona/28466)
**Author:** [@ahung](https://forums.percona.com/u/ahung)\ **Replies:** 1\ **Last updated:** [February 14, 2024, 4:21pm UTC](https://forums.percona.com/t/error-when-i-try-to-activate-valiables-in-xtradb-percona/28466 "2024-02-14T16:21:10Z")
error when I try to activate valiables in xtradb percona Greetings team, I am trying to activate variables in my xtradb cluster and it returns an error and the services do not start, these are the variables have\_query\_… --- ## [Can't reconnect to cluster after reboot](https://forums.percona.com/t/cant-reconnect-to-cluster-after-reboot/28141)
**Author:** [@Ken\_Scott](https://forums.percona.com/u/Ken_Scott)\ **Replies:** 15\ **Last updated:** [February 5, 2024, 4:27pm UTC](https://forums.percona.com/t/cant-reconnect-to-cluster-after-reboot/28141 "2024-02-05T16:27:41Z")
This is now happening on 2 of my 5 nodes. We updating a mailer program on reboot the node can’t join back to the cluster. The only way i know this solve this is to blow away the machine and start from scratch. Joiner no… --- ## [Can't set up 1 node pxc on kubernetes cluster](https://forums.percona.com/t/cant-set-up-1-node-pxc-on-kubernetes-cluster/28160)
**Author:** [@Tu\_n\_Nguy\_n\_Thuc](https://forums.percona.com/u/Tu_n_Nguy_n_Thuc)\ **Replies:** 2\ **Last updated:** [February 1, 2024, 6:16am UTC](https://forums.percona.com/t/cant-set-up-1-node-pxc-on-kubernetes-cluster/28160 "2024-02-01T06:16:28Z")
I’m a newbie of percona xtradb cluster. When i set up the size of pxc to 1 to deploy mysql server to kubernetes cluster the result is 3 pxc node. This is my code: apiVersion: pxc.percona.com/v1 kind: PerconaXtraDBClust… --- ## [not able to desync and flush tables with read lock](https://forums.percona.com/t/not-able-to-desync-and-flush-tables-with-read-lock/5469)
**Author:** [@akang](https://forums.percona.com/u/akang)\ **Replies:** 1\ **Last updated:** [March 22, 2017, 8:15am UTC](https://forums.percona.com/t/not-able-to-desync-and-flush-tables-with-read-lock/5469 "2017-03-22T08:15:21Z")
Hi, I have a cluster of 3 nodes and when i try to desync and flush tables with read lock in order to get a backup of the node for a slave, I get a few errors. When I run the following commands in the command line on on… --- ## [Percona XtraDB Cluster 5.7.44-31.65 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-44-31-65-released/27420)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [December 26, 2023, 4:28pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-44-31-65-released/27420 "2023-12-26T16:28:44Z")
December 26, 2023 - Find release notes at Percona XtraDB Cluster 5.7.44-31.65 (2023-12-26) - Percona XtraDB Cluster --- ## [Cluster failure](https://forums.percona.com/t/cluster-failure/27312)
**Author:** [@egel](https://forums.percona.com/u/egel)\ **Replies:** 2\ **Last updated:** [December 23, 2023, 7:26pm UTC](https://forums.percona.com/t/cluster-failure/27312 "2023-12-23T19:26:01Z")
Hello, I experienced a strange outage on my cluster and am trying to understand how it might have happened. All nodes but one failed with: 2023-12-16T13:32:19.215529Z 69 \[ERROR\] Slave SQL: Could not execute Delete\_row… --- ## [How can I encrypt the passwords](https://forums.percona.com/t/how-can-i-encrypt-the-passwords/27296)
**Author:** [@adgwytc](https://forums.percona.com/u/adgwytc)\ **Replies:** 2\ **Last updated:** [December 22, 2023, 4:52pm UTC](https://forums.percona.com/t/how-can-i-encrypt-the-passwords/27296 "2023-12-22T16:52:45Z")
Hi, I have built a percona xtradb cluster along with freeradius and radman GUI frontend for freeradius. Everything functions exactly as it should but I am missing one part: The passwords in the DB are all being shown a… --- ## [After power loss mysql can't start, bootstrap works](https://forums.percona.com/t/after-power-loss-mysql-cant-start-bootstrap-works/27247)
**Author:** [@JollyJumper](https://forums.percona.com/u/JollyJumper)\ **Replies:** 10\ **Last updated:** [December 20, 2023, 4:15pm UTC](https://forums.percona.com/t/after-power-loss-mysql-cant-start-bootstrap-works/27247 "2023-12-20T16:15:22Z")
hello, I have a problem with my mysql cluster after losing power. I did as per instructions (3 servers failed): I checked the grastat.dat file on each of them with the command: mysqld\_safe --wsrep-recover then, on t… --- ## [Percona XtraDB node crashing randomly without logs](https://forums.percona.com/t/percona-xtradb-node-crashing-randomly-without-logs/26470)
**Author:** [@doctober](https://forums.percona.com/u/doctober)\ **Replies:** 7\ **Last updated:** [November 20, 2023, 9:44am UTC](https://forums.percona.com/t/percona-xtradb-node-crashing-randomly-without-logs/26470 "2023-11-20T09:44:48Z")
Hi, I’m having problems with a percona xtradb cluster 5.7.43 The nodes are all running as primary but just one of them is being used to write data at a time. The Crashes have occurred after upgrading from 5.6.x to 5.7… --- ## [XtraDB cross site replication not working](https://forums.percona.com/t/xtradb-cross-site-replication-not-working/26505)
**Author:** [@batman](https://forums.percona.com/u/batman)\ **Replies:** 2\ **Last updated:** [November 13, 2023, 1:32pm UTC](https://forums.percona.com/t/xtradb-cross-site-replication-not-working/26505 "2023-11-13T13:32:54Z")
Hi, I’ve recently started exploring XtraDB to replace a MySQL RDS instance. I’ve deployed the Percona Operator to my Kubernetes cluster and deployed an pxc cluster. The next requirement is to configure cross site replic… --- ## [Cannot get MySQL var character\_set\_server](https://forums.percona.com/t/cannot-get-mysql-var-character-set-server/25741)
**Author:** [@marcio](https://forums.percona.com/u/marcio)\ **Replies:** 3\ **Last updated:** [October 30, 2023, 2:24pm UTC](https://forums.percona.com/t/cannot-get-mysql-var-character-set-server/25741 "2023-10-30T14:24:25Z")
Hello!! After I updated the server packages to percona-toolkit-3.5.5-1.el8.x86\_64 I am not start the pt-kill daemon. I am getting this error: Cannot get MySQL var character\_set\_server: DBD::mysql::db selectrow\_array f… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=2)