Sat, 17 Feb 2024 00:55:29 +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/resolving-data-drift-in-a-dual-primary-topology-with-replica/ https://www.percona.com/blog/resolving-data-drift-in-a-dual-primary-topology-with-replica/#respond Tue, 31 Oct 2023 13:06:21 +0000 https://www.percona.com/blog/?p=90537 Hello friends,In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time.This time, I’m going to tell you about a particular case: a client with a dual-primary topology plus a replica, as detailed below: [crayon-664c90c9d5b30972608733/] [RW] means Read/Write access. [R] means Read […]]]> https://www.percona.com/blog/resolving-data-drift-in-a-dual-primary-topology-with-replica/feed/ 0 90537 https://www.percona.com/blog/migrating-from-on-prem-to-rds-mysql-aurora-definers-is-the-answer/ https://www.percona.com/blog/migrating-from-on-prem-to-rds-mysql-aurora-definers-is-the-answer/#respond Tue, 01 Aug 2023 12:00:39 +0000 https://www.percona.com/blog/?p=89632 Hello friends! If you plan to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS), you usually don’t have much choice but to do so using logical backups such as mysqldump, mysqlpump, mydumper, or similar. (Actually, you could do a physical backup with Percona XtraBackup to S3, but given that it […]]]> https://www.percona.com/blog/migrating-from-on-prem-to-rds-mysql-aurora-definers-is-the-answer/feed/ 0 89632 https://www.percona.com/blog/migrating-from-mariadb-to-percona-server-for-mysql-8-security https://www.percona.com/blog/migrating-from-mariadb-to-percona-server-for-mysql-8-security#comments Thu, 01 Jun 2023 12:36:48 +0000 https://www.percona.com/blog/?p=88252 Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem.In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. A comment worth clarifying is that, […]]]> https://www.percona.com/blog/migrating-from-mariadb-to-percona-server-for-mysql-8-security/feed/ 2 88252 https://www.percona.com/blog/purging-data-when-the-table-is-big-and-has-children-tables/ https://www.percona.com/blog/purging-data-when-the-table-is-big-and-has-children-tables/#respond Fri, 03 Mar 2023 13:04:53 +0000 https://www.percona.com/blog/?p=85715 Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer.A few days ago, a client asked us the following question: “Hey Percona, I have a question and a problem simultaneously: I want to delete […]]]> https://www.percona.com/blog/purging-data-when-the-table-is-big-and-has-children-tables/feed/ 0 85715 https://www.percona.com/blog/what-if-the-user-exists-on-the-replica-and-not-in-the-primary-or-any-other-objects/ https://www.percona.com/blog/what-if-the-user-exists-on-the-replica-and-not-in-the-primary-or-any-other-objects/#respond Thu, 03 Nov 2022 13:11:41 +0000 https://www.percona.com/blog/?p=83427 Hey folks,This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of our blogs is not limited to DBAs but includes a broader range of IT professionals, such as sysadmins, help desk employees, NOC operators, and developers as well.Sometimes people (and also some DBAs, why not?) may accidentally […]]]> https://www.percona.com/blog/what-if-the-user-exists-on-the-replica-and-not-in-the-primary-or-any-other-objects/feed/ 0 83427 https://www.percona.com/blog/mysql-compression-indexes-and-two-smoking-barrels/ https://www.percona.com/blog/mysql-compression-indexes-and-two-smoking-barrels/#comments Fri, 08 Jul 2022 12:20:41 +0000 https://www.percona.com/blog/?p=81613 Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit.Now, what happens when that doesn’t happen?In this simple blog, I’m going to show you something interesting that happens when you try to transition from a compressed table […]]]> https://www.percona.com/blog/mysql-compression-indexes-and-two-smoking-barrels/feed/ 2 81613 https://www.percona.com/blog/streaming-mysql-backups-with-percona-xtrabackup-another-alternative/ https://www.percona.com/blog/streaming-mysql-backups-with-percona-xtrabackup-another-alternative/#comments Fri, 08 Jan 2021 18:14:55 +0000 https://www.percona.com/blog/?p=73574 Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility.  What is the difference with many others existing on the web?  Not many, but they are interesting in terms of performance and availability.We will combine the xbstream utility with the power of pigz […]]]> https://www.percona.com/blog/streaming-mysql-backups-with-percona-xtrabackup-another-alternative/feed/ 2 73574