EXexoscale
dbaas

Update a DBaaS MySQL service

Update a DBaaS MySQL service

put/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

versionstring

MySQL version

planstring

Subscription plan

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

No recorded changes to this operation across all 1 revision of this API.