Is Warm-Up after Cloning Required?
(Doc ID 2939108.1)
Last updated on AUGUST 24, 2023
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Goal
Cloning using the clone plugin is a very handy way to synchronize the server data between two instances. This technique is often used when setting up various replication topology such as asynchronous replication, Group Replication, InnoDB ReplicaSet, InnoDB Cluster, and InnoDB Cluster Read Replicas. The clone plugin synchronizes data, however, what about the buffer pool cache content? Warning up the cache (reading data from disk onto the cache) is very important for query performance. Without warming up the cache, data must be read from disk upon row access. This often causes random access to disk, which performs very slow.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |