EXexoscale
dbaas

Create a DBaaS MySQL service

Changed on

Create a DBaaS MySQL service

post/dbaas-mysql/{name}

Request

Path parameters

namestring required

Request body

ip-filterstring[]

Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'

termination-protectionboolean

Service is protected against termination and powering off

fork-from-servicestring
recovery-backup-timestring

ISO time of a backup to recover from for services that support arbitrary times

admin-usernamestring

Custom username for admin user. This must be set only when a new service is being created.

versionstring

MySQL major version

planstring required

Subscription plan

admin-passwordstring
binlog-retention-periodinteger

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.

Example request

{
  "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,
    "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
  }
}

Response

200

idstring uuid

Operation ID

reason'incorrect' | 'unknown' | 'unavailable' | 'forbidden' | 'busy' | 'fault' | 'partial' | 'not-found' | 'interrupted' | 'unsupported' | 'conflict'

Operation failure reason

messagestring

Operation message

state'failure' | 'pending' | 'success' | 'timeout'

Operation status

Changes

  • e05707a7b346Revision changes
    • warning

      changed the pattern of the request property from ^[a-zA-Z0-9-_]+$ to ^[a-zA-Z0-9!#%^*_+={}()<>|.,;~?-]+$

  • 814bf1ccd925Revision changes
    • info

      the request property / became nullable

    • info

      the request property / became nullable