by Larry Xia | Mar 29, 2024 | Insight for DBAs, MySQL
At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The... by Larry Xia | Dec 12, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s... by Larry Xia | Sep 15, 2023 | Insight for DBAs, MariaDB, MySQL
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and... by Larry Xia | Jun 15, 2023 | Insight for DBAs, MySQL, Percona Software
Sometimes we might need to install/upgrade Percona Server for MySQL/MySQL 8 to a particular version in a test or production environment. The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to... by Larry Xia | Mar 13, 2023 | Insight for DBAs, MySQL, Percona Software
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica.This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server... by Larry Xia | Nov 14, 2022 | Insight for DBAs, MySQL
At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning.We could get the LATEST DETECTED DEADLOCK from SHOW ENGINE INNODB STATUSG: Shell …....