Wed.Dec 28, 2022

article thumbnail

A Useful GTID Feature for Migrating to MySQL GTID Replication – ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS

Percona

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 introduced in 8.0.23, which allows MySQL to replicate from a GTID-disabled source to GTID-enabled replica.

Servers 66
article thumbnail

How to Optimize Cost and Reduce Risks in Application Modernization?

Simform

Organizations mainly want to modernize apps for better performance, scalability, and security. But it’s natural to get daunted by the required expenses. Here's everything you should know to save big on costs and avoid the risks on the way.

article thumbnail

Impact of DDL Operations on Aurora MySQL Readers

Percona

Recently I came across an interesting investigation about long-running transactions getting killed on an Aurora Reader instance. In this article, I will explain why it is advisable to avoid long-running transactions on Aurora readers when executing frequent DDL operations on the Writer, or at least be aware of how a DDL can impact your Aurora readers.

Storage 94