Transactional Storage Size Selections with the SkySQL previous release DBaaS API

Overview

This reference page details how to select transactional storage sizes with the SkySQL previous release DBaaS API for SkySQL previous release.

Select a Transactional Storage Size

A storage size for transactional data is selected during service launch. When using the REST API, select a transactional storage size by calling the the /services API endpoint with the tx_storage attribute set.

For example, prepare a request body containing the desired service options in a file called request-service.json:

$ cat > request-service.json <<EOF
{
   "name": "doc-test-tx-single",
   "provider": "AWS",
   "region": "us-east-2",
   "release_version": "MariaDB Enterprise Server 10.6.4-1",
   "replicas": "0",
   "size": "Sky-2x8",
   "tier": "Foundation",
   "topology": "Single Node Transactions",
   "tx_storage": "100",
   "volume_iops": "100"
}

Then use curl to call the /services API endpoint to create (launch) a new database service and save the response to the response-service.json file:

$ curl --location --request POST \
   --header 'Authorization: Bearer SKYSQL_BEARER_TOKEN' \
   --header 'Content-type: application/json' \
   --data '@request-service.json' \
   api.skysql.net/services/ \
   | tee response-service.json | jq .

Upon success, the command will return JSON with details about the new service.