Trove/default-configuration-values-for-datastore-version-flavor

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