Trove/verbose-default-configuration-values
Contents
Overview
This is related to the bp/default-configuration-values-for-datastore-version-flavor with more verbose information for each configuration value.
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.