Triggers on SQL Nodes Can Be Lost After Restoring Data Using ndb_restore Command On MySQL NDB Cluster (Doc ID 3000143.1)

Last updated on JANUARY 30, 2024

Applies to:

MySQL NDB Cluster - Version 8.0 and later
Information in this document applies to any platform.

After restoring data using ndb_restore command on MySQL NDB Cluster, triggers on SQL Nodes may be lost. The procedure of restoration is like below:

Assume you have a valid native backup
Assume some NDB tables have triggers
Stop SQL nodes
Stop data nodes
Restart data nodes using --initial option (this option will wipe data on data nodes)
Enter the single user mode (optional)
Restore a backup using ndb_restore command
Exit the single user mode (optional)
Start SQL nodes
You'll find some triggers on NDB tables are lost

	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

Symptoms

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