Fri, 29 Mar 2024 12:56:02 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/myloader-error-when-restoring-databases/ https://www.percona.com/blog/myloader-error-when-restoring-databases/#respond Fri, 29 Mar 2024 12:56:02 +0000 https://www.percona.com/blog/?p=95475 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 automated restore process ran well until one day, we got the error below.0. The error we face […]]]> https://www.percona.com/blog/myloader-error-when-restoring-databases/feed/ 0 95475 https://www.percona.com/blog/how-to-use-percona-toolkits-pt-table-sync-for-replica-tables-with-triggers-in-mysql/ https://www.percona.com/blog/how-to-use-percona-toolkits-pt-table-sync-for-replica-tables-with-triggers-in-mysql/#respond Tue, 12 Dec 2023 15:25:45 +0000 https://www.percona.com/blog/?p=92361 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 pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make […]]]> https://www.percona.com/blog/how-to-use-percona-toolkits-pt-table-sync-for-replica-tables-with-triggers-in-mysql/feed/ 0 92361 https://www.percona.com/blog/convert-mariadb-binary-log-file-and-position-based-replication-to-gtid-replication/ https://www.percona.com/blog/convert-mariadb-binary-log-file-and-position-based-replication-to-gtid-replication/#respond Fri, 15 Sep 2023 11:53:01 +0000 https://www.percona.com/blog/?p=90709 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 position-based replication to GTID replication.In my lab, we have two test nodes; both servers will have […]]]> https://www.percona.com/blog/convert-mariadb-binary-log-file-and-position-based-replication-to-gtid-replication/feed/ 0 90709 https://www.percona.com/blog/how-to-install-or-upgrade-percona-server-for-mysql-mysql-8-to-a-specific-version-on-debian-ubuntu/ https://www.percona.com/blog/how-to-install-or-upgrade-percona-server-for-mysql-mysql-8-to-a-specific-version-on-debian-ubuntu/#respond Thu, 15 Jun 2023 12:32:25 +0000 https://www.percona.com/blog/?p=88549 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 be installed on all database instances in the cluster, regardless of what actually is […]]]> https://www.percona.com/blog/how-to-install-or-upgrade-percona-server-for-mysql-mysql-8-to-a-specific-version-on-debian-ubuntu/feed/ 0 88549 https://www.percona.com/blog/how-to-set-up-mysql-8-replica-from-existing-mysql-5-7-server-with-percona-xtrabackup/ https://www.percona.com/blog/how-to-set-up-mysql-8-replica-from-existing-mysql-5-7-server-with-percona-xtrabackup/#comments Mon, 13 Mar 2023 13:03:40 +0000 https://www.percona.com/blog/?p=86015 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 with Percona XtraBackup.In my […]]]> https://www.percona.com/blog/how-to-set-up-mysql-8-replica-from-existing-mysql-5-7-server-with-percona-xtrabackup/feed/ 1 86015 https://www.percona.com/blog/enable-innodb_print_all_deadlocks-parameter-to-get-all-deadlock-information-in-mysqld-error-log/ https://www.percona.com/blog/enable-innodb_print_all_deadlocks-parameter-to-get-all-deadlock-information-in-mysqld-error-log/#respond Mon, 14 Nov 2022 14:11:08 +0000 https://www.percona.com/blog/?p=83561 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: [crayon-664c8edb7d441817763871/] But how could we view all past deadlock information?We could enable innodb_print_all_deadlocks,  and all deadlocks in InnoDB user transactions will be recorded in the […]]]> https://www.percona.com/blog/enable-innodb_print_all_deadlocks-parameter-to-get-all-deadlock-information-in-mysqld-error-log/feed/ 0 83561