Update a MySQL Managed Database

Make changes to an existing MySQL Managed Database.

  • The user needs read_write user grant access to the database.

  • The database's status needs to be active.

  • New values set in the allow_list overwrite existing values. To keep existing values, run the List MySQL Managed Databases operation, store the allow_list addresses from the response, and include them with any new addresses in this operation.

  • Updates to your allow_list may take a short time to complete, making this operation inappropriate for rapid successive updates.

  • Also allows resizing the database cluster to a larger one. Clusters can't be resized to smaller plans.

  • All Managed Databases include automatic updates, which apply security patches to the underlying operating system of the Managed MySQL Database. Use the updates object in this operation to modify the maintenance window for these updates.

  • If your database cluster is configured with a single node, downtime occurs during maintenance updates. Use the updates object to 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.

linode-cli databases mysql-update 123 \
  --label example-db \
  --allow_list 203.0.113.1 \
  --allow_list 192.0.1.0/24 \
  --type g6-standard-1 \
  --updates.frequency weekly \
  --updates.duration 3 \
  --updates.hour_of_day 12 \
  --updates.day_of_week 4 \

<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>
Language
Credentials
Click Try It! to start a request and see the response here!