€cdocutils.nodes document q)q}q(U nametypesq}q(Xgetting startedqNX"1. instantiate a rackspace client.qNX%2. create a database server instance.qNX53. create a database on the database server instance.q NX[5. optional step: create a load balancer to allow access to the database from the internet.q NX databasesq NX74. create database user and give it access to database.q NuUsubstitution_defsq }qUparse_messagesq]qUcurrent_sourceqNU decorationqNUautofootnote_startqKUnameidsq}q(hUgetting-startedqhUinstantiate-a-rackspace-clientqhU!create-a-database-server-instanceqh U1create-a-database-on-the-database-server-instanceqh UVoptional-step-create-a-load-balancer-to-allow-access-to-the-database-from-the-internetqh U databasesqh U3create-database-user-and-give-it-access-to-databasequUchildrenq]qcdocutils.nodes section q)q }q!(U rawsourceq"UUparentq#hUsourceq$XK/Users/jamie/projects/php/php-opencloud/doc/services/database/README.md.rstq%Utagnameq&Usectionq'U attributesq(}q)(Udupnamesq*]Uclassesq+]Ubackrefsq,]Uidsq-]q.haUnamesq/]q0h auUlineq1KUdocumentq2hh]q3(cdocutils.nodes title q4)q5}q6(h"X Databasesq7h#h h$h%h&Utitleq8h(}q9(h*]h+]h,]h-]h/]uh1Kh2hh]q:cdocutils.nodes Text q;X Databasesq<…q=}q>(h"h7h#h5ubaubcdocutils.nodes paragraph q?)q@}qA(h"XÕA **cloud database** is a MySQL relational database service that allows customers to programatically provision database instances of varying virtual resource sizes without the need to maintain and/or update MySQL.h#h h$h%h&U paragraphqBh(}qC(h*]h+]h,]h-]h/]uh1Kh2hh]qD(h;XA qE…qF}qG(h"XA h#h@ubcdocutils.nodes strong qH)qI}qJ(h"X**cloud database**h(}qK(h*]h+]h,]h-]h/]uh#h@h]qLh;Xcloud databaseqM…qN}qO(h"Uh#hIubah&UstrongqPubh;XÁ is a MySQL relational database service that allows customers to programatically provision database instances of varying virtual resource sizes without the need to maintain and/or update MySQL.qQ…qR}qS(h"XÁ is a MySQL relational database service that allows customers to programatically provision database instances of varying virtual resource sizes without the need to maintain and/or update MySQL.h#h@ubeubh)qT}qU(h"Uh#h h$h%h&h'h(}qV(h*]h+]h,]h-]qWhah/]qXhauh1K h2hh]qY(h4)qZ}q[(h"XGetting startedq\h#hTh$h%h&h8h(}q](h*]h+]h,]h-]h/]uh1K h2hh]q^h;XGetting startedq_…q`}qa(h"h\h#hZubaubh)qb}qc(h"Uh#hTh$h%h&h'h(}qd(h*]h+]h,]h-]qehah/]qfhauh1K h2hh]qg(h4)qh}qi(h"X"1. Instantiate a Rackspace client.qjh#hbh$h%h&h8h(}qk(h*]h+]h,]h-]h/]uh1K h2hh]qlh;X"1. Instantiate a Rackspace client.qm…qn}qo(h"hjh#hhubaubcdocutils.nodes literal_block qp)qq}qr(h"Xûuse OpenCloud\Rackspace; use OpenCloud\Common\Constants\State; $client = new Rackspace(Rackspace::US_IDENTITY_ENDPOINT, array( 'username' => '', 'apiKey' => '' ));h#hbh$h%h&U literal_blockqsh(}qt(U xml:spacequUpreserveqvh-]h,]h*]h+]qw(UcodeqxXphpqyeh/]uh1Kh2hh]qzcdocutils.nodes inline q{)q|}q}(h"Xûuse OpenCloud\Rackspace; use OpenCloud\Common\Constants\State; $client = new Rackspace(Rackspace::US_IDENTITY_ENDPOINT, array( 'username' => '', 'apiKey' => '' ));h(}q~(h*]h+]qUotherq€ah,]h-]h/]uh#hqh]qh;Xûuse OpenCloud\Rackspace; use OpenCloud\Common\Constants\State; $client = new Rackspace(Rackspace::US_IDENTITY_ENDPOINT, array( 'username' => '', 'apiKey' => '' ));q‚…qƒ}q„(h"Uh#h|ubah&Uinlineq…ubaubeubh)q†}q‡(h"Uh#hTh$h%h&h'h(}qˆ(h*]h+]h,]h-]q‰hah/]qŠhauh1Kh2hh]q‹(h4)qŒ}q(h"X%2. Create a database server instance.qŽh#h†h$h%h&h8h(}q(h*]h+]h,]h-]h/]uh1Kh2hh]qh;X%2. Create a database server instance.q‘…q’}q“(h"hŽh#hŒubaubhp)q”}q•(h"Xç$databaseService = $client->databaseService('cloudDatabases', 'DFW'); $twoGbFlavor = $databaseService->flavor(3); $dbInstance = $databaseService->instance(); $dbInstance->name = 'Demo database instance'; $dbInstance->volume = new stdClass(); $dbInstance->volume->size = 20; // GB $dbInstance->flavor = $twoGbFlavor; $dbInstance->create(); $dbInstance->waitFor(State::ACTIVE, null, function ($dbInstance) { printf("Database instance build status: %s\n", $dbInstance->status); });h#h†h$h%h&hsh(}q–(huhvh-]h,]h*]h+]q—(hxXphpq˜eh/]uh1K-h2hh]q™h{)qš}q›(h"Xç$databaseService = $client->databaseService('cloudDatabases', 'DFW'); $twoGbFlavor = $databaseService->flavor(3); $dbInstance = $databaseService->instance(); $dbInstance->name = 'Demo database instance'; $dbInstance->volume = new stdClass(); $dbInstance->volume->size = 20; // GB $dbInstance->flavor = $twoGbFlavor; $dbInstance->create(); $dbInstance->waitFor(State::ACTIVE, null, function ($dbInstance) { printf("Database instance build status: %s\n", $dbInstance->status); });h(}qœ(h*]h+]qUotherqžah,]h-]h/]uh#h”h]qŸh;Xç$databaseService = $client->databaseService('cloudDatabases', 'DFW'); $twoGbFlavor = $databaseService->flavor(3); $dbInstance = $databaseService->instance(); $dbInstance->name = 'Demo database instance'; $dbInstance->volume = new stdClass(); $dbInstance->volume->size = 20; // GB $dbInstance->flavor = $twoGbFlavor; $dbInstance->create(); $dbInstance->waitFor(State::ACTIVE, null, function ($dbInstance) { printf("Database instance build status: %s\n", $dbInstance->status); });q …q¡}q¢(h"Uh#hšubah&h…ubaubh?)q£}q¤(h"XƒThe example above creates a database server instance with 20GB of disk space and 2GB of memory, then waits for it to become ACTIVE.q¥h#h†h$h%h&hBh(}q¦(h*]h+]h,]h-]h/]uh1K.h2hh]q§h;XƒThe example above creates a database server instance with 20GB of disk space and 2GB of memory, then waits for it to become ACTIVE.q¨…q©}qª(h"h¥h#h£ubaubeubh)q«}q¬(h"Uh#hTh$h%h&h'h(}q­(h*]h+]h,]h-]q®hah/]q¯h auh1K2h2hh]q°(h4)q±}q²(h"X53. Create a database on the database server instance.q³h#h«h$h%h&h8h(}q´(h*]h+]h,]h-]h/]uh1K2h2hh]qµh;X53. Create a database on the database server instance.q¶…q·}q¸(h"h³h#h±ubaubhp)q¹}qº(h"XE$db = $dbInstance->database(); $db->name = 'demo_db'; $db->create();h#h«h$h%h&hsh(}q»(huhvh-]h,]h*]h+]q¼(hxXphpq½eh/]uh1K:h2hh]q¾h{)q¿}qÀ(h"XE$db = $dbInstance->database(); $db->name = 'demo_db'; $db->create();h(}qÁ(h*]h+]qÂUotherqÃah,]h-]h/]uh#h¹h]qÄh;XE$db = $dbInstance->database(); $db->name = 'demo_db'; $db->create();qÅ…qÆ}qÇ(h"Uh#h¿ubah&h…ubaubh?)qÈ}qÉ(h"XtThe example above creates a database named ``demo_db`` on the database server instance created in the previous step.h#h«h$h%h&hBh(}qÊ(h*]h+]h,]h-]h/]uh1K;h2hh]qË(h;X+The example above creates a database named qÌ…qÍ}qÎ(h"X+The example above creates a database named h#hÈubcdocutils.nodes literal qÏ)qÐ}qÑ(h"X ``demo_db``h(}qÒ(h*]h+]h,]h-]h/]uh#hÈh]qÓh;Xdemo_dbqÔ…qÕ}qÖ(h"Uh#hÐubah&Uliteralq×ubh;X> on the database server instance created in the previous step.qØ…qÙ}qÚ(h"X> on the database server instance created in the previous step.h#hÈubeubeubh)qÛ}qÜ(h"Uh#hTh$h%h&h'h(}qÝ(h*]h+]h,]h-]qÞhah/]qßh auh1K?h2hh]qà(h4)qá}qâ(h"X74. Create database user and give it access to database.qãh#hÛh$h%h&h8h(}qä(h*]h+]h,]h-]h/]uh1K?h2hh]qåh;X74. Create database user and give it access to database.qæ…qç}qè(h"hãh#háubaubhp)qé}qê(h"XŠ$user = $dbInstance->user(); $user->name = 'demo_user'; $user->password = 'h@X0r!'; $user->databases = array('demo_db'); $user->create();h#hÛh$h%h&hsh(}që(huhvh-]h,]h*]h+]qì(hxXphpqíeh/]uh1KIh2hh]qîh{)qï}qð(h"XŠ$user = $dbInstance->user(); $user->name = 'demo_user'; $user->password = 'h@X0r!'; $user->databases = array('demo_db'); $user->create();h(}qñ(h*]h+]qòUotherqóah,]h-]h/]uh#héh]qôh;XŠ$user = $dbInstance->user(); $user->name = 'demo_user'; $user->password = 'h@X0r!'; $user->databases = array('demo_db'); $user->create();qõ…qö}q÷(h"Uh#hïubah&h…ubaubh?)qø}qù(h"XžThe example above creates a database user named ``demo_user``, sets its password and gives it access to the ``demo_db`` database created in the previous step.h#hÛh$h%h&hBh(}qú(h*]h+]h,]h-]h/]uh1KJh2hh]qû(h;X0The example above creates a database user named qü…qý}qþ(h"X0The example above creates a database user named h#høubhÏ)qÿ}r(h"X ``demo_user``h(}r(h*]h+]h,]h-]h/]uh#høh]rh;X demo_userr…r}r(h"Uh#hÿubah&h×ubh;X/, sets its password and gives it access to the r…r}r(h"X/, sets its password and gives it access to the h#høubhÏ)r }r (h"X ``demo_db``h(}r (h*]h+]h,]h-]h/]uh#høh]r h;Xdemo_dbr …r}r(h"Uh#j ubah&h×ubh;X' database created in the previous step.r…r}r(h"X' database created in the previous step.h#høubeubeubh)r}r(h"Uh#hTh$h%h&h'h(}r(h*]h+]h,]h-]rhah/]rh auh1KOh2hh]r(h4)r}r(h"X[5. Optional step: Create a load balancer to allow access to the database from the Internet.rh#jh$h%h&h8h(}r(h*]h+]h,]h-]h/]uh1KOh2hh]rh;X[5. Optional step: Create a load balancer to allow access to the database from the Internet.r…r}r (h"jh#jubaubh?)r!}r"(h"XThe database created in the previous step can only be accessed from the Rackspace private network (aka ``SERVICENET``). If you have a cloud server instance in the same region as the database server instance, you will be able to connect to the database from that cloud server instance.h#jh$h%h&hBh(}r#(h*]h+]h,]h-]h/]uh1KQh2hh]r$(h;XgThe database created in the previous step can only be accessed from the Rackspace private network (aka r%…r&}r'(h"XgThe database created in the previous step can only be accessed from the Rackspace private network (aka h#j!ubhÏ)r(}r)(h"X``SERVICENET``h(}r*(h*]h+]h,]h-]h/]uh#j!h]r+h;X SERVICENETr,…r-}r.(h"Uh#j(ubah&h×ubh;X§). If you have a cloud server instance in the same region as the database server instance, you will be able to connect to the database from that cloud server instance.r/…r0}r1(h"X§). If you have a cloud server instance in the same region as the database server instance, you will be able to connect to the database from that cloud server instance.h#j!ubeubh?)r2}r3(h"XõIf, however, you would like to access the database from the Internet, you will need to create a load balancer with an IP address that is routable from the Internet and attach the database server instance as a back-end node of this load balancer.r4h#jh$h%h&hBh(}r5(h*]h+]h,]h-]h/]uh1KVh2hh]r6h;XõIf, however, you would like to access the database from the Internet, you will need to create a load balancer with an IP address that is routable from the Internet and attach the database server instance as a back-end node of this load balancer.r7…r8}r9(h"j4h#j2ubaubhp)r:}r;(h"X›$loadBalancerService = $client->loadBalancerService('cloudLoadBalancers', 'DFW'); $loadBalancer = $loadBalancerService->loadBalancer(); $loadBalancer->name = 'Load balancer - DB'; $loadBalancer->addNode($dbInstance->hostname, 3306); $loadBalancer->port = 3306; $loadBalancer->protocol = 'MYSQL'; $loadBalancer->addVirtualIp('PUBLIC'); $loadBalancer->create(); $loadBalancer->waitFor(State::ACTIVE, null, function ($lb) { printf("Load balancer build status: %s\n", $lb->status); }); foreach ($loadBalancer->virtualIps as $vip) { if ($vip->type == 'PUBLIC') { printf("Load balancer public %s address: %s\n", $vip->ipVersion, $vip->address); } }h#jh$h%h&hsh(}r<(huhvh-]h,]h*]h+]r=(hxXphpr>eh/]uh1Krh2hh]r?h{)r@}rA(h"X›$loadBalancerService = $client->loadBalancerService('cloudLoadBalancers', 'DFW'); $loadBalancer = $loadBalancerService->loadBalancer(); $loadBalancer->name = 'Load balancer - DB'; $loadBalancer->addNode($dbInstance->hostname, 3306); $loadBalancer->port = 3306; $loadBalancer->protocol = 'MYSQL'; $loadBalancer->addVirtualIp('PUBLIC'); $loadBalancer->create(); $loadBalancer->waitFor(State::ACTIVE, null, function ($lb) { printf("Load balancer build status: %s\n", $lb->status); }); foreach ($loadBalancer->virtualIps as $vip) { if ($vip->type == 'PUBLIC') { printf("Load balancer public %s address: %s\n", $vip->ipVersion, $vip->address); } }h(}rB(h*]h+]rCUotherrDah,]h-]h/]uh#j:h]rEh;X›$loadBalancerService = $client->loadBalancerService('cloudLoadBalancers', 'DFW'); $loadBalancer = $loadBalancerService->loadBalancer(); $loadBalancer->name = 'Load balancer - DB'; $loadBalancer->addNode($dbInstance->hostname, 3306); $loadBalancer->port = 3306; $loadBalancer->protocol = 'MYSQL'; $loadBalancer->addVirtualIp('PUBLIC'); $loadBalancer->create(); $loadBalancer->waitFor(State::ACTIVE, null, function ($lb) { printf("Load balancer build status: %s\n", $lb->status); }); foreach ($loadBalancer->virtualIps as $vip) { if ($vip->type == 'PUBLIC') { printf("Load balancer public %s address: %s\n", $vip->ipVersion, $vip->address); } }rF…rG}rH(h"Uh#j@ubah&h…ubaubh?)rI}rJ(h"XdIn the example above, a load balancer is created with the database server instance as its only back-end node. Further, this load balancer is configured to listen for MySQL connections on port 3306. Finally a virtual IP address (VIP) is configured in the ``PUBLIC`` network address space so that this load balancer may receive connections from the Internet.h#jh$h%h&hBh(}rK(h*]h+]h,]h-]h/]uh1Ksh2hh]rL(h;XþIn the example above, a load balancer is created with the database server instance as its only back-end node. Further, this load balancer is configured to listen for MySQL connections on port 3306. Finally a virtual IP address (VIP) is configured in the rM…rN}rO(h"XþIn the example above, a load balancer is created with the database server instance as its only back-end node. Further, this load balancer is configured to listen for MySQL connections on port 3306. Finally a virtual IP address (VIP) is configured in the h#jIubhÏ)rP}rQ(h"X ``PUBLIC``h(}rR(h*]h+]h,]h-]h/]uh#jIh]rSh;XPUBLICrT…rU}rV(h"Uh#jPubah&h×ubh;X\ network address space so that this load balancer may receive connections from the Internet.rW…rX}rY(h"X\ network address space so that this load balancer may receive connections from the Internet.h#jIubeubh?)rZ}r[(h"XüOnce the load balancer is created and becomes ``ACTIVE``, it's Internet-accessible IP addresses are printed out. If you connect to any of these IP addresses on port 3306 using the MySQL protocol, you will be connected to the database created in step 3.h#jh$h%h&hBh(}r\(h*]h+]h,]h-]h/]uh1Kzh2hh]r](h;X.Once the load balancer is created and becomes r^…r_}r`(h"X.Once the load balancer is created and becomes h#jZubhÏ)ra}rb(h"X ``ACTIVE``h(}rc(h*]h+]h,]h-]h/]uh#jZh]rdh;XACTIVEre…rf}rg(h"Uh#jaubah&h×ubh;XÄ, it's Internet-accessible IP addresses are printed out. If you connect to any of these IP addresses on port 3306 using the MySQL protocol, you will be connected to the database created in step 3.rh…ri}rj(h"XÄ, it's Internet-accessible IP addresses are printed out. If you connect to any of these IP addresses on port 3306 using the MySQL protocol, you will be connected to the database created in step 3.h#jZubeubeubeubeubah"UU transformerrkNU footnote_refsrl}rmUrefnamesrn}roUsymbol_footnotesrp]rqUautofootnote_refsrr]rsUsymbol_footnote_refsrt]ruU citationsrv]rwh2hU current_linerxNUtransform_messagesry]rzUreporterr{NUid_startr|KU autofootnotesr}]r~U citation_refsr}r€Uindirect_targetsr]r‚Usettingsrƒ(cdocutils.frontend Values r„or…}r†(Ufootnote_backlinksr‡KUrecord_dependenciesrˆNU rfc_base_urlr‰Uhttp://tools.ietf.org/html/rŠU tracebackr‹ˆUpep_referencesrŒNUstrip_commentsrNU toc_backlinksrŽUentryrU language_coderUenr‘U datestampr’NU report_levelr“KU _destinationr”NU halt_levelr•KU strip_classesr–Nh8NUerror_encoding_error_handlerr—Ubackslashreplacer˜Udebugr™NUembed_stylesheetrš‰Uoutput_encoding_error_handlerr›UstrictrœU sectnum_xformrKUdump_transformsržNU docinfo_xformrŸKUwarning_streamr NUpep_file_url_templater¡Upep-%04dr¢Uexit_status_levelr£KUconfigr¤NUstrict_visitorr¥NUcloak_email_addressesr¦ˆUtrim_footnote_reference_spacer§‰Uenvr¨NUdump_pseudo_xmlr©NUexpose_internalsrªNUsectsubtitle_xformr«‰U source_linkr¬NUrfc_referencesr­NUoutput_encodingr®Uutf-8r¯U source_urlr°NUinput_encodingr±U utf-8-sigr²U_disable_configr³NU id_prefixr´UU tab_widthrµKUerror_encodingr¶UUTF-8r·U_sourcer¸h%Ugettext_compactr¹ˆU generatorrºNUdump_internalsr»NU smart_quotesr¼‰U pep_base_urlr½Uhttp://www.python.org/dev/peps/r¾Usyntax_highlightr¿UlongrÀUinput_encoding_error_handlerrÁjœUauto_id_prefixrÂUidrÃUdoctitle_xformrĉUstrip_elements_with_classesrÅNU _config_filesrÆ]Ufile_insertion_enabledrLjU raw_enabledrÈKU dump_settingsrÉNubUsymbol_footnote_startrÊKUidsrË}rÌ(hhThh hhÛhjhh†hh«hhbuUsubstitution_namesrÍ}rÎh&h2h(}rÏ(h*]h-]h,]Usourceh%h+]h/]uU footnotesrÐ]rÑUrefidsrÒ}rÓub.