# Percona XtraDB Cluster 5.x **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=5 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 6 --- ## [Problem when node goes down](https://forums.percona.com/t/problem-when-node-goes-down/16312)
**Author:** [@hieu\_nguyen](https://forums.percona.com/u/hieu_nguyen)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 4:35pm UTC](https://forums.percona.com/t/problem-when-node-goes-down/16312 "2022-06-28T16:35:44Z")
i was running 3 nodes , i shut down my node 1 , and when i restarted node 1 was down i shut down node2 and node 3 then turn on boostrap with node 3 , start again with node2 , but when starting node 1 again an error occur… --- ## [Gcache.page.\* files constantly generated on the PXC 5.6.51](https://forums.percona.com/t/gcache-page-files-constantly-generated-on-the-pxc-5-6-51/16221)
**Author:** [@msutic](https://forums.percona.com/u/msutic)\ **Replies:** 4\ **Last updated:** [June 24, 2022, 6:41am UTC](https://forums.percona.com/t/gcache-page-files-constantly-generated-on-the-pxc-5-6-51/16221 "2022-06-24T06:41:06Z")
Hello, We have a 3-node Percona XTraDB Galera Cluster configuration: 5.6.51-91.0-56-log wsrep\_provider\_version=3.46(r0ef0d79) gcache.size = 1G Files “gcache.page.\*” are generated almost every minute and not cleaned … --- ## [Size of tmp\_table\_size & max\_heap\_table\_size stuck on 32M](https://forums.percona.com/t/size-of-tmp-table-size-max-heap-table-size-stuck-on-32m/3311)
**Author:** [@jaigupta](https://forums.percona.com/u/jaigupta)\ **Replies:** 4\ **Last updated:** [June 22, 2022, 1:44pm UTC](https://forums.percona.com/t/size-of-tmp-table-size-max-heap-table-size-stuck-on-32m/3311 "2022-06-22T13:44:47Z")
Size of tmp\_table\_size & max\_heap\_table\_size stuck on 32M max\_heap\_table\_size=128M; tmp\_table\_size=128M; mysql\> SELECT @@max\_heap\_table\_size; +-----------------------+ | @@max\_heap\_table\_size | +-------… --- ## [New Cluster with data](https://forums.percona.com/t/new-cluster-with-data/12949)
**Author:** [@danarashad](https://forums.percona.com/u/danarashad)\ **Replies:** 26\ **Last updated:** [June 17, 2022, 11:25am UTC](https://forums.percona.com/t/new-cluster-with-data/12949 "2022-06-17T11:25:16Z")
I am starting a new cluster after upgrading OS. The server has the data in the datadir can I start the cluster or will there be some sort of conflict? --- ## [PXC 5.7.36 missing from release notes list?](https://forums.percona.com/t/pxc-5-7-36-missing-from-release-notes-list/15892)
**Author:** [@NeilBillett](https://forums.percona.com/u/NeilBillett)\ **Replies:** 1\ **Last updated:** [June 9, 2022, 1:20pm UTC](https://forums.percona.com/t/pxc-5-7-36-missing-from-release-notes-list/15892 "2022-06-09T13:20:08Z")
Hi folks, Is there any reason why PXC 5.7.36 is missing from the Release Notes list page here: Percona XtraDB Cluster 5.7 Release notes - Percona XtraDB Cluster Percona XtraDB Cluster 5.7 Release notes ----------------… --- ## [New setup percona xtradb cluster](https://forums.percona.com/t/new-setup-percona-xtradb-cluster/15864)
**Author:** [@myzig\_lucas](https://forums.percona.com/u/myzig_lucas)\ **Replies:** 2\ **Last updated:** [May 28, 2022, 11:03am UTC](https://forums.percona.com/t/new-setup-percona-xtradb-cluster/15864 "2022-05-28T11:03:53Z")
i’m a percona newbie. i have 3 nodes wsrep\_cluster\_address=gcomm://abc.112.0.1,abc.112.0.2,abc.112.0.3 Does my my.cnf fie have to fill in all these 3 ips, or is this okay? node 1: wsrep\_cluster\_address=gcomm:// node … --- ## [Cannot use MySQL my.cnf centos7](https://forums.percona.com/t/cannot-use-mysql-my-cnf-centos7/15828)
**Author:** [@hieu\_nguyen](https://forums.percona.com/u/hieu_nguyen)\ **Replies:** 13\ **Last updated:** [May 27, 2022, 4:19pm UTC](https://forums.percona.com/t/cannot-use-mysql-my-cnf-centos7/15828 "2022-05-27T16:19:42Z")
I have 2 nodes to join percona xtaDB cluster 5.7 . I installed them successfully , node 1 was able to start working . when I switched to node 2 configuration, I fixed the file my.cnf cat \>\>/etc/my.cnf\<\ **Author:** [@NeilBillett](https://forums.percona.com/u/NeilBillett)\ **Replies:** 3\ **Last updated:** [May 25, 2022, 12:40pm UTC](https://forums.percona.com/t/trying-to-understand-why-pxc-node-was-running-out-of-memory/15817 "2022-05-25T12:40:22Z") Hi Folks, This may end up being a more general MySQL memory management question but we recently had problems with a client who’s 3 node percona 5.7.35 cluster was regularly running out of memory and, although we seemed … --- ## [Percona XtraDB Cluster 5.7.37-31.57 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-37-31-57-released/15734)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [May 18, 2022, 1:24pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-37-31-57-released/15734 "2022-05-18T13:24:04Z")
May 18, 2022 - Find release notes at Percona XtraDB Cluster 5.7.37-31.57 (2022-05-18) --- ## [Evaluating Transaction load before upgrading to XtraDB cluster](https://forums.percona.com/t/evaluating-transaction-load-before-upgrading-to-xtradb-cluster/15689)
**Author:** [@gregl](https://forums.percona.com/u/gregl)\ **Replies:** 1\ **Last updated:** [May 16, 2022, 5:41am UTC](https://forums.percona.com/t/evaluating-transaction-load-before-upgrading-to-xtradb-cluster/15689 "2022-05-16T05:41:59Z")
We want to go to XtraDB cluster. Ver 5.7 Is there a white paper or assistance on determining if our Mysql Usage and transactions are compatible with XtraDB cluster? There is mention of long running transactions, how long… --- ## [Recreate Percona Cluster when Disk is Full](https://forums.percona.com/t/recreate-percona-cluster-when-disk-is-full/15561)
**Author:** [@lkrzyczkowski](https://forums.percona.com/u/lkrzyczkowski)\ **Replies:** 1\ **Last updated:** [May 6, 2022, 2:41pm UTC](https://forums.percona.com/t/recreate-percona-cluster-when-disk-is-full/15561 "2022-05-06T14:41:34Z")
Hello I want to ask how to restore DB Cluster Percona when disk space is full in 100% to dont loose any transaction? Thx --- ## [Mysqld 5.6 crashes after joining galera cluster with successful SST](https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575)
**Author:** [@Adam\_Lasut](https://forums.percona.com/u/Adam_Lasut)\ **Replies:** 1\ **Last updated:** [May 6, 2022, 2:39pm UTC](https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575 "2022-05-06T14:39:31Z")
Hello, after os update my mysqld crashes after it successfuly receives state from another node of percona xtradb cluster and joins the cluster. Versions (they are identical on all nodes of the cluster) mysql -V mysql … --- ## [Getting latency in write operations under heavy load](https://forums.percona.com/t/getting-latency-in-write-operations-under-heavy-load/15345)
**Author:** [@dipesh.patel](https://forums.percona.com/u/dipesh.patel)\ **Replies:** 19\ **Last updated:** [April 27, 2022, 3:25pm UTC](https://forums.percona.com/t/getting-latency-in-write-operations-under-heavy-load/15345 "2022-04-27T15:25:50Z")
Hi, I am using Percona Xtradb Cluster 5.7. We have 3 node server on GCP with 70cores & 560 GB RAM on each node. What we see is during heavy load on server, we see Insert/update queries taking more time, some time it go… --- ## [Insert update slow sometimes](https://forums.percona.com/t/insert-update-slow-sometimes/15158)
**Author:** [@dylan](https://forums.percona.com/u/dylan)\ **Replies:** 11\ **Last updated:** [April 25, 2022, 5:27pm UTC](https://forums.percona.com/t/insert-update-slow-sometimes/15158 "2022-04-25T17:27:04Z")
Server version: 5.7.33-36-57 Percona XtraDB Cluster (GPL), Release rel36, Revision a1ed9c3, WSREP version 31.49, wsrep\_31.49 My cluster is 3 nodes. Sometimes inserts or updates are very slow, exactly 30 seconds. I’m no… --- ## [Mysql\_upgrade for active 3 node cluster](https://forums.percona.com/t/mysql-upgrade-for-active-3-node-cluster/14970)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 2\ **Last updated:** [March 29, 2022, 6:32pm UTC](https://forums.percona.com/t/mysql-upgrade-for-active-3-node-cluster/14970 "2022-03-29T18:32:32Z")
Hello, I have 3 node cluster ( 2 data node and one arbitrator ). The percona cluster version is Percona-XtraDB-Cluster-57-5.7.36-31.55.1 on these nodes. I am getting warnings in my error logs which means that I need to … --- ## [Xtrabackup backup to a different server](https://forums.percona.com/t/xtrabackup-backup-to-a-different-server/14841)
**Author:** [@Ravi\_Teja\_RVN](https://forums.percona.com/u/Ravi_Teja_RVN)\ **Replies:** 4\ **Last updated:** [March 28, 2022, 1:37pm UTC](https://forums.percona.com/t/xtrabackup-backup-to-a-different-server/14841 "2022-03-28T13:37:51Z")
HI Team, I have a server running with mysql with huge db of 1 TB. Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup. Now,if I initiate taking backu… --- ## [Single node PXC Fails to recover due to ibdata1 on NFS Storage](https://forums.percona.com/t/single-node-pxc-fails-to-recover-due-to-ibdata1-on-nfs-storage/14846)
**Author:** [@WatermelonPXC](https://forums.percona.com/u/WatermelonPXC)\ **Replies:** 2\ **Last updated:** [March 22, 2022, 6:05pm UTC](https://forums.percona.com/t/single-node-pxc-fails-to-recover-due-to-ibdata1-on-nfs-storage/14846 "2022-03-22T18:05:03Z")
Hi All, Looking for some insight here. I’m having issues with Percona recovering from power failures on a VSphere VM. We are running PXC with MySQL Innodb configured. Deploying using Helm into a K8s cluster. Whats happe… --- ## [2 Percona XtraDB Cluster 5.7 in different datacenters](https://forums.percona.com/t/2-percona-xtradb-cluster-5-7-in-different-datacenters/14654)
**Author:** [@jbiancot](https://forums.percona.com/u/jbiancot)\ **Replies:** 4\ **Last updated:** [March 10, 2022, 1:45am UTC](https://forums.percona.com/t/2-percona-xtradb-cluster-5-7-in-different-datacenters/14654 "2022-03-10T01:45:54Z")
Hello there, We have 2 data centers: our Prod data center and the QA data canter. I will refer as “dc” for data center. On our Prod dc, we have 4 nodes of v5.7 Percona XtraDB cluster. We use the Percona ProxySQL to tal… --- ## [Running pt-online-schema-change increases the size of the file on disk](https://forums.percona.com/t/running-pt-online-schema-change-increases-the-size-of-the-file-on-disk/12939)
**Author:** [@ravimalghan](https://forums.percona.com/u/ravimalghan)\ **Replies:** 3\ **Last updated:** [February 25, 2022, 4:33pm UTC](https://forums.percona.com/t/running-pt-online-schema-change-increases-the-size-of-the-file-on-disk/12939 "2022-02-25T16:33:06Z")
I have been using pt-online-schema-change to reduce the file size on disk for a table that has lot of deletes. It has worked as expected for a long time. I have not updated anything. For my last 4 runs, the file size see… --- ## [Percona XtraDB Cluster 5.7.36-31.55 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-36-31-55-released/14502)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [February 21, 2022, 10:59am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-36-31-55-released/14502 "2022-02-21T10:59:08Z")
February 16, 2022 - Find release notes at Percona XtraDB Cluster 5.7.36-31.55 --- ## [Adding and using table partitions in XtraDB Cluster (5.6 and 8)](https://forums.percona.com/t/adding-and-using-table-partitions-in-xtradb-cluster-5-6-and-8/14456)
**Author:** [@sbr](https://forums.percona.com/u/sbr)\ **Replies:** 0\ **Last updated:** [February 17, 2022, 7:12am UTC](https://forums.percona.com/t/adding-and-using-table-partitions-in-xtradb-cluster-5-6-and-8/14456 "2022-02-17T07:12:42Z")
I have just some basic questions regarding table partitioning and XtraDB Cluster: We want to do a table partitioning on some tables in our 3 node XtraDB Clusters (some are still on 5.6 most are already 8.0) We are usei… --- ## [Could not able to add new query\_rules and all traffic went to single writer](https://forums.percona.com/t/could-not-able-to-add-new-query-rules-and-all-traffic-went-to-single-writer/14198)
**Author:** [@ajay](https://forums.percona.com/u/ajay)\ **Replies:** 17\ **Last updated:** [February 11, 2022, 3:49pm UTC](https://forums.percona.com/t/could-not-able-to-add-new-query-rules-and-all-traffic-went-to-single-writer/14198 "2022-02-11T15:49:50Z")
Hi @Slava\_Sarzhan and team, Greetings, I had successfully deployed the pxc-operator and pxc-db with proxysql using helm in k8s. And did do the sysbench test using oltp\_read\_write.lua script observed that all the reads & … --- ## [Replication Problem where Cluster locks up completely](https://forums.percona.com/t/replication-problem-where-cluster-locks-up-completely/13513)
**Author:** [@Atlas](https://forums.percona.com/u/Atlas)\ **Replies:** 12\ **Last updated:** [February 7, 2022, 10:56am UTC](https://forums.percona.com/t/replication-problem-where-cluster-locks-up-completely/13513 "2022-02-07T10:56:21Z")
Hello, we have kind of a weird problem. But first, let me describe our setup. We have a cluster of 3 percona mysql nodes which sit behind 2 ProxySQL Servers. The MySQL Cluster is used by many Webservers. This normally d… --- ## [PXC 5.7.32-35 node crashing (signal 11) during nightly delete operation](https://forums.percona.com/t/pxc-5-7-32-35-node-crashing-signal-11-during-nightly-delete-operation/13828)
**Author:** [@NeilBillett](https://forums.percona.com/u/NeilBillett)\ **Replies:** 2\ **Last updated:** [January 7, 2022, 5:17pm UTC](https://forums.percona.com/t/pxc-5-7-32-35-node-crashing-signal-11-during-nightly-delete-operation/13828 "2022-01-07T17:17:05Z")
Hi Folks, Has anyone seen this crash (see below) before in PXC 5.7.32? Its happening periodically when a nightly scheduled job in a busy 3 node system starts deleting some old records from various tables (some of which … --- ## [Percona xtradb cluster v5.7.35-31.53.1 on ubuntu 20.04 configuration problems](https://forums.percona.com/t/percona-xtradb-cluster-v5-7-35-31-53-1-on-ubuntu-20-04-configuration-problems/13454)
**Author:** [@soprano](https://forums.percona.com/u/soprano)\ **Replies:** 18\ **Last updated:** [January 4, 2022, 8:55am UTC](https://forums.percona.com/t/percona-xtradb-cluster-v5-7-35-31-53-1-on-ubuntu-20-04-configuration-problems/13454 "2022-01-04T08:55:52Z")
i’m trying to install a xtradb cluster v5.7.35-31.53.1 on 20.04 but i have problems while it is configuring, so 2 packages are keeping not fully installed root@XXXXXX:~# apt update Hit:1 http://it.archive.ubuntu.com/ubu… --- ## [Point application to a dDatabase Cluster](https://forums.percona.com/t/point-application-to-a-ddatabase-cluster/13726)
**Author:** [@Alex\_Karuna](https://forums.percona.com/u/Alex_Karuna)\ **Replies:** 1\ **Last updated:** [January 3, 2022, 8:24am UTC](https://forums.percona.com/t/point-application-to-a-ddatabase-cluster/13726 "2022-01-03T08:24:54Z")
Hello Team, I’m new here. I have set up a 3-Node XtraDB cluster in AWS Ec2 using the documentation provided by Percona. Everything is working great. I need to point my application to a database. What is the easiest way… --- ## [What Happens on the Read/Write Node When a Query Locks Tables on the Read-Only Node?](https://forums.percona.com/t/what-happens-on-the-read-write-node-when-a-query-locks-tables-on-the-read-only-node/13358)
**Author:** [@geek\_prophet](https://forums.percona.com/u/geek_prophet)\ **Replies:** 20\ **Last updated:** [December 28, 2021, 8:22pm UTC](https://forums.percona.com/t/what-happens-on-the-read-write-node-when-a-query-locks-tables-on-the-read-only-node/13358 "2021-12-28T20:22:51Z")
Greetings, We are considering switching to XtraDB Cluster as our new MySQL HA solution. We would deploy clusters consisting of 1 read-write node (select/insert/update/delete), one read node (select only), and 1 abbrevia… --- ## [Problem joining the secondary(slave) server to the cluster (Percona XtraDB Cluster 5.7.35-38-57 - CentOS7)](https://forums.percona.com/t/problem-joining-the-secondary-slave-server-to-the-cluster-percona-xtradb-cluster-5-7-35-38-57-centos7/13586)
**Author:** [@Ivo](https://forums.percona.com/u/Ivo)\ **Replies:** 3\ **Last updated:** [December 21, 2021, 6:05pm UTC](https://forums.percona.com/t/problem-joining-the-secondary-slave-server-to-the-cluster-percona-xtradb-cluster-5-7-35-38-57-centos7/13586 "2021-12-21T18:05:34Z")
Hello everyone! I have Percona XtraDB Cluster 5.7.35-35-57 installed on 3 identical VPS on CentOS 7. After shutting down all 3 servers in the cluster, I restored the database to the primary (master) server that was bac… --- ## [SST XtraDB Backup - Use a different tmp directory](https://forums.percona.com/t/sst-xtradb-backup-use-a-different-tmp-directory/5453)
**Author:** [@weishan](https://forums.percona.com/u/weishan)\ **Replies:** 5\ **Last updated:** [December 15, 2021, 3:26pm UTC](https://forums.percona.com/t/sst-xtradb-backup-use-a-different-tmp-directory/5453 "2021-12-15T15:26:41Z")
Hi all, Our current tmp directory is only 5GB and it’s not able to perform SST backup as the tmp directory gets filled up really quickly. Setting tmpdir under \[mysqld\] or \[xtrabackup\] doesn’t work for me. I have also c… --- ## [Stalled on STT even when other nodes are down](https://forums.percona.com/t/stalled-on-stt-even-when-other-nodes-are-down/13464)
**Author:** [@Rafael\_Blazquez](https://forums.percona.com/u/Rafael_Blazquez)\ **Replies:** 2\ **Last updated:** [December 14, 2021, 2:37pm UTC](https://forums.percona.com/t/stalled-on-stt-even-when-other-nodes-are-down/13464 "2021-12-14T14:37:10Z")
Greetings, We have a two-node cluster and need to do a dirty restart. On rejoining the cluster we had a network glitch and now the primary (and only) node is stuck on FROM NODE1 (which is running) 2021-12-13T08:39:28.… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=4) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=6)