Datatanode starts slow as it is unable to use LCP to restore data
(Doc ID 2223767.1)
Last updated on APRIL 05, 2019
Applies to:MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.
In a cluster all nodes except one take normal time for start up, all start phases are executed more or less in parallel. But one node completes start phase 2 only after all the nodes reached the "started" state.
Having a cluster with 4 datanodes, 3 of the datanodes starting up very quickly (aprox. 30 minutes) all stat phases executed more or less in parallel. The 4th (nodeid=6) node completing Start phase 2 only after all the nodes reached the "started" state.
In the problematic node out log the following entries may be seen:
Looks like the datanode was not restored from LCP/REDO log, but by copying fragments from other nodes.
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