Launch a Single Node Analytics Topology

Overview

These instructions detail service launch using the SkySQL Portal.

Alternatively, SkySQL services can be launched using the SkySQL DBaaS API.

About this Topology

Single Node Analytics:

  • Designed for cloud data warehousing

  • Single-node configuration for dev/test workloads

  • Runs on MariaDB Enterprise Server

  • Available on AWS and GCP

  • Configured to use the MariaDB Enterprise ColumnStore storage engine

  • Backed by scalable object storage

For additional information, see "Single Node Analytics".

Registering for SkySQL

Launching a SkySQL database service, requires setting up an account:

  1. Register for a MariaDB ID or log in to your MariaDB ID account.

Launch Single Node Analytics Services

Cloud provider, instance size, region, software version, storage size, and topology are selected from available defaults at time of service launch. Options can augment the default service experience.

To launch a Single Node Analytics database service:

  1. Log in to the SkySQL Portal.

  2. Click on the "+ Launch new service" button (center of page if you have no services, upper-right if you have services).

  3. Select the "Analytics" radio button.

  4. Select the "Single Node" radio button.

  5. Choose the desired cloud provider.

  6. Choose the desired region.

  7. Select the desired instance size.

  8. Analytics instances are provisioned with 100 GB of transactional storage. Object storage is not pre-provisioned.

  9. Select the desired MariaDB Enterprise ColumnStore software version.

  10. Optionally, select a Maintenance Window.

  11. Enter a valid service name.

  12. Estimated Service Cost is shown based on selected parameters.

  13. Click the "Launch service" button.

The launch interface may place limits on the number of database services which can be launched. Please contact SkySQL Support if you require additional services.

Service Naming Rules

Each MariaDB SkySQL service launched has a customer-defined service name. These rules apply to those service names:

  • Service names can contain lowercase alphanumeric characters and hyphens.

  • A hyphen cannot be the last character.

  • The first character must be a letter.

  • The minimum service name length is 2 characters.

  • The maximum service name length is 24 characters.

  • Duplicate service names are not permitted.

    • Service names must be unique to the user.

    • When on a SkySQL Team service name must be unique to the team.