Trove/verbose-default-configuration-values
Contents
Overview
This is related to the bp/default-configuration-values-for-datastore-version-flavor
Design Goals
Create a new API call that returns the fields of the my.cnf template that is setup in the system when creating a new instance.
API Resources
A new API path needs to be created that will include the following:
- flavor id
- datastore version
API Details: Get default configuration values for datastore version and flavor
| Verb | Resource | Description |
|---|---|---|
| GET | /datastore/version/{dv_id}/configuration/{flavor_id} | 'New Operation – Allow user to see the "default" mysql configuration settings from template. |
Get default configuration values for datastore version and flavor (GET)
This is the default configurations that are applied to the instance according the the flavor assigned.
Response
{
"datastore": "mysql",
"datastore_version": "5.5",
"flavor": "1",
"configuration": {
"basedir": {
"default": "/usr",
"rules": {}
},
"connect_timeout": {
"default": "15",
"rules": {
"max": 65535,
"min": 1,
"restart_required": false,
"type": "integer"
}
},
"datadir": {
"default": "/var/lib/mysql",
"rules": {}
},
"default_storage_engine": {
"default": "innodb",
"rules": {}
},
"innodb_buffer_pool_size": {
"default": "150M",
"rules": {
"max": 68719476736,
"min": 0,
"restart_required": true,
"type": "integer"
}
},
"innodb_data_file_path": {
"default": "ibdata1:10M:autoextend",
"rules": {}
},
"innodb_file_per_table": {
"default": "1",
"rules": {
"max": 1,
"min": 0,
"restart_required": true,
"type": "integer"
}
},
"innodb_log_buffer_size": {
"default": "25M",
"rules": {
"max": 4294967296,
"min": 1048576,
"restart_required": true,
"type": "integer"
}
},
"innodb_log_file_size": {
"default": "50M",
"rules": {}
},
"innodb_log_files_in_group": {
"default": "2",
"rules": {}
},
"join_buffer_size": {
"default": "1M",
"rules": {
"max": 4294967296,
"min": 0,
"restart_required": false,
"type": "integer"
}
},
"key_buffer_size": {
"default": "50M",
"rules": {
"max": 4294967296,
"min": 0,
"restart_required": false,
"type": "integer"
}
},
"local-infile": {
"default": "0",
"rules": {}
},
"max_allowed_packet": {
"default": "1M",
"rules": {
"max": 1073741824,
"min": 1024,
"restart_required": false,
"type": "integer"
}
},
"max_connections": {
"default": "100",
"rules": {
"max": 65535,
"min": 1,
"restart_required": false,
"type": "integer"
}
},
"max_heap_table_size": {
"default": "16M",
"rules": {}
},
"max_user_connections": {
"default": "100",
"rules": {
"max": 100000,
"min": 1,
"restart_required": false,
"type": "integer"
}
},
"myisam-recover": {
"default": "BACKUP",
"rules": {}
},
"open_files_limit": {
"default": "512",
"rules": {}
},
"pid_file": {
"default": "/var/run/mysqld/mysqld.pid",
"rules": {}
},
"port": {
"default": "3306",
"rules": {}
},
"query_cache_limit": {
"default": "1M",
"rules": {}
},
"query_cache_size": {
"default": "8M",
"rules": {}
},
"query_cache_type": {
"default": "1",
"rules": {}
},
"read_buffer_size": {
"default": "512K",
"rules": {}
},
"read_rnd_buffer_size": {
"default": "512K",
"rules": {}
},
"server_id": {
"default": "561332",
"rules": {
"max": 100000,
"min": 1,
"restart_required": true,
"type": "integer"
}
},
"skip-external-locking": {
"default": "1",
"rules": {}
},
"sort_buffer_size": {
"default": "1M",
"rules": {
"max": 18446744073709547520,
"min": 32768,
"restart_required": false,
"type": "integer"
}
},
"table_definition_cache": {
"default": "256",
"rules": {}
},
"table_open_cache": {
"default": "256",
"rules": {}
},
"thread_cache_size": {
"default": "4",
"rules": {}
},
"thread_stack": {
"default": "192K",
"rules": {}
},
"tmp_table_size": {
"default": "16M",
"rules": {}
},
"tmpdir": {
"default": "/var/tmp",
"rules": {}
},
"user": {
"default": "mysql",
"rules": {}
},
"wait_timeout": {
"default": "120",
"rules": {
"max": 31536000,
"min": 1,
"restart_required": false,
"type": "integer"
}
}
}
}
Database Schema
No changes.
Management Commands
No changes.
