Body
Required
-
Service integrations to be enabled when creating the service.
-
Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
-
Service is protected against termination and powering off
-
Minimum length is
0
, maximum length is63
. -
ISO time of a backup to recover from for services that support arbitrary times
Minimum length is
1
. -
Additional properties are NOT allowed.
-
Automatic maintenance settings
-
Custom username for admin user. This must be set only when a new service is being created.
Minimum length is
1
, maximum length is64
. Format should match the following pattern:^[_A-Za-z0-9][-._A-Za-z0-9]{0,63}$
. -
MySQL major version
Minimum length is
1
. -
Subscription plan
Minimum length is
1
, maximum length is128
. -
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
Minimum length is
8
, maximum length is256
. Format should match the following pattern:^[a-zA-Z0-9-_]+$
. -
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
.
curl \
--request POST 'https://api-ch-gva-2.exoscale.com/v2/dbaas-mysql/{name}' \
--header "Content-Type: application/json" \
--data '{"backup-schedule":{"backup-hour":42,"backup-minute":42},"integrations":[{"type":"read_replica","source-service":"string","dest-service":"string","settings":{}}],"ip-filter":["string"],"termination-protection":true,"fork-from-service":"string","recovery-backup-time":"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},"maintenance":{"dow":"saturday","time":"string"},"admin-username":"string","version":"string","plan":"string","admin-password":"string","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
},
"integrations": [
{
"type": "read_replica",
"source-service": "string",
"dest-service": "string",
"settings": {}
}
],
"ip-filter": [
"string"
],
"termination-protection": true,
"fork-from-service": "string",
"recovery-backup-time": "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
},
"maintenance": {
"dow": "saturday",
"time": "string"
},
"admin-username": "string",
"version": "string",
"plan": "string",
"admin-password": "string",
"migration": {
"host": "string",
"port": 42,
"password": "string",
"ssl": true,
"username": "string",
"dbname": "string",
"ignore-dbs": "string",
"method": "dump"
},
"binlog-retention-period": 42
}
{
"id": "string",
"reason": "incorrect",
"reference": {
"id": "string",
"link": "string",
"command": "string"
},
"message": "string",
"state": "failure"
}