Updates configuration settings for an existing Vultr database instance, allowing adjustments to plan, label, region, and other parameters.
The vultr-cli database update command modifies configuration settings for an existing Vultr managed database instance, allowing you to adjust parameters like plan, label, or region.
$ vultr-cli database update <Database ID> [flags]
# Full example
$ vultr-cli database update --region="sea" --plan="vultr-dbaas-startup-cc-2-80-4"
# Full example with custom MySQL settings
$ vultr-cli database update --mysql-slow-query-log="true" --mysql-long-query-time="2"
| Shorthand | Long Version | Description |
|---|---|---|
| - | --backup-hour | backup hour for the managed database |
| - | --backup-minute | backup minute for the managed database |
| - | --cluster-time-zone | configured time zone for the managed database |
| - | --enable-kafka-connect | enable Kafka Connect for the new apache kafka managed database |
| - | --enable-kafka-rest | enable Kafka REST for the new apache kafka managed database |
| - | --enable-schema-registry | enable Schema Registry for the new apache kafka managed database |
| - | --eviction-policy | eviction policy for the caching managed database |
| -l | --label | label for the managed database |
| - | --maintenance-dow | maintenance day of week for the managed database |
| - | --maintenance-time | maintenance time for the managed database |
| - | --mysql-long-query-time | long query time for the mysql managed database when slow query logging is enabled |
| - | --mysql-require-primary-key | enable requiring primary keys for the mysql managed database |
| - | --mysql-slow-query-log | enable slow query logging for the mysql managed database |
| - | --mysql-sql-modes | comma-separated list of sql modes for the managed database |
| -p | --plan | plan id for the managed database |
| -r | --region | region id for the managed database |
| -t | --tag | tag for the managed database |
| - | --trusted-ips | comma-separated list of trusted ip addresses for the managed database |
| - | --vpc-id | vpc id for the managed database |