Body
Required
-
Automatic maintenance settings
-
Subscription plan
Minimum length is
1
, maximum length is128
. -
Service is protected against termination and powering off
-
Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
-
Additional properties are NOT allowed.
-
Migrate data from existing server
-
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
.
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"
}