Datatanode starts slow as it is unable to use LCP to restore data
Last updated on JANUARY 24, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms