Skip to content

Instantly share code, notes, and snippets.

@cp16net

cp16net/default instance configuration template

Created October 3, 2013 20:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cp16net/6816691 to your computer and use it in GitHub Desktop.
Save cp16net/6816691 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
default instance configuration template
vagrant@trove:~/trove-integration/scripts$ ./redstack rd-client instance configuration --id 32f35fcd-dd3a-49cb-b99f-5ccccb1f515e --verbose
REQUEST:
curl -i http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/instances/32f35fcd-dd3a-49cb-b99f-5ccccb1f515e/configuration -X GET -H "X-Auth-Project-Id: trove" -H "User-Agent: python-troveclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: 1234567890"
RESPONSE HEADERS: {'date': 'Thu, 03 Oct 2013 20:25:50 GMT', 'status': '200', 'content-length': '1075', 'content-type': 'application/json', 'content-location': u'http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/instances/32f35fcd-dd3a-49cb-b99f-5ccccb1f515e/configuration'}
RESPONSE BODY : {
"instance": {
"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"
}
}
}
Raw
get a configuration-group
vagrant@trove:~/trove-integration/scripts$ ./redstack rd-client configuration get --id 5ad6bade-502e-4c5a-8760-da8461bb0794 --verbose
REQUEST:
curl -i http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/configurations/5ad6bade-502e-4c5a-8760-da8461bb0794 -X GET -H "X-Auth-Project-Id: trove" -H "User-Agent: python-troveclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: 1234567890"
RESPONSE HEADERS: {'date': 'Thu, 03 Oct 2013 20:33:58 GMT', 'status': '200', 'content-length': '162', 'content-type': 'application/json', 'content-location': u'http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/configurations/5ad6bade-502e-4c5a-8760-da8461bb0794'}
RESPONSE BODY : {
"configuration": {
"description": null,
"id": "5ad6bade-502e-4c5a-8760-da8461bb0794",
"instances": [],
"name": "test",
"values": {
"key_buffer_size": "26214400"
}
}
}
Raw
parameter validation rules
vagrant@trove:~/trove-integration/scripts$ ./redstack rd-client configuration parameters --verbose
REQUEST:
curl -i http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/configurations/parameters -X GET -H "X-Auth-Project-Id: trove" -H "User-Agent: python-troveclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: 1234567890"
RESPONSE HEADERS: {'date': 'Thu, 03 Oct 2013 20:29:45 GMT', 'status': '200', 'content-length': '3034', 'content-type': 'application/json', 'content-location': u'http://192.168.199.165:8779/v1.0/e0d763246e404197a33a13590b067c8a/configurations/parameters'}
RESPONSE BODY : {
"configuration-parameters": [
{
"key_buffer_size": {
"dynamic": "true",
"max": 4294967296,
"min": 0,
"type": "integer"
}
},
{
"connect_timeout": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"join_buffer_size": {
"dynamic": "true",
"max": 4294967296,
"min": 0,
"type": "integer"
}
},
{
"sort_buffer_size": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 32768,
"type": "integer"
}
},
{
"innodb_buffer_pool_size": {
"dynamic": "false",
"max": 68719476736,
"min": 0,
"type": "integer"
}
},
{
"innodb_flush_log_at_trx_commit": {
"dynamic": "true",
"max": 2,
"min": 0,
"type": "integer"
}
},
{
"innodb_log_buffer_size": {
"dynamic": "false",
"max": 4294967296,
"min": 1048576,
"type": "integer"
}
},
{
"innodb_log_file_size": {
"dynamic": "false",
"max": 4294967296,
"min": 1048576,
"type": "integer"
}
},
{
"innodb_open_files": {
"dynamic": "false",
"max": 4294967296,
"min": 10,
"type": "integer"
}
},
{
"innodb_thread_concurrency": {
"dynamic": "true",
"max": 1000,
"min": 0,
"type": "integer"
}
},
{
"sync_binlog": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 0,
"type": "integer"
}
},
{
"auto_increment_increment": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"auto_increment_offset": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"bulk_insert_buffer_size": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 0,
"type": "integer"
}
},
{
"expire_logs_days": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"ft_min_word_len": {
"dynamic": "false",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"connect_timeout": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"interactive_timeout": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"max_allowed_packet": {
"dynamic": "true",
"max": 1073741824,
"min": 1024,
"type": "integer"
}
},
{
"max_connect_errors": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 1,
"type": "integer"
}
},
{
"max_connections": {
"dynamic": "true",
"max": 65535,
"min": 1,
"type": "integer"
}
},
{
"max_heap_table_size": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 16384,
"type": "integer"
}
},
{
"tmp_table_size": {
"dynamic": "true",
"max": 4294967295,
"min": 1024,
"type": "integer"
}
},
{
"myisam_sort_buffer_size": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 4,
"type": "integer"
}
},
{
"thread_cache_size": {
"dynamic": "true",
"max": 16384,
"min": 0,
"type": "integer"
}
},
{
"query_cache_size": {
"dynamic": "true",
"max": 18446744073709547520,
"min": 0,
"type": "integer"
}
},
{
"table_open_cache": {
"dynamic": "true",
"max": 524288,
"min": 400,
"type": "integer"
}
},
{
"table_definition_cache": {
"dynamic": "true",
"max": 524288,
"min": 400,
"type": "integer"
}
},
{
"open_files_limit": {
"dynamic": "false",
"max": 65535,
"min": 0,
"type": "integer"
}
},
{
"max_user_connections": {
"dynamic": "true",
"max": 100000,
"min": 1,
"type": "integer"
}
},
{
"server_id": {
"dynamic": "false",
"max": 100000,
"min": 1,
"type": "integer"
}
},
{
"wait_timeout": {
"dynamic": "true",
"max": 31536000,
"min": 1,
"type": "integer"
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment