Skip to content

Restore from Point-in-Time

Requirements

  • Make sure Cassandra service is stopped on every node in the Cluster/Data Center(DC)
  • Make sure Cassandra commitlog directory is emptied for every node you want to restore too.
  • Check Cassandra Application Keyspace table directories are emptied for every node and keyspace/table you want to restore.

Steps:

In the AxonOps Dashboard on the left hand menu navigate to Operations --> Restore

On the top tab select Point-In-Time Recovery

You will be presented with the Point-In-Time restore screen. There are several steps that need to be done to complete a Point-in-time restore.


Step 1: Select Restore Point-in-time.

Select the Point-In-Time you want to restore your cluster too.

Please complete the Date/Time selection and fields of the keyspace and table/s that you would like to restore.

  • Wide Time Range

    The wide time range is always a calendar month from the 1st to the last day of the selected month.

    To select a different month please use the and arrows on either side of the slider.

    At the beginning and end of the Wide Time Range slider there is a black bar that you can slide left and right to narrow the Date/Time of when you want to restore to.

  • Zoomed Section

    This is a narrower view of the wide selection in the above slider.

    By default if the Wide Time Range slider is 30 days the Zoomed Section will be 30 days.

    The narrower the time range in the Wide Time Range slider the more precise the available date/time selection will be in the Zoomed section.

    Example of what the Zoomed section will look like when snapshots are available to select for PITR.

    The Camera Icon represents a snapshot at a point-in-time where a commitlog is archived.

  • Point in time

    A text based representation of the selection made in the Zoomed section slider. This is an altenative if you want to manually input a specific time.

  • Keyspace(optional)

    The Application or System Keyspaces that were included as part of the commitlog archive process. If you don't specify a Keyspace all Keyspaces will be included in the restore process.

  • Tables(optional)

    The Application or System Tables that were included as part of the commitlog archive process. If you don't specify a Table all Tables will be included in the restore process.

Step 2: Overview of Point-in-time nodes,keyspaces and tables.

Confirm by clicking show details that all the tables and keyspaces you want to restore will be part of the restoration. You will be presented with the following screen.

  • Tables

    Tables to be restored will be highlighted in Green, those to be excluded will be Greyed out. The search box will allow you to search for and confirm specific tables or keyspaces will be restored.

  • Commit Logs

    The last timestamp and file name of the commit log that will be used to recover to the specified point-in-time.

  • Snapshots

    The Snapshot/s that will be used to recover to the specified point-in-time

Step 3: Confirmation of Point-in-time restoration to proceed.

Confirm you are ready to start the Point-in-time restore.

  • Stop Cassandra on the nodes that need to be restored.
  • Delete the SStable files in the target table directories
  • Delete commitlog files in the commitlog directory

Step 4: Final checks and last steps before Point-in-time restore starts.

The Axon-Agent service confirm the Cassandra nodes are stopped. Checks to ensure the clstuer is ready for the Point-in-time restore.

Once you have clicked Check PITR Readiness it will confirm that the Cluster is in the correct state for recovery to proceed.

If any of the data directories still contain sstables a warning may be displayed.

Click on show details button to view the tables affected and any errors/warnings.

Step 5: Start the Point-in-time restore.

Start the restore process

Step 6: Wait for completion and start Cassandra nodes.

The Status page of the Point-in-time restore process. Once the restore has been completed the status will remain in a progressing state until the Cassandra nodes are restarted.

Step 7: Check data in Cassandra has been recovered to specified Point-in-time.

Successful Point-in-time restore. Please confirm the details and data in the tables that have been restored are present as expected.