SingleStore DB

CREATE MILESTONE

Note

This command is in preview mode. At a future date, SingleStore will announce when this command will be available for production use.

Prior to using this command, the enable_bottomless and allow_point_in_time_attach engine variables must be set to ON. The default values for enable_bottomless and allow_point_in_time_attach, respectively, are ON and OFF.

Records a milestone, which is a named point to which you can restore an unlimited storage database. Restoring to the milestone will bring the database to the point in time when the milestone was created.

Following the execution of CREATE MILESTONE, the database can be restored at the milestone by running DETACH DATABASE and then ATTACH DATABASE.

Syntax

CREATE MILESTONE [milestone_name] [FOR remote_database_name]

Arguments
milestone_name

A quoted string that is the name of the milestone to create.

Remarks
  • While the milestone is being created, SingleStore uploads the remote database's local cluster data to remote storage that has not yet been synced.

  • If milestone_name is not specified, a name containing the current timestamp is automatically generated.

  • If milestone_name already exists, the restore point used by the existing milestone is overwritten with the restore point of the new milestone.

  • If remote_database_name is not specified, the context database (specified with the USE command) is used.

Example

The following example creates a new milestone on the existing unlimited storage database bottomless_db:

CREATE MILESTONE "m" FOR bottomless_db;

For a basic walkthrough of creating milestones, see Attach an Unlimited Storage Database Using Point-in-Time Recovery (PITR).