My Oracle Support Banner

InnoDB Cluster Point In Time Recovery without Losing Production Applications (Doc ID 2654158.1)

Last updated on MARCH 30, 2020

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
Scenario is that important data has been deleted from an InnoDB Cluster and needs to be returned e.g. money transactions.
However, since it is also an important production cluster, the preferred downtime is zero, rather than any maintenance window.

Goal

Do a point-in-time-recovery on an active, production InnoDB Cluster to restore lost data.
There is to be minimal downtime, preferably zero, but allow the nodes to be restored to the previous night's backup of the data.

Solution

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
Goal
Solution
References

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