# MySQL & MariaDB **URL:** https://forums.percona.com/c/mysql-mariadb/36.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the MySQL & MariaDB category](https://forums.percona.com/t/about-the-mysql-mariadb-category/41)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 0
For questions on Percona Distribution for MySQL, Percona Server for MySQL, MariaDB, & other MySQL® topics. --- ## [Permissions errors when trying to install mariadb using mariadb-install-db](https://forums.percona.com/t/permissions-errors-when-trying-to-install-mariadb-using-mariadb-install-db/41302)
**Author:** [@xraphael75](https://forums.percona.com/u/xraphael75)\ **Replies:** 6\ **Last updated:** [October 22, 2026, 7:12am UTC](https://forums.percona.com/t/permissions-errors-when-trying-to-install-mariadb-using-mariadb-install-db/41302 "2026-10-22T07:12:50Z")
I have kubuntu 26.04 and I’m trying to install 3 instances of mariadb using mariadb-install-db. I went through several tutorials, which are all slightly different: https://medium.com/@omkarmanjrekar/running-multiple-my… --- ## [Is Jemalloc still recommended to replace glibc?](https://forums.percona.com/t/is-jemalloc-still-recommended-to-replace-glibc/41183)
**Author:** [@minh](https://forums.percona.com/u/minh)\ **Replies:** 6\ **Last updated:** [October 21, 2026, 2:48pm UTC](https://forums.percona.com/t/is-jemalloc-still-recommended-to-replace-glibc/41183 "2026-10-21T14:48:51Z")
We have Percona MySQL 5.7 running on AWS EC2 with 752 GB of memory and 128 CPUs, using Rocky 8. We typically see around 36K QPS during peak times, with approximately 20–40 running threads. However, we have experienced o… --- ## [PXC operator 1.20.0: custom user reconcile loops forever (view definer, error 4006) and repeated CREATE DATABASE aborts app transactions](https://forums.percona.com/t/pxc-operator-1-20-0-custom-user-reconcile-loops-forever-view-definer-error-4006-and-repeated-create-database-aborts-app-transactions/41363)
**Author:** [@Daniel\_Muhra](https://forums.percona.com/u/Daniel_Muhra)\ **Replies:** 0\ **Last updated:** [October 21, 2026, 1:08pm UTC](https://forums.percona.com/t/pxc-operator-1-20-0-custom-user-reconcile-loops-forever-view-definer-error-4006-and-repeated-create-database-aborts-app-transactions/41363 "2026-10-21T13:08:45Z")
Environment Percona Operator for MySQL based on PXC 1.20.0 PXC 8.4.8-8.1, 3 nodes, HAProxy enabled spec.users: users: - name: app dbs: \[app\_db1, app\_db2\] hosts: \["%"\] grants: \[ALL\] passwordSecretRef: {name: app… --- ## [Xbcloud get incorrect (truncated) files](https://forums.percona.com/t/xbcloud-get-incorrect-truncated-files/41355)
**Author:** [@zhangxl890207](https://forums.percona.com/u/zhangxl890207)\ **Replies:** 4\ **Last updated:** [October 21, 2026, 9:47am UTC](https://forums.percona.com/t/xbcloud-get-incorrect-truncated-files/41355 "2026-10-21T09:47:04Z")
\# xbcloud get s3://rmas/project-middleware-100/mysql-382/middleware-backup-6055 --s3-endpoint=‘http://s3.middleware.bj’ --s3-access-key=‘XXXXXX’ --s3-secret-key=‘XXXXXXXX’ --s3-region=‘Beijing’ --parallel=10 | xbstream … --- ## [PXC cluster node crashed and cannot recover](https://forums.percona.com/t/pxc-cluster-node-crashed-and-cannot-recover/39153)
**Author:** [@Gerwin\_van\_de\_Steeg](https://forums.percona.com/u/Gerwin_van_de_Steeg)\ **Replies:** 10\ **Last updated:** [October 21, 2026, 4:37am UTC](https://forums.percona.com/t/pxc-cluster-node-crashed-and-cannot-recover/39153 "2026-10-21T04:37:17Z")
Description: This happens frequently enough that it gets really annoying, out of the two database instances running they frequently enough crash with no easy to diagnose reason and cannot recover themselves leaving the p… --- ## [PXC 8.0.46-38 remains in Donor/Desynced after mydumper backup](https://forums.percona.com/t/pxc-8-0-46-38-remains-in-donor-desynced-after-mydumper-backup/41146)
**Author:** [@DeBuXer](https://forums.percona.com/u/DeBuXer)\ **Replies:** 4\ **Last updated:** [October 19, 2026, 2:33pm UTC](https://forums.percona.com/t/pxc-8-0-46-38-remains-in-donor-desynced-after-mydumper-backup/41146 "2026-10-19T14:33:34Z")
Since upgrading our Percona XtraDB Cluster to 8.0.46-38, one node remains stuck in Donor/Desynced after a mydumper backup. This backup setup had been working for years before the upgrade. Our original backup script was… --- ## [Problem with pc.recovery](https://forums.percona.com/t/problem-with-pc-recovery/41351)
**Author:** [@ysysberserk2](https://forums.percona.com/u/ysysberserk2)\ **Replies:** 1\ **Last updated:** [October 16, 2026, 11:39am UTC](https://forums.percona.com/t/problem-with-pc-recovery/41351 "2026-10-16T11:39:18Z")
I have a mysql8.4.10 cluster of 3 nodes A/B/C with default config pc.wait\_prim = true; pc.wait\_prim\_timeout = PT30S; pc.wait\_restored\_prim\_timeout = PT0S; pc.recovery=true. When all nodes power off at almost the same ti… --- ## [Amazon RDS MySQL: 99% system CPU, mysqld unexpectedly restarted, repeated failures resolved after Stop/Start — what could cause this?](https://forums.percona.com/t/amazon-rds-mysql-99-system-cpu-mysqld-unexpectedly-restarted-repeated-failures-resolved-after-stop-start-what-could-cause-this/41344)
**Author:** [@Sidney\_Cheina](https://forums.percona.com/u/Sidney_Cheina)\ **Replies:** 4\ **Last updated:** [October 15, 2026, 4:58pm UTC](https://forums.percona.com/t/amazon-rds-mysql-99-system-cpu-mysqld-unexpectedly-restarted-repeated-failures-resolved-after-stop-start-what-could-cause-this/41344 "2026-10-15T16:58:24Z")
Hello, I’m investigating a production incident involving Amazon RDS for MySQL and would appreciate help identifying its possible root cause. On October 14, 2026, our RDS instance experienced a sudden and severe perform… --- ## [PXC 8.0 to 8.4 on OpenShift 4.14 now, 4.22 later: which operator version and upgrade path?](https://forums.percona.com/t/pxc-8-0-to-8-4-on-openshift-4-14-now-4-22-later-which-operator-version-and-upgrade-path/41342)
**Author:** [@jin.wen](https://forums.percona.com/u/jin.wen)\ **Replies:** 0\ **Last updated:** [October 14, 2026, 7:00pm UTC](https://forums.percona.com/t/pxc-8-0-to-8-4-on-openshift-4-14-now-4-22-later-which-operator-version-and-upgrade-path/41342 "2026-10-14T19:00:17Z")
Description: Hi @Slava\_Sarzhan @Valmira\_Nogueira, We plan the move from PXC 8.0 to 8.4 and would like Percona’s guidance on the operator version and the upgrade path. The platform’s next OpenShift version is 4.22 or lat… --- ## [Percona MySQL 8.0 migration to Aurora MySQL](https://forums.percona.com/t/percona-mysql-8-0-migration-to-aurora-mysql/41319)
**Author:** [@carlos.mejia.ven](https://forums.percona.com/u/carlos.mejia.ven)\ **Replies:** 6\ **Last updated:** [October 8, 2026, 6:59am UTC](https://forums.percona.com/t/percona-mysql-8-0-migration-to-aurora-mysql/41319 "2026-10-08T06:59:27Z")
Hello, I’m trying to restore a backup of an on-premise Percona MySQL 8.0 database in AWS but the operation never ends. I’m testing with a 30GB Percona MySQL replica (real DB is 2TB): mysql\> SHOW VARIABLES LIKE 'versio… --- ## [Operator PS MySQL - behaviour on 1 instance that gets unavailable](https://forums.percona.com/t/operator-ps-mysql-behaviour-on-1-instance-that-gets-unavailable/41171)
**Author:** [@Carlos\_Abrantes](https://forums.percona.com/u/Carlos_Abrantes)\ **Replies:** 6\ **Last updated:** [October 2, 2026, 1:30pm UTC](https://forums.percona.com/t/operator-ps-mysql-behaviour-on-1-instance-that-gets-unavailable/41171 "2026-10-02T13:30:54Z")
Hi all, just trying to understand the expected operator behaviour. Description: a cluster with 3 instances using Group Replication one pod/instance gets unavailable (network split 1 vs 2). It gets the state UNREACHAB… --- ## [Pt-online-schema-change 3.7.1 exhausts max\_user\_connections on MySQL 8.4 replica lag checks](https://forums.percona.com/t/pt-online-schema-change-3-7-1-exhausts-max-user-connections-on-mysql-8-4-replica-lag-checks/41300)
**Author:** [@Aneel\_Ahmad](https://forums.percona.com/u/Aneel_Ahmad)\ **Replies:** 1\ **Last updated:** [October 2, 2026, 1:58am UTC](https://forums.percona.com/t/pt-online-schema-change-3-7-1-exhausts-max-user-connections-on-mysql-8-4-replica-lag-checks/41300 "2026-10-02T01:58:14Z")
Environment: pt-online-schema-change 3.7.1-4 (percona-toolkit) Primary: Percona Server 8.0.36-28 Replicas: MySQL 8.4 OS: Linux (x86\_64) Replica discovery: --recursion-method dsn=“D=,t=dsns” Primary: Percona Server 8.… --- ## [Tarball-based Percona SST/IST failure after upgrading from 8.4.4-4.1 to 8.4.8-8.1](https://forums.percona.com/t/tarball-based-percona-sst-ist-failure-after-upgrading-from-8-4-4-4-1-to-8-4-8-8-1/41279)
**Author:** [@mahesh\_d](https://forums.percona.com/u/mahesh_d)\ **Replies:** 6\ **Last updated:** [September 23, 2026, 8:59am UTC](https://forums.percona.com/t/tarball-based-percona-sst-ist-failure-after-upgrading-from-8-4-4-4-1-to-8-4-8-8-1/41279 "2026-09-23T08:59:14Z")
We have successfully deployed a 3 node Percona XtraDB Cluster v8.4.4 via the el8 (glibc2.28) “miminal” tarballs on 3 RHEL8.10 servers. Everything is running as root and deployed under /root directory (tarball extracted i… --- ## [Xbcloud get from s3 fail](https://forums.percona.com/t/xbcloud-get-from-s3-fail/34570)
**Author:** [@j\_olivia](https://forums.percona.com/u/j_olivia)\ **Replies:** 6\ **Last updated:** [September 21, 2026, 1:37pm UTC](https://forums.percona.com/t/xbcloud-get-from-s3-fail/34570 "2026-09-21T13:37:32Z")
I can’t not get backup data from s3 to use xbcloud. my command is xbcloud get s3://bucket/path/ –s3-access-key=\*\*\*\* –s3-secret-key=\*\*\*\* –s3-region=\*\*\*\* | xbstream restore -x -C /backup/FULL/ and then i got re… --- ## [Percona Server 5.7 - ERROR 3185 on one DRE encrypted table only; others work fine](https://forums.percona.com/t/percona-server-5-7-error-3185-on-one-dre-encrypted-table-only-others-work-fine/41255)
**Author:** [@pravata\_dash](https://forums.percona.com/u/pravata_dash)\ **Replies:** 5\ **Last updated:** [September 19, 2026, 10:42am UTC](https://forums.percona.com/t/percona-server-5-7-error-3185-on-one-dre-encrypted-table-only-others-work-fine/41255 "2026-09-19T10:42:44Z")
Problem: Without any changes at Mysql DB OR table level, one DRE(Data At Rest Encryption) table consistently fails where as other encrypted tables are accessible, SELECT COUNT(\*) FROM myschema.user\_profile; -- ERROR 31… --- ## [Question about pt-online-schema-change and performance\_schema](https://forums.percona.com/t/question-about-pt-online-schema-change-and-performance-schema/41275)
**Author:** [@albourg](https://forums.percona.com/u/albourg)\ **Replies:** 9\ **Last updated:** [September 18, 2026, 8:14am UTC](https://forums.percona.com/t/question-about-pt-online-schema-change-and-performance-schema/41275 "2026-09-18T08:14:07Z")
Hi, I run mariadb 11.4.12, galera, on red had linux 9. I installed percona toolkit, holding pt-online-schema-change 3.7.1-4 I ran this: pt-online-schema-change --alter "ADD INDEX ix\_trnsaction\_request\_date(request\_da… --- ## [Percona XtraDB 84 - Clone SST joiner aborts with “Operation not permitted” on Ubuntu 24.04: mv -n exits 1 under errexit when datadir already has \*.pem](https://forums.percona.com/t/percona-xtradb-84-clone-sst-joiner-aborts-with-operation-not-permitted-on-ubuntu-24-04-mv-n-exits-1-under-errexit-when-datadir-already-has-pem/41268)
**Author:** [@moro15011](https://forums.percona.com/u/moro15011)\ **Replies:** 2\ **Last updated:** [September 17, 2026, 1:08am UTC](https://forums.percona.com/t/percona-xtradb-84-clone-sst-joiner-aborts-with-operation-not-permitted-on-ubuntu-24-04-mv-n-exits-1-under-errexit-when-datadir-already-has-pem/41268 "2026-09-17T01:08:11Z")
Project: PXC Component: SST (clone) Affects version: 8.4.10-10 (code path also present on 8.0 and trunk branches) Severity: a node that previously belonged to the cluster cannot rejoin via clone SST Summary On Ubuntu… --- ## [Does Percona MySQL support arbitrator‑node capability](https://forums.percona.com/t/does-percona-mysql-support-arbitrator-node-capability/41246)
**Author:** [@Leo\_Ma](https://forums.percona.com/u/Leo_Ma)\ **Replies:** 5\ **Last updated:** [September 16, 2026, 1:46pm UTC](https://forums.percona.com/t/does-percona-mysql-support-arbitrator-node-capability/41246 "2026-09-16T13:46:10Z")
I would like to check if there is any roadmap or plan for Percona Server for MySQL to support the group\_replication\_arbitrator feature for MySQL Group Replication. Currently, the upstream Oracle MySQL Group Replication … --- ## [How should GCache size be determined for PXC?](https://forums.percona.com/t/how-should-gcache-size-be-determined-for-pxc/41230)
**Author:** [@Sekhri](https://forums.percona.com/u/Sekhri)\ **Replies:** 3\ **Last updated:** [September 7, 2026, 7:46am UTC](https://forums.percona.com/t/how-should-gcache-size-be-determined-for-pxc/41230 "2026-09-07T07:46:27Z")
I am running a 3-node Percona XtraDB Cluster on Kubernetes, where the PV size is selected dynamically by the user on the dashboard (minimum 50GB). What is the recommended approach for determining gcache.size? Is there … --- ## [Guidance needed for pt-table-checksum on MySQL master-master / source-source replication](https://forums.percona.com/t/guidance-needed-for-pt-table-checksum-on-mysql-master-master-source-source-replication/41142)
**Author:** [@degokul](https://forums.percona.com/u/degokul)\ **Replies:** 5\ **Last updated:** [September 6, 2026, 2:04am UTC](https://forums.percona.com/t/guidance-needed-for-pt-table-checksum-on-mysql-master-master-source-source-replication/41142 "2026-09-06T02:04:48Z")
Hi Percona community, I’m looking for guidance on the safest operational pattern for using \`pt-table-checksum\` in a MySQL master-master / source-source replication setup. Environment summary: Database: MySQL Enterpri… --- ## [When will XtraDB Cluster 8.4.11 be avaiable?](https://forums.percona.com/t/when-will-xtradb-cluster-8-4-11-be-avaiable/41217)
**Author:** [@ysysberserk2](https://forums.percona.com/u/ysysberserk2)\ **Replies:** 5\ **Last updated:** [September 3, 2026, 9:35am UTC](https://forums.percona.com/t/when-will-xtradb-cluster-8-4-11-be-avaiable/41217 "2026-09-03T09:35:28Z")
We has updated our cluster to XtraDB Cluster 8.4.10. But the scaner of our customers found cve problems in 8.4.10 and request us to update to 8.4.11. Since Percona Server for MySQL 8.4.11 is available now. Can we just u… --- ## [XtraDB Cluster Nodes Vertical Scaling](https://forums.percona.com/t/xtradb-cluster-nodes-vertical-scaling/41209)
**Author:** [@Sekhri](https://forums.percona.com/u/Sekhri)\ **Replies:** 2\ **Last updated:** [August 27, 2026, 6:16pm UTC](https://forums.percona.com/t/xtradb-cluster-nodes-vertical-scaling/41209 "2026-08-27T18:16:18Z")
I have a 3-node Rancher Kubernetes cluster running Percona XtraDB Cluster (PXC). Each Kubernetes worker node currently has 4 vCPU and 16 GB RAM, and I would like to vertically scale each node to 8 vCPU and 32 GB RAM. Th… --- ## [Galera: change server\_id & domain-id on \*running\* cluster](https://forums.percona.com/t/galera-change-server-id-domain-id-on-running-cluster/41185)
**Author:** [@Florent\_RIVOIRE](https://forums.percona.com/u/Florent_RIVOIRE)\ **Replies:** 3\ **Last updated:** [August 26, 2026, 4:29pm UTC](https://forums.percona.com/t/galera-change-server-id-domain-id-on-running-cluster/41185 "2026-08-26T16:29:41Z")
Hello, I’m trying to change those ids on an existing cluster, but can’t manage to make it work properly, and would like some help: Context: a 3-nodes Galera cluster in production, receiving read/write traffic using M… --- ## [PXC 8.4.6: LOCK\_ticket\_store\_ops mutex instances grow with cumulative connections](https://forums.percona.com/t/pxc-8-4-6-lock-ticket-store-ops-mutex-instances-grow-with-cumulative-connections/41203)
**Author:** [@Wu\_Nan\_Lin](https://forums.percona.com/u/Wu_Nan_Lin)\ **Replies:** 4\ **Last updated:** [August 25, 2026, 2:11pm UTC](https://forums.percona.com/t/pxc-8-4-6-lock-ticket-store-ops-mutex-instances-grow-with-cumulative-connections/41203 "2026-08-25T14:11:31Z")
Hello Percona team, We are seeing continuous growth of this Performance Schema mutex instance on a three-node staging PXC cluster: wait/synch/mutex/sql/MDL\_ticket\_store::LOCK\_ticket\_store\_ops Environment PXC: 8.4.6-6.… --- ## [Alleged memory leak in MySQL master on a huge database](https://forums.percona.com/t/alleged-memory-leak-in-mysql-master-on-a-huge-database/31069)
**Author:** [@mag1kan1n](https://forums.percona.com/u/mag1kan1n)\ **Replies:** 9\ **Last updated:** [August 24, 2026, 11:09am UTC](https://forums.percona.com/t/alleged-memory-leak-in-mysql-master-on-a-huge-database/31069 "2026-08-24T11:09:06Z")
Hi everyone. I am having a trouble with the MySQL installation that causes slow but steady memory consumption increase on the production database. I am attaching the config and a screenshot that shows MySQL memory usag… --- ## [PXC IST Recovery Time After Heavy Write Load (11+ Hours of Continuous Writes)](https://forums.percona.com/t/pxc-ist-recovery-time-after-heavy-write-load-11-hours-of-continuous-writes/41187)
**Author:** [@vagrawal](https://forums.percona.com/u/vagrawal)\ **Replies:** 3\ **Last updated:** [August 21, 2026, 10:24am UTC](https://forums.percona.com/t/pxc-ist-recovery-time-after-heavy-write-load-11-hours-of-continuous-writes/41187 "2026-08-21T10:24:39Z")
Hello Percona Team, We are testing Percona XtraDB Cluster (PXC) 8.4.x with the objective of understanding the recovery time after a node has been offline during a heavy write workload. Test Environment Percona XtraDB … --- ## [Double entry about disconnection audit\_log\_filter Mysql 8.4.10](https://forums.percona.com/t/double-entry-about-disconnection-audit-log-filter-mysql-8-4-10/41180)
**Author:** [@Kobold](https://forums.percona.com/u/Kobold)\ **Replies:** 7\ **Last updated:** [August 20, 2026, 7:19am UTC](https://forums.percona.com/t/double-entry-about-disconnection-audit-log-filter-mysql-8-4-10/41180 "2026-08-20T07:19:08Z")
I have next settings: SELECT audit\_log\_filter\_set\_filter('only\_logins', '{"filter": {"class": \[{"name": "connection", "event": \[{"name": "connect"}, {"name": "disconnect"}\]}\]}}'); SELECT audit\_log\_filter\_set\_user('%', … --- ## [Percona XtraDB Cluster 8.4 Rocky Linux 10 issue](https://forums.percona.com/t/percona-xtradb-cluster-8-4-rocky-linux-10-issue/41177)
**Author:** [@Arya\_Emini](https://forums.percona.com/u/Arya_Emini)\ **Replies:** 2\ **Last updated:** [August 18, 2026, 5:06pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-4-rocky-linux-10-issue/41177 "2026-08-18T17:06:44Z")
PXC 8.4.10-10 EL10: RPM dependency conflict with Rocky Linux 10 AppStream Summary Installing percona-xtradb-cluster-server-8.4.10-10.1.el10.x86\_64 on Rocky Linux 10 fails because the package requires perl-DBD-MySQL, whic… --- ## [How to migrate Secret Keys generated by component\_keyring\_vault from HashiCorp Vault to Azure Key Vault?](https://forums.percona.com/t/how-to-migrate-secret-keys-generated-by-component-keyring-vault-from-hashicorp-vault-to-azure-key-vault/41175)
**Author:** [@Sergey\_Ogurtsov](https://forums.percona.com/u/Sergey_Ogurtsov)\ **Replies:** 2\ **Last updated:** [August 18, 2026, 2:56pm UTC](https://forums.percona.com/t/how-to-migrate-secret-keys-generated-by-component-keyring-vault-from-hashicorp-vault-to-azure-key-vault/41175 "2026-08-18T14:56:10Z")
Hello colleagues, We currently use component\_keyring\_vault to manage encryption keys for Percona XtraDB Cluster with HashiCorp Vault. We are planning to migrate from HashiCorp Vault to Azure Key Vault. However, accordi… [Next page](https://forums.percona.com/c/mysql-mariadb/36.md?page=1)