Launch a Distributed Transactions Topology
These instructions detail service launch using the SkySQL Portal.
Alternatively, SkySQL services can be launched using the SkySQL DBaaS API.
About this Topology
Designed for linear read/write scaling of transactional workloads
Runs on MariaDB Xpand
Available on AWS and GCP
Backed on AWS by EBS Provisioned IOPS SSD storage
Backed on GCP by Zonal SSD Persistent Disk storage
For additional information, see "Distributed Transactions".
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 Distributed Transactions 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 Distributed Transactions 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 "Transactions" radio button.
Select the "Distributed" radio button.
Choose the desired cloud provider.
Choose the desired region.
Select the desired instance size.
Select the desired number of Xpand nodes.
Optionally, enable MaxScale Redundancy. This option is available on Distributed Transactions services launched with 3 or more Xpand nodes. If enabled, select the desired number of MaxScale instances and select the desired MaxScale instance size.
Select the desired storage size.
For AWS, choose Provisioned IOPS per GB.
Select the desired MariaDB Xpand 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.