Launch a Single Node Analytics Topology
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:
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:
Log in to the SkySQL Portal.
Click on the "+ Launch new service" button (center of page if you have no services, upper-right if you have services).
Select the "Analytics" radio button.
Select the "Single Node" radio button.
Choose the desired cloud provider.
Choose the desired region.
Select the desired instance size.
Analytics instances are provisioned with 100 GB of transactional storage. Object storage is not pre-provisioned.
Select the desired MariaDB Enterprise ColumnStore software version.
Optionally, select a Maintenance Window.
Enter a valid service name.
Estimated Service Cost is shown based on selected parameters.
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.