I have already posted some time ago a post related to the same topic (see here). Today, I want to explain the easiest way to create an asynchronous replica from an existing MySQL instance, that this time has already data !
Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post). The most complicated part to deal with was the existing and none existing data. In fact GTID sets must be compatible. Let me explain that with some examples: Example 1 … Read More