Create or restore a MySQL Managed Database

post https://api.linode.com/{apiVersion}/databases/mysql/instances

Provision a MySQL Managed Database

Use this operation to create a new MySQL Managed Database.

Restricted users need the add_databases user grant.
New instances can take 10 to 15 minutes to deploy.
All Managed Databases include automatic, daily backups. Up to seven backups are automatically stored for each Managed Database, providing restore points for each day of the past week.
All Managed Databases include automatic updates, which apply security patches to the underlying operating system of the MySQL Managed Database. Configure the maintenance window for these updates with the Update a managed MySQL database operation.
If your database cluster is configured with a single node, downtime occurs during maintenance updates. You should adjust the window to match a time that's the least disruptive to your application and users. Also consider upgrading to a high availability plan to avoid any maintenance downtime.
Major upgrades are optional until the service reaches end of service, and can be done in place.

Restore a MySQL Managed Database

Do this by creating a fork from a backup. A user needs read_write access to the database and its status can be active, degraded, or failed.

📘
Restoring from a backup creates a second running cluster, which incurs billing. Delete the first cluster after the restore is complete, to avoid this billing.

linode-cli databases mysql-create \
  --label example-db1 \
  --region us-east \
  --type g6-dedicated-2 \
  --cluster_size 3 \
  --engine mysql/8.0.26 \
  --ssl_connection true \
  --allow_list 203.0.113.1 \
  --allow_list 192.0.1.0/24

<https://techdocs.akamai.com/cloud-computing/docs/getting-started-with-the-linode-cli>

databases:read_write

<https://techdocs.akamai.com/linode-api/reference/get-started#oauth>