Trove/verbose-default-configuration-values
< Trove
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" }, "connect_timeout": { "default": "15", "max": 65535, "min": 1, "restart_required": false, "type": "integer" }, "datadir": { "default": "/var/lib/mysql" }, "default_storage_engine": { "default": "innodb" }, "innodb_buffer_pool_size": { "default": "150M", "max": 68719476736, "min": 0, "restart_required": true, "type": "integer" }, "innodb_data_file_path": { "default": "ibdata1:10M:autoextend" }, "innodb_file_per_table": { "default": "1", "max": 1, "min": 0, "restart_required": true, "type": "integer" }, "innodb_log_buffer_size": { "default": "25M", "max": 4294967296, "min": 1048576, "restart_required": true, "type": "integer" }, "innodb_log_file_size": { "default": "50M" }, "innodb_log_files_in_group": { "default": "2" }, "join_buffer_size": { "default": "1M", "max": 4294967296, "min": 0, "restart_required": false, "type": "integer" }, "key_buffer_size": { "default": "50M", "max": 4294967296, "min": 0, "restart_required": false, "type": "integer" }, "local-infile": { "default": "0" }, "max_allowed_packet": { "default": "1M", "max": 1073741824, "min": 1024, "restart_required": false, "type": "integer" }, "max_connections": { "default": "100", "max": 65535, "min": 1, "restart_required": false, "type": "integer" }, "max_heap_table_size": { "default": "16M" }, "max_user_connections": { "default": "100", "max": 100000, "min": 1, "restart_required": false, "type": "integer" }, "myisam-recover": { "default": "BACKUP" }, "open_files_limit": { "default": "512" }, "pid_file": { "default": "/var/run/mysqld/mysqld.pid" }, "port": { "default": "3306" }, "query_cache_limit": { "default": "1M" }, "query_cache_size": { "default": "8M" }, "query_cache_type": { "default": "1" }, "read_buffer_size": { "default": "512K" }, "read_rnd_buffer_size": { "default": "512K" }, "server_id": { "default": "561332", "max": 100000, "min": 1, "restart_required": true, "type": "integer" }, "skip-external-locking": { "default": "1" }, "sort_buffer_size": { "default": "1M", "max": 18446744073709547520, "min": 32768, "restart_required": false, "type": "integer" }, "table_definition_cache": { "default": "256" }, "table_open_cache": { "default": "256" }, "thread_cache_size": { "default": "4" }, "thread_stack": { "default": "192K" }, "tmp_table_size": { "default": "16M" }, "tmpdir": { "default": "/var/tmp" }, "user": { "default": "mysql" }, "wait_timeout": { "default": "120", "max": 31536000, "min": 1, "restart_required": false, "type": "integer" } }
}
Database Schema
No changes.
Management Commands
No changes.