Difference between revisions of "Trove/verbose-default-configuration-values"

Revision as of 18:08, 13 August 2014

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

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.