As MemSQL Helios manages its own clusters, customers are only responsible for managing data and performing data-related tasks, including:
- Database configuration
- Schema design and implementation
- Index and query tuning
- Extract, transform, load (ETL)
- User creation and permission assignment
- Making requests for restoring backups
- Making requests for increasing or decreasing cluster capacity
The default MemSQL Helios Admin user permissions include:
CREATE TEMPORARY TABLES,
ALTER PIPELINE, and
The following are some examples of how you can use MemSQL Studio to interact with your cluster.
Create a Database
Use the SQL Editor in MemSQL Studio to create a new database by entering and running the
CREATE DATABASE command.
For an example of how to use MemSQL Pipelines to load a large dataset, see our Data Ingest guide.
Back Up Data
MemSQL Helios makes daily backups of all clusters and retains them for seven (7) days. While you can initiate your own backups, you cannot restore them to your cluster.
If a cluster backup needs to be restored, file a support ticket and MemSQL will restore the latest backup.