Quickstart

Overview

This Quickstart will get you up and running with the SkySQL preview release.

Since this release is a Technical Preview, we encourage you to start by reading "Choosing a SkySQL Release" to confirm this release is right for you. If you need services for a production workload, use the SkySQL current release instead.

If you have any questions along the way, please contact Support.

Workloads and Topologies

SkySQL has options for transactional workloads and analytical workloads.

In this Quickstart, we will deploy a Xpand Distributed SQL service.

These instructions can be adapted if you want to try a different topology.

Key Benefits of SkySQL

  • Unified Portal where you can launch, query, monitor and manage database services

  • Multi-cloud, you can launch SkySQL services on AWS or GCP

  • Managed, SkySQL services include monitoring, upgrades, nightly backups

  • Self-Service Operations to configure, control, and scale your services on-demand

  • Supported by MariaDB Corporation experts and engineers

  • Configurable, with a range of instance sizes and service options

  • Secure by design, with encryption, and support for HIPAA and GDPR

We'll cover some of these features in greater depth later in the Quickstart.

Key Benefits of Xpand Distributed SQL

  • High performance and strong consistency to enable massive workloads

  • Elasticity with automatic and manual scaling to meet workload needs

  • HA and Fault Tolerance, tolerating both single node and single zone failures, automatically healing and protecting data without intervention

  • Xpand Global Replication, enabling replication with Xpand Distributed SQL services in other cloud regions

Supported Languages and Clients

SkySQL services are compatible with most modern programming languages and clients which can connect to MariaDB databases or MySQL databases.

$500 Trial Credit

SkySQL has pay-as-you-go pricing, but we want to make it even easier for you to test SkySQL.

First-time users receive a $500 trial credit.

Step 1: Register for SkySQL

To launch a database service on SkySQL, you need a MariaDB ID account. The MariaDB ID account is free. You can use social login, or a traditional email/password.

Register for a MariaDB ID account.

caption: Register for a free MariaDB ID with a Google, GitHub, LinkedIn, or email account. https://id.mariadb.com

Register for a free MariaDB ID with a Google, GitHub, LinkedIn, or email account.
https://id.mariadb.com

Step 2: Launch a Service

  1. Log in to the SkySQL Portal and from the Dashboard, click the "+ Launch a Service" button.

    caption: Log in to the SkySQL Portal with your MariaDB ID and launch a service. https://skysql.mariadb.com

    Log in to the SkySQL Portal with your MariaDB ID and launch a service.
    https://skysql.mariadb.com

  2. From the launch interface, select the type of service you want to launch.

    caption: Click the configuration choices detailed below.

    Click the configuration choices detailed below.
    https://skysql.mariadb.com/launch-service

    We recommend starting with:

    • Transactions

    • Xpand Distributed SQL topology

    • AWS and us-east-2, or Google Cloud and us-east1, or a region of your choice

    • Since this Quickstart is a simple test, select:

      • The smallest instance size

      • 100GB of SSD storage

      • 1 Xpand node

    • Name the service "quickstart-1

    • Then, click the "LAUNCH SERVICE" button.

      caption: Ready to press launch.

      Ready to press launch.
      https://skysql.mariadb.com/launch-service

    For additional information on available selections, see "Service Launch".

  3. You will be returned to the Dashboard where your service will be in a "Creating" state. When the service reaches "Healthy" state, you can advance.

Step 3: Use the Service

Since we have launched a small service on the SkySQL preview release, this service is not appropriate for production workloads or performance testing.

This service is sufficient for us to try out some of the SkySQL preview release features with Xpand Distributed SQL.

Query Editor

SkySQL services support most MariaDB-compatible database clients and most popular programming languages (such as Python, Node.js, Java, and PHP).

However, with SkySQL's Query Editor, we can query databases directly from the web browser. This can be handy for development and day-to-day operations.

To access the Query Editor:

  1. From the Dashboard, click the "Workspace" link in the main menu (left navigation).

  2. Click the "Explore" link on the "Query Editor" card.

  3. You may be prompted to add your IP address to the Firewall allowlist. Your service will enter a "Modifying" state while that change is performed.

    caption: Query Editor - Allowlist

    Query Editor - Allowlist

  4. Once the Firewall update is completed, your service will enter a "Healthy" state again. At this point, you can connect to your database in Query Editor.

    caption: Query Editor

    Query Editor

For additional information on this feature, see "Query Editor".

Monitoring

MariaDB SkySQL's Unified Portal includes robust monitoring optimized for MariaDB database products.

Basic status is shown on the Dashboard.

To see expanded status and metrics information:

  1. From the Dashboard, click on the service name. (This is "quickstart-1" if you used the suggested name.)

  2. From the Monitoring Dashboard, you can choose to view service ("SERVICE OVERVIEW") or server ("SERVERS") details from the left tabs.

  3. Specific views are provided for different sets of metrics. These views can be accessed using the buttons in the upper-right corner. From the service overview, views include "Status", "Queries", and "Connections".

    caption: Monitoring Dashboard

    Monitoring Dashboard

Policies (alerting rules) identify "warning" and "critical" events within status and metrics data. Alerts are customer configurable, but pre-configured with sensible defaults in alignment to typical customer requirements. For additional information, see "Alerts".

caption: Policies (Alerting Rules)

Policies (Alerting Rules)

Scaling

SkySQL features automatic rule-based scaling (Autonomous) and manual on-demand scaling.

With automatic scaling, node count (horizontal) and node count (vertical) changes can be triggered based on load. Additionally, storage capacity expansion can be triggered based on usage. These Autonomous features are opt-in. For additional information, see "Autonomous".

Autonomous

Autonomous
https://skysql.mariadb.com/dashboard

With manual scaling, you can perform horizontal scaling (In/Out), vertical scaling (Up/Down), and storage expansion on-demand using Self-Service Operations. For additional information, see "Self-Service Operations".

Self-Service Scaling of Nodes

Self-Service Scaling of Nodes
https://skysql.mariadb.com/dashboard

Xpand Global Replication

Xpand Global Replication enables a Xpand Distributed SQL service to replicate with one or more Xpand Distributed SQL services in other cloud regions.

To test this feature, you can launch another Xpand Distributed SQL service in a different cloud region. Once the service is Healthy, see the "Xpand Global Replication" instructions.

Xpand Global Replication features point-and-click configuration of multi-region replication through a simple menu. Once Xpand Global Replication is enabled, status is shown on the dashboard and in service details.

Xpand Global Replication - Service Details

Xpand Global Replication - Service Details

Tear-down

When you are done with your testing session, you can stop the service. When a service is stopped, storage charges continue to accrue, but compute charges pause until the service is started again.

When you are done with testing, you can delete the service.

Stopping, starting, and deleting a service are examples of Self-Service Operations that you can perform through the Unified Portal.

For additional information, see "Self-Service Operations".

Contact Us

To contact us with questions or if you need assistance: