How to Launch a HA (Primary/Replica) Topology
MariaDB Platform for Transactions in HA (Primary/Replica) topology on MariaDB SkySQL:
Designed for mission-critical workloads
Runs on MariaDB Enterprise Server
Available on AWS, GCP
Configured to use the InnoDB storage engine and MariaDB Replication for asynchronous or semi-synchronous replication
Backed by EBS Provisioned IOPS SSD on AWS, Zonal SSD Persistent Disk storage on GCP
Available with one Primary and 1 to 5 Replicas for high availability and read scaling
Registering for SkySQL
Launching a SkySQL database service, requires setting up an account:
Launch HA (Primary/Replica) Services
To launch a HA (Primary/Replica) database service:
Log in to the SkySQL Portal.
Click on the "Launch Service" link in the main menu (left navigation).
Click on the "Launch" button under the "Transactions" description.
If have you already launched services, you can also launch services from the "Services" page using the "Launch New Service" button.
On the MariaDB Platform for Transactions view, specify the database service parameters by choosing:
Click on the "Launch Service" button. You'll be taken to the "Services" page and will see that your new service has a "Pending" status.
Click on your database service name and whitelist the IP addresses of the systems that will be allowed access to the service. Addresses can be whitelisted while the service is "Pending".
You can connect to the database service when it has a "Healthy" status. Click the "Show Credentials" button for connection information.
"Show Credentials" and "Delete Service" buttons are not available in the Service Details view until service launch completes.
Until a use and payment history is established, a customer can create up to six database services. If a customer is part of a team, the team can create up to six database services per team member. Please create a support case 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 alphanumeric characters and hyphens, but a hyphen cannot be the last character.
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.