# Percona XtraDB Cluster 5.x **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [Resolving IST Utilization Issues in a Percona XtraDB Cluster and Adding a New Node](https://forums.percona.com/t/resolving-ist-utilization-issues-in-a-percona-xtradb-cluster-and-adding-a-new-node/26111)
**Author:** [@Marwan\_Wasel](https://forums.percona.com/u/Marwan_Wasel)\ **Replies:** 3\ **Last updated:** [October 24, 2023, 3:10pm UTC](https://forums.percona.com/t/resolving-ist-utilization-issues-in-a-percona-xtradb-cluster-and-adding-a-new-node/26111 "2023-10-24T15:10:00Z")
Hello All, In my current setup, I’m managing a two-node Percona XtraDB Cluster on Ubuntu 16.04.6, running MySQL - mysql Ver 14.14 Distrib 5.7.23-23, along with xtrabackup version 2.4.12, based on MySQL server 5.7.19. Ho… --- ## [Getting this error "Connection check failed: timeout (context deadline exceeded)" while trying to add mysql using pmm-admin](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277)
**Author:** [@Harish\_m.r](https://forums.percona.com/u/Harish_m.r)\ **Replies:** 3\ **Last updated:** [September 27, 2023, 9:05am UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277 "2023-09-27T09:05:10Z")
When we are trying to add mysql using pmm-admin getting this error “Connection check failed: timeout (context deadline exceeded)”. We tried checking the mysql command used by pmm-admin “SELECT /\* agent=‘connectionchecke… --- ## [Pt-show-grants with user and password file](https://forums.percona.com/t/pt-show-grants-with-user-and-password-file/25388)
**Author:** [@soprano](https://forums.percona.com/u/soprano)\ **Replies:** 4\ **Last updated:** [September 26, 2023, 4:02pm UTC](https://forums.percona.com/t/pt-show-grants-with-user-and-password-file/25388 "2023-09-26T16:02:47Z")
Hi all, i would like to save all grants of a server when i do the DBs backup (it runs every night) While mysql and mysqldump commands have an extrafile option that permit to use a file like this \[mysqldump\] user=DUMP… --- ## [No wsrep and general variables after upgrade](https://forums.percona.com/t/no-wsrep-and-general-variables-after-upgrade/25283)
**Author:** [@soprano](https://forums.percona.com/u/soprano)\ **Replies:** 11\ **Last updated:** [September 25, 2023, 3:51pm UTC](https://forums.percona.com/t/no-wsrep-and-general-variables-after-upgrade/25283 "2023-09-25T15:51:59Z")
Hi all, we upgraded our Percona Galera Xtradb Clusters (2 different cluster, one on CentOS and one on Ubuntu) to the version 5.7.43-31.65-1 and on both servers we got performance scheme wrong structure we fixed the er… --- ## [Slave replication failure after full SST on master](https://forums.percona.com/t/slave-replication-failure-after-full-sst-on-master/25197)
**Author:** [@vrcsts](https://forums.percona.com/u/vrcsts)\ **Replies:** 6\ **Last updated:** [September 21, 2023, 4:02pm UTC](https://forums.percona.com/t/slave-replication-failure-after-full-sst-on-master/25197 "2023-09-21T16:02:04Z")
Hello, I have a set up consisting of a 3 node PXC cluster with 5.7.33, let’s call the nodes my01, my02, my03. The cluster itself is single master, using ProxySQL to direct writes to one single server. Then, my03 is repl… --- ## [Xtrabackup failing on SHOW GLOBAL VARIABLES](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206)
**Author:** [@crimson\_pirate](https://forums.percona.com/u/crimson_pirate)\ **Replies:** 2\ **Last updated:** [September 18, 2023, 10:11am UTC](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206 "2023-09-18T10:11:24Z")
Hello, We have recently upgraded our Percona XTRADB 5.7 cluster running on rhel7 with the following packages Percona-XtraDB-Cluster-client-57-5.7.43-31.65.1.el7.x86\_64 Percona-XtraDB-Cluster-shared-57-5.7.43-31.65.1.e… --- ## [Performance\_schema recreation](https://forums.percona.com/t/performance-schema-recreation/24840)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 11\ **Last updated:** [September 12, 2023, 12:38pm UTC](https://forums.percona.com/t/performance-schema-recreation/24840 "2023-09-12T12:38:45Z")
Hello, I had some issue on my two node percona 5.7 cluster and after the restart I started to get issues like performance\_schema.variables has structure issue. I tried to recreate the the performance schema by disabling… --- ## [Percona XtraDB Cluster 5.7.43-31.65 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-43-31-65-released/24874)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [September 1, 2023, 11:33am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-43-31-65-released/24874 "2023-09-01T11:33:46Z")
August 31, 2023 - Find release notes at Percona XtraDB Cluster 5.7.43-31.65 (2023-08-31) - Percona XtraDB Cluster --- ## [Safe\_to\_bootstrap is not set to 1 when using Galera Arbitrator](https://forums.percona.com/t/safe-to-bootstrap-is-not-set-to-1-when-using-galera-arbitrator/24529)
**Author:** [@iam980](https://forums.percona.com/u/iam980)\ **Replies:** 2\ **Last updated:** [August 18, 2023, 10:22am UTC](https://forums.percona.com/t/safe-to-bootstrap-is-not-set-to-1-when-using-galera-arbitrator/24529 "2023-08-18T10:22:50Z")
Hello, Currently I am using thee nodes system - with 2 nodes of MySql instances and one node with Galera Arbitrator installed on it. When shutting down nodes gracefully, with the arbitrator as the last node to be shut… --- ## [Question about the open ports](https://forums.percona.com/t/question-about-the-open-ports/22885)
**Author:** [@Keon](https://forums.percona.com/u/Keon)\ **Replies:** 3\ **Last updated:** [July 30, 2023, 6:57pm UTC](https://forums.percona.com/t/question-about-the-open-ports/22885 "2023-07-30T18:57:01Z")
\[educational purposes) Hey comm, when preparing the xtraDB Cluster the documentation says that i need to open the following ports: – 3306 – 4444 – 4567 – 4568 So if i understand it correct, these ports just need t… --- ## [Recommended loadbalancer?](https://forums.percona.com/t/recommended-loadbalancer/22884)
**Author:** [@Keon](https://forums.percona.com/u/Keon)\ **Replies:** 4\ **Last updated:** [July 30, 2023, 6:46pm UTC](https://forums.percona.com/t/recommended-loadbalancer/22884 "2023-07-30T18:46:50Z")
(educational purposes) Hey comm, as my next question is - i’m using the xtraDB Cluster for high available databases for different applications. As when i connect the application to the (for example) node1 and node1 fa… --- ## [1 node out of sync and 1 node down out of 3 Node in MYSQL Percona Cluster](https://forums.percona.com/t/1-node-out-of-sync-and-1-node-down-out-of-3-node-in-mysql-percona-cluster/23900)
**Author:** [@sachinjoshi](https://forums.percona.com/u/sachinjoshi)\ **Replies:** 12\ **Last updated:** [July 27, 2023, 2:33pm UTC](https://forums.percona.com/t/1-node-out-of-sync-and-1-node-down-out-of-3-node-in-mysql-percona-cluster/23900 "2023-07-27T14:33:31Z")
I have 3 Node MySQL Percona XDBCluster, Everything was working fine since last one year, on 12th July 2023 Xtrabackup failed on Node 2 and Node 3 with SQL Error (1047): WSREP has not yet prepared node for application use… --- ## [MySQL Bi-directional Async Replication between 2 PXC Clusters](https://forums.percona.com/t/mysql-bi-directional-async-replication-between-2-pxc-clusters/23241)
**Author:** [@SridharJ](https://forums.percona.com/u/SridharJ)\ **Replies:** 2\ **Last updated:** [July 12, 2023, 12:13am UTC](https://forums.percona.com/t/mysql-bi-directional-async-replication-between-2-pxc-clusters/23241 "2023-07-12T00:13:05Z")
Hi, I would like to know the preferred approach for setting up replication between 2 PXC MySQL clusters running on different geographical datacenters. The current approach that we follow is as below Cluster A runs on… --- ## [Percona XtraDB Cluster 8.0 CentOS 8](https://forums.percona.com/t/percona-xtradb-cluster-8-0-centos-8/7635)
**Author:** [@davdidding](https://forums.percona.com/u/davdidding)\ **Replies:** 2\ **Last updated:** [June 30, 2023, 9:55am UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-0-centos-8/7635 "2023-06-30T09:55:02Z")
\[ERROR\] \[MY-000000\] \[Galera\] handshake with remote endpoint ssl://192.168.1.130:4567 failed: asio.ssl:67567754: ‘invalid padding’ ( 67567754: ‘error:0407008A:rsa routines:RSA\_padding\_check\_PKCS1\_type\_1:invalid padding’)T… --- ## [wsrep\_slave\_FK\_checks](https://forums.percona.com/t/wsrep-slave-fk-checks/23165)
**Author:** [@Ani\_Ghoghoberidze](https://forums.percona.com/u/Ani_Ghoghoberidze)\ **Replies:** 18\ **Last updated:** [June 29, 2023, 5:25pm UTC](https://forums.percona.com/t/wsrep-slave-fk-checks/23165 "2023-06-29T17:25:05Z")
Hi. I have galera cluster with 3 nodes. Version is 5.7.41-44-57-log. Have disabled wsrep\_slave\_FK\_checks variable, to skip checking fks while committing changes into slave nodes. I’m still receiving errors in log like t… --- ## [SST dies after 120 second Stall after transferring 300+GB on AWS only](https://forums.percona.com/t/sst-dies-after-120-second-stall-after-transferring-300-gb-on-aws-only/15657)
**Author:** [@sgales](https://forums.percona.com/u/sgales)\ **Replies:** 3\ **Last updated:** [June 28, 2023, 7:44am UTC](https://forums.percona.com/t/sst-dies-after-120-second-stall-after-transferring-300-gb-on-aws-only/15657 "2023-06-28T07:44:01Z")
Hey folks, running into a weird problem within an AWS DC we have, SST transfers work for a while, then after 300+ GB of transfer they suddenly stall for 120+ seconds and timeout. We are sort of working around this using… --- ## [Is it safe to run mysqloptimize on a 5.7 PXC cluster?](https://forums.percona.com/t/is-it-safe-to-run-mysqloptimize-on-a-5-7-pxc-cluster/23111)
**Author:** [@nublaii](https://forums.percona.com/u/nublaii)\ **Replies:** 3\ **Last updated:** [June 27, 2023, 12:59pm UTC](https://forums.percona.com/t/is-it-safe-to-run-mysqloptimize-on-a-5-7-pxc-cluster/23111 "2023-06-27T12:59:41Z")
I have searched the forum, but all Q&A related to this are very old (some dating back to 2012-2013). So, ¿is it safe to run mysqloptimize -o databasename on a PXC 5.7 cluster on 2023? --- ## [How Can I Running PXC\_MySQL in a docker swarm mode by docker stack deploy](https://forums.percona.com/t/how-can-i-running-pxc-mysql-in-a-docker-swarm-mode-by-docker-stack-deploy/22522)
**Author:** [@baiclamp](https://forums.percona.com/u/baiclamp)\ **Replies:** 5\ **Last updated:** [June 27, 2023, 2:26am UTC](https://forums.percona.com/t/how-can-i-running-pxc-mysql-in-a-docker-swarm-mode-by-docker-stack-deploy/22522 "2023-06-27T02:26:16Z")
Hi, I got deploy error in deploy a pxc\_mysql in docker swarm mode. I have been saw the blog post about the how to use the container, but it seen not really running in swarm mode. just docker compose mode. I got success… --- ## [Mysqld got signal 11 MySQL 5.7](https://forums.percona.com/t/mysqld-got-signal-11-mysql-5-7/22854)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 4\ **Last updated:** [June 21, 2023, 7:38pm UTC](https://forums.percona.com/t/mysqld-got-signal-11-mysql-5-7/22854 "2023-06-21T19:38:04Z")
Hello, I have a three node Percona Xtradb Cluster 5.7. I resized on of the machine from 16 cores to 24 cores and after that MySQL get shutsdown randomly. Following are the logs when DB shutsdown. Please help me to identi… --- ## [Changing the DataDir before or after configuring the Cluster?](https://forums.percona.com/t/changing-the-datadir-before-or-after-configuring-the-cluster/22882)
**Author:** [@Keon](https://forums.percona.com/u/Keon)\ **Replies:** 1\ **Last updated:** [June 18, 2023, 12:33am UTC](https://forums.percona.com/t/changing-the-datadir-before-or-after-configuring-the-cluster/22882 "2023-06-18T00:33:28Z")
(educational purposes) Hey comm, actually i’m just trying to understand the working of xtraDB Cluster and how to set it up proberly. In this situation i want to use 3 cloud servers, where each has a ssd volume connecte… --- ## [Node2 did not connect in node1](https://forums.percona.com/t/node2-did-not-connect-in-node1/22752)
**Author:** [@Santhosh\_Pandi](https://forums.percona.com/u/Santhosh_Pandi)\ **Replies:** 10\ **Last updated:** [June 16, 2023, 7:19am UTC](https://forums.percona.com/t/node2-did-not-connect-in-node1/22752 "2023-06-16T07:19:43Z")
asio error ‘Failed to listen: bind: Cannot assign requested address: 99 (Cannot assign requested address) at galerautils/src/gu\_asio\_stream\_react.cpp:listen():788’: 99 (Cannot assign requested address) at galera/src/is… --- ## [Percona XtraDB Cluster 5.7.42-31.65 Released](https://forums.percona.com/t/percona-xtradb-cluster-5-7-42-31-65-released/22669)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 8, 2023, 11:07am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-42-31-65-released/22669 "2023-06-08T11:07:12Z")
June 08, 2023 - Find release notes at Percona XtraDB Cluster 5.7.42-31.65 (2023-06-08) - Percona XtraDB Cluster --- ## [It's it possible to using XtraDB cluster as a slave?](https://forums.percona.com/t/its-it-possible-to-using-xtradb-cluster-as-a-slave/5790)
**Author:** [@Gaet16221284](https://forums.percona.com/u/Gaet16221284)\ **Replies:** 6\ **Last updated:** [May 15, 2023, 1:19am UTC](https://forums.percona.com/t/its-it-possible-to-using-xtradb-cluster-as-a-slave/5790 "2023-05-15T01:19:06Z")
Hi, I want to use a cluster of servers using XtraDB as a slave and I want the master see a cluster like a single server (slave). Is this possible? I have attached a diagram. I tried several configurations, but it did… --- ## [Cannot get GTID replication to work from one XtraDB cluster to another](https://forums.percona.com/t/cannot-get-gtid-replication-to-work-from-one-xtradb-cluster-to-another/21990)
**Author:** [@csheridan](https://forums.percona.com/u/csheridan)\ **Replies:** 4\ **Last updated:** [May 13, 2023, 1:37pm UTC](https://forums.percona.com/t/cannot-get-gtid-replication-to-work-from-one-xtradb-cluster-to-another/21990 "2023-05-13T13:37:04Z")
I have an on-prem XtraDB Cluster running 5.7. That cluster replicates to an EC2 instance in AWS. I am setting up a recovery cluster to be identical to the on-prem cluster, but I cannot get it to work. Here is how it wor… --- ## [whole cluster crashed due to table not synced](https://forums.percona.com/t/whole-cluster-crashed-due-to-table-not-synced/4078)
**Author:** [@andymao](https://forums.percona.com/u/andymao)\ **Replies:** 3\ **Last updated:** [May 11, 2023, 4:42pm UTC](https://forums.percona.com/t/whole-cluster-crashed-due-to-table-not-synced/4078 "2023-05-11T16:42:01Z")
Hi All, We had an 7 nodes cluster which crossing three datacenter. with 2/2/3 on different datacenter. we got problem as the whole cluster not function due to table not synced with 11 minutes delay.. the table was fir… --- ## [Nodes can't join bootstrapped node](https://forums.percona.com/t/nodes-cant-join-bootstrapped-node/21970)
**Author:** [@Aldrin\_John\_Lagrima1](https://forums.percona.com/u/Aldrin_John_Lagrima1)\ **Replies:** 1\ **Last updated:** [May 11, 2023, 2:57pm UTC](https://forums.percona.com/t/nodes-cant-join-bootstrapped-node/21970 "2023-05-11T14:57:32Z")
I’m trying to join node 4 to the cluster of node 1 that I bootstrapped the sst starts for a while then it fails. Details: node 1: Ubuntu 16 Percona MySQL 5.7.36-39 node 4 Ubuntu 20 Percona MySQL 5.7.41-44 Here is… --- ## [Wsrep doesn't turn on](https://forums.percona.com/t/wsrep-doesnt-turn-on/21954)
**Author:** [@Aldrin\_John\_Lagrima1](https://forums.percona.com/u/Aldrin_John_Lagrima1)\ **Replies:** 3\ **Last updated:** [May 9, 2023, 11:51pm UTC](https://forums.percona.com/t/wsrep-doesnt-turn-on/21954 "2023-05-09T23:51:37Z")
I’m trying to start a new cluster named pxc-cluster Cluster is being bootstrapped successfully but galera library isn’t being read if placed in wsrep.cnf but after transferring it to my.cnf it shows the following error: … --- ## [Haproxy or ProxySQL, your personal preference](https://forums.percona.com/t/haproxy-or-proxysql-your-personal-preference/21931)
**Author:** [@ahmadzadaa](https://forums.percona.com/u/ahmadzadaa)\ **Replies:** 7\ **Last updated:** [May 9, 2023, 1:53pm UTC](https://forums.percona.com/t/haproxy-or-proxysql-your-personal-preference/21931 "2023-05-09T13:53:33Z")
After reading https://www.percona.com/blog/percona-kubernetes-operator-for-percona-xtradb-cluster-haproxy-or-proxysql/ , it pushes me towards haproxy because of easy to maintainability and write performance. I have to m… --- ## [Considerations before moving from standalone mysql to xtradb cluster](https://forums.percona.com/t/considerations-before-moving-from-standalone-mysql-to-xtradb-cluster/21853)
**Author:** [@ahmadzadaa](https://forums.percona.com/u/ahmadzadaa)\ **Replies:** 3\ **Last updated:** [May 4, 2023, 3:26pm UTC](https://forums.percona.com/t/considerations-before-moving-from-standalone-mysql-to-xtradb-cluster/21853 "2023-05-04T15:26:52Z")
Should we consider anything in terms of how application works with database berfore migrating from standalone to cluster? like is there any type of operation that it was possible with standalone but cluster may fail to… --- ## [Moving from standalone Mysql 5.7 to Percona XtraDB cluster](https://forums.percona.com/t/moving-from-standalone-mysql-5-7-to-percona-xtradb-cluster/21832)
**Author:** [@ahmadzadaa](https://forums.percona.com/u/ahmadzadaa)\ **Replies:** 7\ **Last updated:** [May 4, 2023, 2:37pm UTC](https://forums.percona.com/t/moving-from-standalone-mysql-5-7-to-percona-xtradb-cluster/21832 "2023-05-04T14:37:10Z")
We are planning to have HA for our standalone Mysql 5.7 server. Our first idea is moving from standalone mysql 5.7 to percona mysql with XtraDB cluster (either 3 data nodes or 2 data and 1 arbitrator), anyone can provide… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=1) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtradb-cluster-5-x/12.md?page=3)