# MySQL & MariaDB **URL:** https://forums.percona.com/c/mysql-mariadb/36.md?page=8 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 9 --- ## [How to disable TLS for the server](https://forums.percona.com/t/how-to-disable-tls-for-the-server/39006)
**Author:** [@Gerwin\_van\_de\_Steeg](https://forums.percona.com/u/Gerwin_van_de_Steeg)\ **Replies:** 5\ **Last updated:** [August 14, 2025, 3:13am UTC](https://forums.percona.com/t/how-to-disable-tls-for-the-server/39006 "2025-08-14T03:13:02Z")
Description: I have the need to disable the TLS functions on an instance of MySQL created by the Operator and have gone through the details as documented however the clients are still connecting with TLS. Since the deplo… --- ## [Using fpsync in a two-stage approach for MySQL 8.4 replica setup – is data corruption a risk during the first stage?](https://forums.percona.com/t/using-fpsync-in-a-two-stage-approach-for-mysql-8-4-replica-setup-is-data-corruption-a-risk-during-the-first-stage/39105)
**Author:** [@CharlesR](https://forums.percona.com/u/CharlesR)\ **Replies:** 2\ **Last updated:** [August 14, 2025, 12:51am UTC](https://forums.percona.com/t/using-fpsync-in-a-two-stage-approach-for-mysql-8-4-replica-setup-is-data-corruption-a-risk-during-the-first-stage/39105 "2025-08-14T00:51:28Z")
Hello everyone, I’m planning to set up a MySQL 8.4 replica and I’m looking for the most efficient way to minimize downtime. My proposed strategy involves a two-stage process using fpsync. First Synchronization (With … --- ## [Mysql.service: Referenced but unset environment variable evaluates to an empty string: MYSQLD\_OPTS](https://forums.percona.com/t/mysql-service-referenced-but-unset-environment-variable-evaluates-to-an-empty-string-mysqld-opts/39085)
**Author:** [@gwijayas](https://forums.percona.com/u/gwijayas)\ **Replies:** 4\ **Last updated:** [August 13, 2025, 5:28am UTC](https://forums.percona.com/t/mysql-service-referenced-but-unset-environment-variable-evaluates-to-an-empty-string-mysqld-opts/39085 "2025-08-13T05:28:29Z")
New installed Ubuntu 24.04.3. When I install MySQL 8.4 (percona-server-server8.4.5-5-1.noble), I got error message failed to start: mysql.service: Referenced but unset environment variable evaluates to an empty string:… --- ## [Percona helm 1.17.0 pxc-db mysql 5.7 pxc-db-haproxy is experiencing restarts. What are the causes, and how can this be resolved or optimized?](https://forums.percona.com/t/percona-helm-1-17-0-pxc-db-mysql-5-7-pxc-db-haproxy-is-experiencing-restarts-what-are-the-causes-and-how-can-this-be-resolved-or-optimized/39079)
**Author:** [@yl.w](https://forums.percona.com/u/yl.w)\ **Replies:** 1\ **Last updated:** [August 12, 2025, 2:11pm UTC](https://forums.percona.com/t/percona-helm-1-17-0-pxc-db-mysql-5-7-pxc-db-haproxy-is-experiencing-restarts-what-are-the-causes-and-how-can-this-be-resolved-or-optimized/39079 "2025-08-12T14:11:32Z")
Hello， Percona helm 1.17.0 pxc-db mysql 5.7 pxc-db-haproxy is experiencing restarts. What are the causes, and how can this be resolved or optimized? 1.The mysql-pxc-db-haproxy is experiencing restarts, reporting the fo… --- ## [Replication IO Thread does not start](https://forums.percona.com/t/replication-io-thread-does-not-start/38958)
**Author:** [@Phillip85](https://forums.percona.com/u/Phillip85)\ **Replies:** 5\ **Last updated:** [August 7, 2025, 4:07pm UTC](https://forums.percona.com/t/replication-io-thread-does-not-start/38958 "2025-08-07T16:07:18Z")
Hello, I have a problem with mit replication setup: my slave IO Thread always stops with an checksum verification failed error: 2025-08-04T13:26:27.959431+02:00 540 \[Warning\] \[MY-010897\] \[Repl\] Storing MySQL user name… --- ## [Why does the size of the xtraback Docker image grow so quickly?](https://forums.percona.com/t/why-does-the-size-of-the-xtraback-docker-image-grow-so-quickly/38999)
**Author:** [@Kymo\_Wang](https://forums.percona.com/u/Kymo_Wang)\ **Replies:** 1\ **Last updated:** [August 7, 2025, 7:10am UTC](https://forums.percona.com/t/why-does-the-size-of-the-xtraback-docker-image-grow-so-quickly/38999 "2025-08-07T07:10:45Z")
tag 8.3 is less than 200MB, while tag 8.4 is close to 400MB, doubling in size. when I pulled to local, the image is more than 1.4G. --- ## [Can't make backup jobs and pitr work properly](https://forums.percona.com/t/cant-make-backup-jobs-and-pitr-work-properly/38972)
**Author:** [@eprevost](https://forums.percona.com/u/eprevost)\ **Replies:** 9\ **Last updated:** [August 6, 2025, 4:09pm UTC](https://forums.percona.com/t/cant-make-backup-jobs-and-pitr-work-properly/38972 "2025-08-06T16:09:40Z")
I’m testing the XtraDB Operator v.1.17 on a AKS cluster (version 1.33.2). The cluster is running well, but I’m unable to make the backups and PITR to work properly. I deployed MinIO in my cluster to use as S3 compatible… --- ## [VolumeMount in Percona operator Percona XtraDBCluster](https://forums.percona.com/t/volumemount-in-percona-operator-percona-xtradbcluster/38918)
**Author:** [@sid](https://forums.percona.com/u/sid)\ **Replies:** 1\ **Last updated:** [August 6, 2025, 10:24am UTC](https://forums.percona.com/t/volumemount-in-percona-operator-percona-xtradbcluster/38918 "2025-08-06T10:24:04Z")
Description: Trying to use Percona Operator for MySQL but had the following queries: Why is there no spec for “volumeMount“ in pxc? Is it possible to only mount main mysql data directory in percona operator? Dont we pr… --- ## [Is Percona Server Optimized for High-Performance Enterprise Workloads?](https://forums.percona.com/t/is-percona-server-optimized-for-high-performance-enterprise-workloads/38951)
**Author:** [@jonathanjone](https://forums.percona.com/u/jonathanjone)\ **Replies:** 2\ **Last updated:** [August 5, 2025, 4:00am UTC](https://forums.percona.com/t/is-percona-server-optimized-for-high-performance-enterprise-workloads/38951 "2025-08-05T04:00:31Z")
Hey everyone, I’ve been looking into Percona Server and wondering whether it’s well-suited for high-performance workloads, especially on enterprise-grade servers. I know it’s a drop-in replacement for MySQL with some ad… --- ## [The binary installation of Percona-XtraDB-Cluster\_8.0.33 reports an error when starting the second node.](https://forums.percona.com/t/the-binary-installation-of-percona-xtradb-cluster-8-0-33-reports-an-error-when-starting-the-second-node/38888)
**Author:** [@iconvnet\_iconvnet](https://forums.percona.com/u/iconvnet_iconvnet)\ **Replies:** 14\ **Last updated:** [August 4, 2025, 8:28am UTC](https://forums.percona.com/t/the-binary-installation-of-percona-xtradb-cluster-8-0-33-reports-an-error-when-starting-the-second-node/38888 "2025-08-04T08:28:53Z")
2025-07-30T09:49:43.527627Z 0 \[Note\] \[MY-000000\] \[Galera\] Flow-control interval: \[141, 141\] 2025-07-30T09:49:43.527636Z 0 \[Note\] \[MY-000000\] \[Galera\] Shifting OPEN → PRIMARY (TO: 4) 2025-07-30T09:49:43.527903Z 1 \[Note\]… --- ## [Percona mysql 8.4 audit log filter component log rotation using logrotate](https://forums.percona.com/t/percona-mysql-8-4-audit-log-filter-component-log-rotation-using-logrotate/38896)
**Author:** [@Charly\_Wu](https://forums.percona.com/u/Charly_Wu)\ **Replies:** 2\ **Last updated:** [August 1, 2025, 6:34am UTC](https://forums.percona.com/t/percona-mysql-8-4-audit-log-filter-component-log-rotation-using-logrotate/38896 "2025-08-01T06:34:15Z")
Hi, I would like to use logrotate to perform log rotation of audit log generated by Percona’s audit log filter component (MySQL 8.4). when the format is set to JSON, I notice the file begins with ‘\[‘ which indicate tha… --- ## [Does mysql client validate the CA chain?](https://forums.percona.com/t/does-mysql-client-validate-the-ca-chain/38893)
**Author:** [@chris-card](https://forums.percona.com/u/chris-card)\ **Replies:** 2\ **Last updated:** [July 31, 2025, 3:52pm UTC](https://forums.percona.com/t/does-mysql-client-validate-the-ca-chain/38893 "2025-07-31T15:52:04Z")
I am running Percona Server 5.7.35-38 and using the mysql client from Percona-Server-client-57-5.7.35-38.1.el8.x86\_64. I have created a user which requires ssl and configured the server with server certificate, key and c… --- ## [Audit\_log\_filter (8.4): How to capture queries + user in one entry](https://forums.percona.com/t/audit-log-filter-8-4-how-to-capture-queries-user-in-one-entry/38875)
**Author:** [@sbstnpl](https://forums.percona.com/u/sbstnpl)\ **Replies:** 3\ **Last updated:** [July 30, 2025, 10:50am UTC](https://forums.percona.com/t/audit-log-filter-8-4-how-to-capture-queries-user-in-one-entry/38875 "2025-07-30T10:50:13Z")
Hello everbody, we are currently migrating from 8.0 to 8.4 and therefore need to switch from the legacy Audit Log Plugin to modern Audit Log Filter Component. And although the component is much better and can do more, … --- ## [Prepare seems to fail](https://forums.percona.com/t/prepare-seems-to-fail/38877)
**Author:** [@rsodhia](https://forums.percona.com/u/rsodhia)\ **Replies:** 2\ **Last updated:** [July 29, 2025, 3:15pm UTC](https://forums.percona.com/t/prepare-seems-to-fail/38877 "2025-07-29T15:15:29Z")
I’m using a modified version of the command given in the documentation to create and prepare a backup: docker run --rm --name "$backup\_container\_name" \\ --volumes-from "$db\_container" \\ -v "$volume\_name":/backup… --- ## [Restoring DB is resulting in errors](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852)
**Author:** [@rsodhia](https://forums.percona.com/u/rsodhia)\ **Replies:** 2\ **Last updated:** [July 28, 2025, 2:53pm UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852 "2025-07-28T14:53:03Z")
I’m testing using XtraBackup, and while I’m able to take a backup, restoring the backup isn’t working as I’d expect. As per the docs, I’m running the following to create the backup: docker run --rm --name pxb \\ --volu… --- ## [Connecting XtraBackup in docker to a container running in compose](https://forums.percona.com/t/connecting-xtrabackup-in-docker-to-a-container-running-in-compose/38780)
**Author:** [@rsodhia](https://forums.percona.com/u/rsodhia)\ **Replies:** 5\ **Last updated:** [July 25, 2025, 3:03pm UTC](https://forums.percona.com/t/connecting-xtrabackup-in-docker-to-a-container-running-in-compose/38780 "2025-07-25T15:03:22Z")
I’m running a MySQL instance in compose, with port 3306 exposed. I’m trying to figure out how I can use XtraBackup via docker to connect to the container. I’m running: docker run --name pxb --volumes-from gpv1-mysql -v … --- ## [Signal 11 happened when I use 'SET PERSIST ONLY character ~'](https://forums.percona.com/t/signal-11-happened-when-i-use-set-persist-only-character/27289)
**Author:** [@DongyeongKim](https://forums.percona.com/u/DongyeongKim)\ **Replies:** 5\ **Last updated:** [July 25, 2025, 6:26am UTC](https://forums.percona.com/t/signal-11-happened-when-i-use-set-persist-only-character/27289 "2025-07-25T06:26:13Z")
During the set persist only syntax execution, the DB is terminated with Signal 11 error as shown below. What is the problem with that bug? #!/bin/bash mysql -uawx -p -e "SET PERSIST\_ONLY character\_set\_client = 'utf8mb… --- ## [Setup replication using mysqldump. Restore getting "Access to system schema 'mysql' is rejected."](https://forums.percona.com/t/setup-replication-using-mysqldump-restore-getting-access-to-system-schema-mysql-is-rejected/31229)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 3\ **Last updated:** [July 25, 2025, 4:29am UTC](https://forums.percona.com/t/setup-replication-using-mysqldump-restore-getting-access-to-system-schema-mysql-is-rejected/31229 "2025-07-25T04:29:10Z")
Hi, I was trying to sync a standby database using mysqldump. Dumped using “mysqldump --all-databases --master-data” Running the restore I hit “ERROR 3552 (HY000) at line 48031: Access to system schema ‘mysql’ is reje… --- ## [Xtrabackup for redhat 7](https://forums.percona.com/t/xtrabackup-for-redhat-7/38816)
**Author:** [@ronnels](https://forums.percona.com/u/ronnels)\ **Replies:** 2\ **Last updated:** [July 25, 2025, 3:57am UTC](https://forums.percona.com/t/xtrabackup-for-redhat-7/38816 "2025-07-25T03:57:49Z")
Hello, Seems like there is no xtrabackup 8.4.3 Linux Generic Code for RedHat 7. Are you planning to build one or redhat 7 is no longer supported? --- ## [\[ERROR\] \[MY-012800\] \[InnoDB\] \[FATAL\] Unknown error code 21: Skip locked records](https://forums.percona.com/t/error-my-012800-innodb-fatal-unknown-error-code-21-skip-locked-records/25843)
**Author:** [@Pavlo\_Tkachenko](https://forums.percona.com/u/Pavlo_Tkachenko)\ **Replies:** 5\ **Last updated:** [July 24, 2025, 5:35pm UTC](https://forums.percona.com/t/error-my-012800-innodb-fatal-unknown-error-code-21-skip-locked-records/25843 "2025-07-24T17:35:26Z")
we have a cluster with 3 nodes, but recently it crashes with the following error logs: 2 nodes crash with this error and the cluster stops accepting requests. 2023-10-10T23:20:02.208122Z 703 \[ERROR\] \[MY-012800\] \[InnoDB… --- ## [Minimum version of 8.0 that can be upgraded to 8.4?](https://forums.percona.com/t/minimum-version-of-8-0-that-can-be-upgraded-to-8-4/38718)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 6\ **Last updated:** [July 23, 2025, 2:30pm UTC](https://forums.percona.com/t/minimum-version-of-8-0-that-can-be-upgraded-to-8-4/38718 "2025-07-23T14:30:35Z")
Does anyone know of the minimum version of 8.0 that can be upgraded to 8.4? Just checked one of our databases and says version 8.0.21 to 8.4 is not supported. I have a few other db that I want to upgrade with different… --- ## [Getting weird warnings on mysql upgrade checker 8.4 "references a non unique key"](https://forums.percona.com/t/getting-weird-warnings-on-mysql-upgrade-checker-8-4-references-a-non-unique-key/38406)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 4\ **Last updated:** [July 23, 2025, 2:24pm UTC](https://forums.percona.com/t/getting-weird-warnings-on-mysql-upgrade-checker-8-4-references-a-non-unique-key/38406 "2025-07-23T14:24:38Z")
Hi, Getting a weird warning when running the mysql upgrade checker to 8.4 I’m getting several errors on foreign keys referencing a primary key on a single table. alfresco\_up.fk\_alf\_store\_root - invalid foreign key def… --- ## [PMM Not Showing Aurora MySQL Queries in Query Analytics](https://forums.percona.com/t/pmm-not-showing-aurora-mysql-queries-in-query-analytics/38663)
**Author:** [@Orel\_Bello](https://forums.percona.com/u/Orel_Bello)\ **Replies:** 4\ **Last updated:** [July 21, 2025, 4:15pm UTC](https://forums.percona.com/t/pmm-not-showing-aurora-mysql-queries-in-query-analytics/38663 "2025-07-21T16:15:12Z")
Hi all, I’m trying to monitor an Amazon Aurora MySQL database using Percona PMM 2.44.1. I’ve successfully connected the instance and see basic metrics on the dashboards, but nothing is showing up in Query Analytics. He… --- ## [Audit\_log\_filter with version 8.0](https://forums.percona.com/t/audit-log-filter-with-version-8-0/38739)
**Author:** [@dba\_S4dscjz](https://forums.percona.com/u/dba_S4dscjz)\ **Replies:** 2\ **Last updated:** [July 19, 2025, 4:50pm UTC](https://forums.percona.com/t/audit-log-filter-with-version-8-0/38739 "2025-07-19T16:50:10Z")
Hello dear community, Once again we have a question about audit\_log\_filter. This time we use the version for Percona MySQL 8.0 Audit Log Filter overview - Percona Server for MySQL First in the doc there is no page expl… --- ## [8.4 Audit items Install/Upgrade](https://forums.percona.com/t/8-4-audit-items-install-upgrade/38706)
**Author:** [@meyerder](https://forums.percona.com/u/meyerder)\ **Replies:** 3\ **Last updated:** [July 18, 2025, 8:28pm UTC](https://forums.percona.com/t/8-4-audit-items-install-upgrade/38706 "2025-07-18T20:28:43Z")
Ok so I am struggling here.. Current setup and following various docs that I have found on the site Right Now a 3 Node Xdb cluster running 8.0.x Attempting a rolling upgrade from 8.x to 8.4 Backups made Shutdown one … --- ## [Full Cluster Crash During Network Failover – Same Behavior on AWS and On-Prem](https://forums.percona.com/t/full-cluster-crash-during-network-failover-same-behavior-on-aws-and-on-prem/38708)
**Author:** [@Israel\_Vinitzer](https://forums.percona.com/u/Israel_Vinitzer)\ **Replies:** 1\ **Last updated:** [July 18, 2025, 3:42pm UTC](https://forums.percona.com/t/full-cluster-crash-during-network-failover-same-behavior-on-aws-and-on-prem/38708 "2025-07-18T15:42:58Z")
Hi Percona team, We are facing a critical issue with Percona XtraDB Cluster (PXC) version 8.0.41-32.1 in both on-prem and AWS environments. Infrastructure: 3-node Kubernetes cluster, version v1.32.5, deployed using Ku… --- ## [Mysqlbinlog not updating database for PITR](https://forums.percona.com/t/mysqlbinlog-not-updating-database-for-pitr/38720)
**Author:** [@emaN\_yalpsiD](https://forums.percona.com/u/emaN_yalpsiD)\ **Replies:** 6\ **Last updated:** [July 18, 2025, 2:51pm UTC](https://forums.percona.com/t/mysqlbinlog-not-updating-database-for-pitr/38720 "2025-07-18T14:51:44Z")
I’m running Percona MySQL 8.0.42-33 on RHEL 9.6. I have a problem when attempting point-in-time-recovery, where I can restore the database from the mysqldump backup, but the application of the binlog isn’t updating anyt… --- ## [What reason to store binlog files to xtrabackup backup](https://forums.percona.com/t/what-reason-to-store-binlog-files-to-xtrabackup-backup/38712)
**Author:** [@yuskovich\_alexey](https://forums.percona.com/u/yuskovich_alexey)\ **Replies:** 1\ **Last updated:** [July 18, 2025, 4:48am UTC](https://forums.percona.com/t/what-reason-to-store-binlog-files-to-xtrabackup-backup/38712 "2025-07-18T04:48:04Z")
Hello There are two files in xtrabackup backup: mysql-bin.002103 mysql-bin.index What reason xtrabackup store them in backup? Is it safe to delete them? If not, why? My Mysql binlog directory not same, as database … --- ## [How does rotation of the root CA handled if performed by cert-manager?](https://forums.percona.com/t/how-does-rotation-of-the-root-ca-handled-if-performed-by-cert-manager/38653)
**Author:** [@Andrea\_Dolfi](https://forums.percona.com/u/Andrea_Dolfi)\ **Replies:** 2\ **Last updated:** [July 16, 2025, 6:26pm UTC](https://forums.percona.com/t/how-does-rotation-of-the-root-ca-handled-if-performed-by-cert-manager/38653 "2025-07-16T18:26:57Z")
Hello everyone, I have a doubt related to certificates rotation, specifically to the root CA rotation. I’ve read the documentation on transport encryption The doc states the following: If a cert-manager is used, it… --- ## [Nodes got aborted one by one when creating/droping index](https://forums.percona.com/t/nodes-got-aborted-one-by-one-when-creating-droping-index/38654)
**Author:** [@hung\_le](https://forums.percona.com/u/hung_le)\ **Replies:** 2\ **Last updated:** [July 16, 2025, 6:39pm UTC](https://forums.percona.com/t/nodes-got-aborted-one-by-one-when-creating-droping-index/38654 "2025-07-16T18:39:15Z")
Hi all, I’m having a 3 nodes Cluster. mysql\> SHOW VARIABLES LIKE ‘version%’; ±------------------------±--------------------------------------------------------------------------------------+ | Variable\_name … [Previous page](https://forums.percona.com/c/mysql-mariadb/36.md?page=7) [Next page](https://forums.percona.com/c/mysql-mariadb/36.md?page=9)