Thu, 11 Apr 2024 23:14:57 +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/comprehensive-insights-into-sdi-in-mysql-8-0/ https://www.percona.com/blog/comprehensive-insights-into-sdi-in-mysql-8-0/#respond Fri, 13 Oct 2023 12:06:18 +0000 https://www.percona.com/blog/?p=91447 A common practice among DBAs and developers is to copy table data and .frm files from the data dictionary. They often set up batch jobs to automate the recovery of these tables. This capability is also utilized in disaster recovery scenarios, where individuals well-versed in .frm files can reconstruct their metadata as needed.In MySQL 8.0, […]]]> https://www.percona.com/blog/comprehensive-insights-into-sdi-in-mysql-8-0/feed/ 0 91447 https://www.percona.com/blog/securely-replicate-your-data-and-restrict-replication-to-row-based-events-in-mysql/ https://www.percona.com/blog/securely-replicate-your-data-and-restrict-replication-to-row-based-events-in-mysql/#respond Tue, 21 Mar 2023 13:25:17 +0000 https://www.percona.com/blog/?p=86260 In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s).The replica doesn’t have checking capabilities when processing replicated transactions as of MySQL 8.0.18. It does this to carry out […]]]> https://www.percona.com/blog/securely-replicate-your-data-and-restrict-replication-to-row-based-events-in-mysql/feed/ 0 86260 https://www.percona.com/blog/useful-gtid-feature-for-migrating-to-mysql-gtid-replication-assign_gtids_to_anonymous_transactions/ https://www.percona.com/blog/useful-gtid-feature-for-migrating-to-mysql-gtid-replication-assign_gtids_to_anonymous_transactions/#comments Wed, 28 Dec 2022 14:19:48 +0000 https://www.percona.com/blog/?p=84336 In managed services, we get requests to migrate from traditional to GTID-based replication. However, the customer does not want to first enable the GTID on the source node (production). Before MySQL 8.0.23, replication from the disabled GTID source to an enabled GTID replica was impossible.In this blog, I will talk about a new MySQL feature […]]]> https://www.percona.com/blog/useful-gtid-feature-for-migrating-to-mysql-gtid-replication-assign_gtids_to_anonymous_transactions/feed/ 1 84336 https://www.percona.com/blog/mysql-data-archival-with-minimal-disruption/ https://www.percona.com/blog/mysql-data-archival-with-minimal-disruption/#respond Tue, 29 Nov 2022 15:01:06 +0000 https://www.percona.com/blog/?p=83740 We all know that data is important, and some businesses need historical data to be available all the time. The problem is that queries on large tables perform poorly if they are not properly optimized. We get many customer requests in Managed Services to purge/archive large tables, and to achieve it, we use pt-archiver.Recently, we […]]]> https://www.percona.com/blog/mysql-data-archival-with-minimal-disruption/feed/ 0 83740