Launch a Replicated Transactions 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

Replicated Transactions topology on MariaDB SkySQL:

  • Designed for mission-critical workloads

  • Runs on MariaDB Enterprise Server

  • Available on AWS and GCP

  • Configured to use the InnoDB storage engine and MariaDB Replication for asynchronous or semi-synchronous replication

  • Backed on AWS by EBS Provisioned IOPS SSD storage

  • Backed on GCP by Zonal SSD Persistent Disk storage

For additional information, see "Replicated Transactions".

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 Replicated 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 Replicated Transactions 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 "Transactions" radio button.

  4. Select the "Replicated" radio button.

  5. Choose the desired cloud provider.

  6. Choose the desired region.

  7. Select the desired instance size.

  8. Select the desired replica count.

  9. Optionally, enable MaxScale Redundancy. If enabled, select the desired MaxScale instance size.

  10. Select the desired storage size.

  11. For AWS, choose Provisioned IOPS per GB.

  12. Select the desired MariaDB Enterprise Server software version.

  13. Optionally, select a Maintenance Window.

  14. Enter a valid service name.

  15. Optionally Disable SSL/TLS is available for Transactions services. This option is typically used with AWS PrivateLink or GCP VPC Peering. Understand risks before enabling this option.

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

  17. 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.