Exoscale APIv2 API documentation

Update a DBaaS MySQL service

PUT /dbaas-mysql/{name}

Update a DBaaS MySQL service

Path parameters

name string Required

Body Required

maintenance object

Automatic maintenance settings
- dow string Required
  
  Day of week for installing updates
  
  Values are saturday, tuesday, never, wednesday, sunday, friday, monday, or thursday.
- time string Required
  
  Time for installing updates, UTC
  
  Minimum length is 8, maximum length is 8.
plan string

Subscription plan

Minimum length is 1, maximum length is 128.
termination-protection boolean

Service is protected against termination and powering off
ip-filter array[string]

Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
mysql-settings object

MySQL-specific settings
migration object

Migrate data from existing server
- host string Required
  
  Hostname or IP address of the server where to migrate data from
  
  Minimum length is 1, maximum length is 255.
- port integer(int64) Required
  
  Port number of the server where to migrate data from
  
  Minimum value is 1, maximum value is 65535.
- password string
  
  Password for authentication with the server where to migrate data from
  
  Minimum length is 1, maximum length is 255.
- ssl boolean
  
  The server where to migrate data from is secured with SSL
- username string
  
  User name for authentication with the server where to migrate data from
  
  Minimum length is 1, maximum length is 255.
- dbname string
  
  Database name for bootstrapping the initial connection
  
  Minimum length is 1, maximum length is 63.
- ignore-dbs string
  
  Comma-separated list of databases, which should be ignored during migration (supported by MySQL only at the moment)
  
  Minimum length is 1, maximum length is 2048.
- method string
  
  The migration method to be used
  
  Values are dump or replication.
binlog-retention-period integer(int64)

The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.

Minimum value is 600, maximum value is 86400.
backup-schedule object
- backup-hour integer(int64)
  
  The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
  
  Minimum value is 0, maximum value is 23.
- backup-minute integer(int64)
  
  The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
  
  Minimum value is 0, maximum value is 59.

Responses

• 200 object

200
- id string(uuid)
  
  Operation ID
- reason string
  
  Operation failure reason
  
  Values are incorrect, unknown, unavailable, forbidden, busy, fault, partial, not-found, interrupted, unsupported, or conflict.
- reference object
  
  Related resource reference
  id string(uuid)
  
  Reference ID
  
  link string
  
  Link to the referenced resource
  
  command string
  
  Command name
- message string
  
  Operation message
- state string
  
  Operation status
  
  Values are failure, pending, success, or timeout.

PUT /dbaas-mysql/{name}

curl \
 -X PUT https://api-ch-gva-2.exoscale.com/v2/dbaas-mysql/{name} \
 -H "Content-Type: application/json" \
 -d '{"maintenance":{"dow":"saturday","time":"string"},"plan":"string","termination-protection":true,"ip-filter":["string"],"mysql-settings":{},"migration":{"host":"string","port":42,"password":"string","ssl":true,"username":"string","dbname":"string","ignore-dbs":"string","method":"dump"},"binlog-retention-period":42,"backup-schedule":{"backup-hour":42,"backup-minute":42}}'

Request example

{
  "maintenance": {
    "dow": "saturday",
    "time": "string"
  },
  "plan": "string",
  "termination-protection": true,
  "ip-filter": [
    "string"
  ],
  "mysql-settings": {},
  "migration": {
    "host": "string",
    "port": 42,
    "password": "string",
    "ssl": true,
    "username": "string",
    "dbname": "string",
    "ignore-dbs": "string",
    "method": "dump"
  },
  "binlog-retention-period": 42,
  "backup-schedule": {
    "backup-hour": 42,
    "backup-minute": 42
  }
}

Response example (200)

{
  "id": "string",
  "reason": "incorrect",
  "reference": {
    "id": "string",
    "link": "string",
    "command": "string"
  },
  "message": "string",
  "state": "failure"
}