Path parameters
-
name
string Required Minimum length is
0
, maximum length is63
.
Body
Required
-
backup-schedule
object -
integrations
array[object] Service integrations to be enabled when creating the service.
-
ip-filter
array[string] Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
-
termination-protection
boolean Service is protected against termination and powering off
-
fork-from-service
string Minimum length is
0
, maximum length is63
. -
recovery-backup-time
string ISO time of a backup to recover from for services that support arbitrary times
Minimum length is
1
. -
mysql-settings
object Additional properties are NOT allowed.
-
maintenance
object Automatic maintenance settings
-
admin-username
string 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}$
. -
version
string MySQL major version
Minimum length is
1
. -
plan
string Required Subscription plan
Minimum length is
1
, maximum length is128
. -
admin-password
string 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-_]+$
. -
migration
object Migrate data from existing server
-
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
.
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"
}