SingleStore Managed Service

Import and Backup
How do I load data into SingleStore Managed Service?

The easiest way to get data into SingleStore Managed Service is by uploading your dataset to Amazon S3 or Google Cloud Storage and using SingleStore Pipelines to ingest your data quickly. Get started now.

How can I import data from MySQL, Postgres, MS-SQL etc?

Refer to Load Data for more information.

How are backups managed?

SingleStore performs daily backups on all data.

You may also manually back up your data. Refer to Back Up and Restore Data for more information.

How can I backup a SingleStore DB database?

SingleStore DB supports consistent, online, cluster-wide BACKUP and RESTORE operations that do not require blocking write operations on the database like mysqldump does. See Back Up and Restore Data for more information.

How can I easily copy a table?

You can use CREATE TABLE dest AS SELECT * FROM source. See CREATE TABLE.

Or, create a new empty table using the schema of the original table from SHOW CREATE TABLE source and copy data from source table into the new table using INSERT INTO dest SELECT * FROM source.

How can I easily copy a database?

Available options include:

  • BACKUP the database and RESTORE it on the same (or a different) cluster under a different name.

Where are the important data files (recovery log, binary logs, snapshots, data files etc)?

Run SHOW STATUS EXTENDED LIKE '%_directory' to get the full paths.