MySQL Cluster Point-In-Time Recovery (PITR) (Doc ID 1024140.1)

Last updated on APRIL 09, 2017

Applies to:

MySQL Cluster - Version 4.1 and later
All Platforms

Goal

If you're using MySQL Cluster and want to restore data from a specific point-in-time after the last backup of a database, you can do so by replaying binary log entries from the last backup up until a specified point in time.

The data restoration covered in this article only involves MySQL Cluster. It does not cover other storage engines.

Important Note: All NDB tables must have a primary key defined or this procedure will not work as expected.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms