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 theallow_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>