v8

latestOpenAPI 3.0.0Apache 2.0raw.githubusercontent.com2025-10-165266542.4 MB
DigitalOcean-public.v2-new_Databases

Update the Database Configuration for an Existing Database

To update the configuration for an existing database cluster, send a PATCH request to /v2/databases/$DATABASE_ID/config.

patch/v2/databases/{database_cluster_uuid}/config

Path parameters

database_cluster_uuidstring uuid required

A unique identifier for a database cluster.

Request body

Example request

{
  "config": {
    "backup_hour": 3,
    "backup_minute": 30,
    "sql_mode": "ANSI,TRADITIONAL",
    "connect_timeout": 10,
    "default_time_zone": "+03:00",
    "group_concat_max_len": 1024,
    "information_schema_stats_expiry": 86400,
    "innodb_ft_min_token_size": 3,
    "innodb_ft_server_stopword_table": "db_name/table_name",
    "innodb_lock_wait_timeout": 50,
    "innodb_log_buffer_size": 16777216,
    "innodb_online_alter_log_max_size": 134217728,
    "innodb_print_all_deadlocks": true,
    "innodb_rollback_on_timeout": true,
    "interactive_timeout": 3600,
    "internal_tmp_mem_storage_engine": "TempTable",
    "net_read_timeout": 30,
    "net_write_timeout": 30,
    "sql_require_primary_key": true,
    "wait_timeout": 28800,
    "max_allowed_packet": 67108864,
    "max_heap_table_size": 16777216,
    "sort_buffer_size": 262144,
    "tmp_table_size": 16777216,
    "slow_query_log": true,
    "long_query_time": 10,
    "binlog_retention_period": 600,
    "innodb_change_buffer_max_size": 25,
    "innodb_read_io_threads": 16,
    "innodb_write_io_threads": 16,
    "net_buffer_length": 4096,
    "log_output": "INSIGHTS",
    "mysql_incremental_backup": {
      "full_backup_week_schedule": "mon,thu"
    }
  }
}

Response

The action was successful and the response body is empty.