Difference between revisions of "Trove/default-configuration-values-for-datastore-version-flavor"
(→API Resources) |
(→API Resources) |
||
Line 9: | Line 9: | ||
* flavor id | * flavor id | ||
* datastore version | * datastore version | ||
− | |||
=== API Details: Get default configuration values for datastore version and flavor === | === API Details: Get default configuration values for datastore version and flavor === |
Latest revision as of 15:49, 14 July 2014
Contents
Overview
In order to know what changes a user may need to make for a configuration group we need a way of showing what the default mysql configuration template is for a specific datastore version and flavor size. Currently the only way to see the default template is on an active instance. A user can create a configuration group without having an instance and it would be nice to see the defaults that you are changing when creating a new group for some instance.
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
{ "flavor": "1", "datastore": "mysql", "datastore_version", "5.6", "configuration": { "basedir": "/usr", "connect_timeout": "15", "datadir": "/var/lib/mysql", "default_storage_engine": "innodb", "innodb_buffer_pool_size": "150M", "innodb_data_file_path": "ibdata1:10M:autoextend", "innodb_file_per_table": "1", "innodb_log_buffer_size": "25M", "innodb_log_file_size": "50M", "innodb_log_files_in_group": "2", "join_buffer_size": "1M", "key_buffer_size": "50M", "local-infile": "0", "max_allowed_packet": "1M", "max_connections": "100", "max_heap_table_size": "16M", "max_user_connections": "100", "myisam-recover": "BACKUP", "open_files_limit": "512", "pid_file": "/var/run/mysqld/mysqld.pid", "port": "3306", "query_cache_limit": "1M", "query_cache_size": "8M", "query_cache_type": "1", "read_buffer_size": "512K", "read_rnd_buffer_size": "512K", "server_id": "206237194", "skip-external-locking": null, "sort_buffer_size": "1M", "table_definition_cache": "256", "table_open_cache": "256", "thread_cache_size": "4", "thread_stack": "192K", "tmp_table_size": "16M", "tmpdir": "/var/tmp", "user": "mysql", "wait_timeout": "120" }
}
Database Schema
No changes.
Management Commands
No changes.