Rackspace API/Cloud Databases - Revision history

Christoph at 17:29, 19 September 2019

2019-09-19T17:29:12Z

Christoph: /* HOWTO: change default DBaaS instance configuration parameters */

2015-12-31T04:18:53Z

‎HOWTO: change default DBaaS instance configuration parameters

Christoph at 18:02, 14 November 2014

2014-11-14T18:02:16Z

Christoph at 10:56, 13 November 2014

2014-11-13T10:56:23Z

Christoph: /* HOWTO: change default DBaaS instance configuration parameters */

2014-11-13T10:03:57Z

‎HOWTO: change default DBaaS instance configuration parameters

Christoph: /* HOWTO: change default DBaaS instance configuration */

2014-11-13T10:01:20Z

‎HOWTO: change default DBaaS instance configuration

Christoph at 07:27, 13 November 2014

2014-11-13T07:27:14Z

Christoph at 12:42, 28 October 2014

2014-10-28T12:42:15Z

Christoph at 12:38, 28 October 2014

2014-10-28T12:38:57Z

Christoph: /* HOWTO: enable slow query logging */

2014-09-24T05:34:33Z

‎HOWTO: enable slow query logging

← Older revision		Revision as of 17:29, 19 September 2019
Line 1:		Line 1:
		+	<div style="margin: 10px; padding: 5px; border: 2px solid red; text-align: center">'''NOTE:''' This article was written in 2014 and is no longer maintained.</div>
		+
	This article will show various examples and techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] (DBaaS) RESTful API.		This article will show various examples and techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] (DBaaS) RESTful API.

@@ Line 145: / Line 145: @@
 * Create a configuration group with some values ("tmp_table_size" in this example; note: you can create a configuration group using either the type/version UUID or their names):
-  $ echo 64*1024^2|bc -l  # => 67108864 (64MB)
+  $ echo $((64*1024**2))  # => 67108864 (64MB)
   $ curl -vH "X-Auth-Token: $TOKEN" -H "Content-Type: application/json" "$ENDPOINT/configurations" \
       -d '{"configuration": {"datastore": {"version": "5.6", "type": "mysql"}, \

← Older revision		Revision as of 18:02, 14 November 2014
Line 1:		Line 1:
−	This article will show various techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] API.	+	This article will show various examples and techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] (DBaaS) RESTful API.

	''NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the '''important caveat''' that accompanies this process:''		''NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the '''important caveat''' that accompanies this process:''

@@ Line 1: / Line 1: @@
 This article will show various techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] API.
-NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_.html important caveat] that accompanies this process:
+''NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the '''important caveat''' that accompanies this process:''
 <div style="padding: 1em; margin: 10px; border: 2px solid #f00;">
-'''WARNING:''' "Changes you make as a root user may cause detrimental effects to the database instance and unpredictable behavior for API operations. When you enable the root user, you accept the possibility that we will not be able to support your database instance. While enabling root does not prevent us from a 'best effort' approach to helping you if something goes wrong with your instance, we cannot ensure that we will be able to assist you if you change core database settings. These changes can be (but are not limited to) turning off binlogs, removing users that we use to access your instance, and so forth."
+'''WARNING:''' "Changes you make as a root user may cause detrimental effects to the database instance and unpredictable behavior for API operations."
 </div>

@@ Line 210: / Line 210: @@
 A "202 Accepted" response means the deletion was successful. Or, you can verify that the configuration has, indeed, been removed with:
   $ curl -sH "X-Auth-Token: $TOKEN" -H "Content-Type: application/json" "$ENDPOINT/configurations"|python -mjson.tool
 ==See also==

@@ Line 80: / Line 80: @@
 See also: "[http://docs.rackspace.com/cdb/api/v1.0/cdb-getting-started/content/Managing_TZ_for_Database_Instances_CURL.html Managing the Time Zone with cURL]".
-==HOWTO: change default DBaaS instance configuration==
+==HOWTO: change default DBaaS instance configuration parameters==
 ''Note: In order to change the default configuration for a given Cloud Database, you must first enable root on your instance.''
 * Authenticate to receive (24-hour valid) token:
@@ Line 87: / Line 89: @@
   $ USERNAME=<RAX_USERNAME>
   $ APIKEY=<RAX_API_KEY>
-  $ TOKEN=`curl -s -XPOST https://identity.api.rackspacecloud.com/v2.0/tokens \
+  $ TOKEN=`curl -s -XPOST <nowiki>https://identity.api.rackspacecloud.com/v2.0/tokens</nowiki> \
            -d'{"auth":{"RAX-KSKEY:apiKeyCredentials":{"username":"'$USERNAME'","apiKey":"'$APIKEY'"}}}' \
            -H"Content-type:application/json" | \
@@ Line 96: / Line 98: @@
   $ ENDPOINT=<nowiki>https://${REGION}.databases.api.rackspacecloud.com/v1.0/${ACCOUNT}</nowiki>
   $ curl -s -H "Accept: application/json" -H "X-Auth-Token: $TOKEN" "$ENDPOINT/datastores" | python -mjson.tool
 ==See also==

@@ Line 13: / Line 13: @@
   $ API_KEY=<YOUR_API_KEY>
   $ TOKEN=`curl -s -XPOST <nowiki>https://identity.api.rackspacecloud.com/v2.0/tokens</nowiki> \
-   -d'{"auth":{"RAX-KSKEY:apiKeyCredentials":{"username":"'$USERNAME'","apiKey":"'$API_KEY'"}}}' \
+          -d'{"auth":{"RAX-KSKEY:apiKeyCredentials":{"username":"'$USERNAME'","apiKey":"'$API_KEY'"}}}' \
-   -H"Content-type:application/json" | \
+          -H"Content-type:application/json" | \
-   python -c 'import sys,json;data=json.loads(sys.stdin.read());print data["access"]["token"]["id"]'`
+          python -c 'import sys,json;data=json.loads(sys.stdin.read());print data["access"]["token"]["id"]'`
   $ REGION=dfw
@@ Line 79: / Line 79: @@
 See also: "[http://docs.rackspace.com/cdb/api/v1.0/cdb-getting-started/content/Managing_TZ_for_Database_Instances_CURL.html Managing the Time Zone with cURL]".
 ==See also==

← Older revision		Revision as of 12:42, 28 October 2014
Line 1:		Line 1:
−	This article will show various techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases].	+	This article will show various techniques for working with Rackspace's [http://www.rackspace.com/cloud/databases/ Cloud Databases] API.

	NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_.html important caveat] that accompanies this process:		NOTE: Some of these techniques will require you to first enable root on your instance. This must be [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_Database_Instances.html done via the Rackspace API]. However, make sure you note the [http://docs.rackspace.com/cdb/api/v1.0/cdb-devguide/content/POST_createRoot__version___accountId__instances__instanceId__root_.html important caveat] that accompanies this process:

@@ Line 46: / Line 46: @@
   | slow_query_log_file       | /var/lib/mysql/f40b3b3afc5549de55fdb230252446f3c70f94e3-slow.log |
   +---------------------------+------------------------------------------------------------------+
   mysql> set global slow_query_log='ON';
   mysql> select sleep(30);
   mysql> select * from mysql.slow_log\G
-  *************************** 1. row ***************************
       start_time: 2014-09-24 05:10:34
        user_host: root[root] @  [10.x.x.x]