Path parameters
-
name
string Required Service name
Minimum length is
0
, maximum length is63
.
Body
Required
-
maintenance
object Automatic maintenance settings
Additional properties are allowed.
-
plan
string Subscription plan
Minimum length is
1
, maximum length is128
. -
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
Additional properties are NOT allowed.
-
migration
object Migrate data from existing server
Additional properties are allowed.
-
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 is86400
. -
backup-schedule
object Additional properties are allowed.
PUT
/dbaas-mysql/{name}
curl \
--request PUT https://api-ch-gva-2.exoscale.com/v2/dbaas-mysql/{name} \
--header "Content-Type: application/json" \
--data '{"maintenance":{"dow":"saturday","time":"string"},"plan":"string","termination-protection":true,"ip-filter":["string"],"mysql-settings":{"net_write_timeout":30,"internal_tmp_mem_storage_engine":"TempTable","sql_mode":"ANSI,TRADITIONAL","information_schema_stats_expiry":86400,"sort_buffer_size":262144,"innodb_thread_concurrency":10,"innodb_write_io_threads":10,"innodb_ft_min_token_size":3,"innodb_change_buffer_max_size":30,"innodb_flush_neighbors":0,"tmp_table_size":16777216,"slow_query_log":true,"connect_timeout":10,"log_output":"INSIGHTS","net_read_timeout":30,"innodb_lock_wait_timeout":50,"wait_timeout":28800,"innodb_rollback_on_timeout":true,"group_concat_max_len":1024,"net_buffer_length":16384,"innodb_print_all_deadlocks":true,"innodb_online_alter_log_max_size":134217728,"interactive_timeout":3600,"innodb_log_buffer_size":16777216,"max_allowed_packet":67108864,"max_heap_table_size":16777216,"innodb_ft_server_stopword_table":"db_name/table_name","innodb_read_io_threads":10,"sql_require_primary_key":true,"default_time_zone":"+03:00","long_query_time":10},"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 examples
{
"maintenance": {
"dow": "saturday",
"time": "string"
},
"plan": "string",
"termination-protection": true,
"ip-filter": [
"string"
],
"mysql-settings": {
"net_write_timeout": 30,
"internal_tmp_mem_storage_engine": "TempTable",
"sql_mode": "ANSI,TRADITIONAL",
"information_schema_stats_expiry": 86400,
"sort_buffer_size": 262144,
"innodb_thread_concurrency": 10,
"innodb_write_io_threads": 10,
"innodb_ft_min_token_size": 3,
"innodb_change_buffer_max_size": 30,
"innodb_flush_neighbors": 0,
"tmp_table_size": 16777216,
"slow_query_log": true,
"connect_timeout": 10,
"log_output": "INSIGHTS",
"net_read_timeout": 30,
"innodb_lock_wait_timeout": 50,
"wait_timeout": 28800,
"innodb_rollback_on_timeout": true,
"group_concat_max_len": 1024,
"net_buffer_length": 16384,
"innodb_print_all_deadlocks": true,
"innodb_online_alter_log_max_size": 134217728,
"interactive_timeout": 3600,
"innodb_log_buffer_size": 16777216,
"max_allowed_packet": 67108864,
"max_heap_table_size": 16777216,
"innodb_ft_server_stopword_table": "db_name/table_name",
"innodb_read_io_threads": 10,
"sql_require_primary_key": true,
"default_time_zone": "+03:00",
"long_query_time": 10
},
"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 examples (200)
{
"id": "string",
"reason": "incorrect",
"reference": {
"id": "string",
"link": "string",
"command": "string"
},
"message": "string",
"state": "failure"
}