Is Warm-Up after Cloning Required? (Doc ID 2939108.1)

Last updated on AUGUST 24, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.