Self-Service Operations

Overview

SkySQL's self-service management features enable authorized accounts to launch cloud databases, start and stop cloud databases, delete cloud databases, apply database configuration changes, and configure the cloud database's IP firewall.

Self-service user management features enable you to define role-based access for your team to jointly manage SkySQL resources.

Compatibility

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

  • ColumnStore Data Warehouse

Stop a Service

Service - Stop

Service - Stop
https://skysql.mariadb.com/dashboard

To stop a service:

  1. Log in to the Portal.

  2. Click the "MANAGE" button (at right) for the desired service.

  3. Choose the "Stop Service" menu item.

  4. Click the "Yes, Stop this service" button to confirm this operation.

The service will be stopped. You will only be charged for storage on a stopped service.

Notifications will be generated when this operation is initiated and when the operation is performed.

Start a Service

Service - Start

Service - Start
https://skysql.mariadb.com/dashboard

To start a service:

  1. Log in to the Portal.

  2. Click the "MANAGE" button (at right) for the desired service.

  3. Choose the "Start Service" menu item.

  4. Click the "Yes, Start this service" button to confirm this operation.

The service will be started. Service start may take up to 15 minutes. The normal billing cycle for the service will resume.

Notifications will be generated when this operation is initiated and when the operation is performed.

Scale Nodes In/Out

Service - Horizontal Scaling

Service - Horizontal Scaling
https://skysql.mariadb.com/dashboard

Horizontal scaling is performed by scaling nodes In (reducing node count) or Out (increasing node count).

To scale nodes horizontally:

  1. Log in to the Portal.

  2. Identify the service you want to scale. Services must be in a "Healthy" state to scale.

  3. Click the "MANAGE" button (at right) for the desired service.

  4. Choose the "Scale nodes in/out" menu item.

  5. Change the node count to the desired value.

  6. Optionally, you can check the "Auto-scale nodes horizontally" checkbox to enable Autonomous features for this service.

  7. Click the "Apply Changes" button.

The service immediately goes into scaling status.

Notifications will be generated when this operation is initiated and when the operation is performed.

Scale Nodes Up/Down

Service - Vertical Scaling

Service - Vertical Scaling
https://skysql.mariadb.com/dashboard

Vertical scaling is performed by scaling nodes Up (increasing node size) or Down (decreasing node size).

To scale nodes vertically:

  1. Log in to the Portal.

  2. Identify the service you want to scale. Services must be in a "Healthy" state to scale.

  3. Click the "MANAGE" button (at right) for the desired service.

  4. Choose the "Scale nodes up/down" menu item.

  5. Change the node count to the desired value.

  6. Optionally, you can check the "Auto-scale nodes vertically" checkbox to enable Autonomous features for this service.

  7. Click the "Apply Changes" button.

The service immediately goes into scaling status.

Notifications will be generated when this operation is initiated and when the operation is performed.

Scale Storage

Service - Scale Storage

Service - Scale Storage
https://skysql.mariadb.com/dashboard

To expand block storage capacity:

  1. Log in to the Portal.

  2. Identify the service you want to scale. Services must be in a "Healthy" state to scale.

  3. Click the "MANAGE" button (at right) for the desired service.

  4. Choose the "Scale storage" menu item.

  5. Use the slider to select the desired amount of storage.

  6. Click the "Apply Changes" button.

Storage scaling is subject to a 6 hour cooldown period.

Storage upgrades are not reversible.

Delete a Service

Service - Delete

Service - Delete
https://skysql.mariadb.com/dashboard

To delete a service:

  1. Log in to the Portal.

  2. Identify the service you want to delete.

  3. Click the "MANAGE" button (at right) for that service.

  4. Choose the "Delete Service" menu item.

  5. Read the warning and follow the provided instructions to confirm your delete operation.

  6. Click "Yes, delete".

Your service and all its data will be deleted. This operation is non-reversible.

Notifications will be generated when this operation is initiated and when the operation is performed.