Efficient CDP solution with instantaneous point-in-time recovery for MySQL

Ask any DBA what are his top priorities for backup of MySQL. Chances are that hot backup and recovery to a specific point-in-time (or transaction) will be on top of everybody’s list.

The recovery to any point-in-time has been always an ultimate goal for data protection. Traditional backup solutions allow recovering only to a point in time when the last backup took place, e.g. last night. A lot of new data could be created and lost since that last backup. That is why in the last several years many vendors have been working on Continuous Data Protection (CDP).

Storage Networking Industry Association (SNIA) defines Continuous Data Protection (CDP) as “a class of mechanisms that continuously capture or track data modifications enabling recovery to previous points in time”.

ZRM 2.2 enables CDP by using LVM, VxFS, VSS, ZFS and NetApp snapshots in conjunction with MySQL transaction logs. When doing a recovery to a particular point in time, ZRM reads data from the snapshot and then replays MySQL transaction log from that point forward. This enables almost instantaneous point-in-time recovery.

ZRM CDP diagram

For each point in time T, ZRM creates a snapshot that includes a MySQL binary log. To recover MySQL database to a specific Recovery Point Objective (RPO) between T2 and T3, ZRM reads data from snapshot T2 and replays transactions from binlog T3 up to RPO providing the user with point-in-time recovery. To enable instantaneous recovery snapshots are stored where the database files are, for example, on the same NetApp filer.

Since real life recoveries are performed under stressful conditions, we designed our product to simplify your life and ensure successful recovery:

  • With a single click you can initiate point-in-time recovery that reads data from the snapshot and replays transactions so you get your database back in time.
  • Our unified recovery mechanism allows the very same recovery workflow not just for snapshots, but for all other backup methods such as logical and raw backup. The unified recovery works even with third party data extraction utilities for MySQL such as InnoDB HotBackup.
  • ZRM allows recovery to any point in time for multiple MySQL servers in the organization. MySQL servers could have different storage engines and run on different operating systems and all backup and recovery operations are centrally managed by ZRM.

Some CDP solutions capture all writes to the database effectively duplicating what a binary log is designed to do. Why re-invent the wheel and waste computing resources? ZRM is integrated with MySQL on a deeper level than any other backup solution. That allows us to provide very efficient CDP solution with almost instantaneous point-in-time recovery.

——
Dmitri Joukovski

Comments are closed.