David.desrosiers: David.desrosiers moved page Databases to OpsGuide/Databases without leaving a redirect

2017-11-14T02:53:33Z

David.desrosiers moved page Databases to OpsGuide/Databases without leaving a redirect

David.desrosiers: Created page with "Almost all OpenStack components have an underlying database to store persistent information. Usually this database is MySQL. Normal MySQL administration is applicable to these..."

2017-11-13T20:11:56Z

Created page with "Almost all OpenStack components have an underlying database to store persistent information. Usually this database is MySQL. Normal MySQL administration is applicable to these..."

New page

Almost all OpenStack components have an underlying database to store persistent information. Usually this database is MySQL. Normal MySQL administration is applicable to these databases. OpenStack does not configure the databases out of the ordinary. Basic administration includes performance tweaking, high availability, backup, recovery, and repairing. For more information, see a standard MySQL administration guide.

You can perform a couple of tricks with the database to either more quickly retrieve information or fix a data inconsistency error—for example, an instance was terminated, but the status was not updated in the database. These tricks are discussed throughout this book.

== <div id="database-connectivity"> Database Connectivity</div> ==

Review the component’s configuration file to see how each OpenStack component accesses its corresponding database. Look for a <code>connection</code> option. The following command uses <code>grep</code> to display the SQL connection string for nova, glance, cinder, and keystone:

<syntaxhighlight lang=shell style="border:2px solid #ccc;">
# grep -hE "connection ?=" \
/etc/nova/nova.conf /etc/glance/glance-*.conf \
/etc/cinder/cinder.conf /etc/keystone/keystone.conf \
/etc/neutron/neutron.conf
connection = mysql+pymysql://nova:password@cloud.example.com/nova
connection = mysql+pymysql://glance:password@cloud.example.com/glance
connection = mysql+pymysql://glance:password@cloud.example.com/glance
connection = mysql+pymysql://cinder:password@cloud.example.com/cinder
connection = mysql+pymysql://keystone:password@cloud.example.com/keystone
connection = mysql+pymysql://neutron:password@cloud.example.com/neutron</syntaxhighlight>
The connection strings take this format:

<pre>mysql+pymysql:// <username> : <password> @ <hostname> / <database name></pre>
== <div id="performance-and-optimizing"> Performance and Optimizing</div> ==

As your cloud grows, MySQL is utilized more and more. If you suspect that MySQL might be becoming a bottleneck, you should start researching MySQL optimization. The MySQL manual has an entire section dedicated to this topic: [http://dev.mysql.com/doc/refman/5.5/en/optimize-overview.html Optimization Overview].&

← Older revision	Revision as of 02:53, 14 November 2017
(No difference)

OpsGuide/Databases - Revision history

David.desrosiers: David.desrosiers moved page Databases to OpsGuide/Databases without leaving a redirect

David.desrosiers: Created page with "Almost all OpenStack components have an underlying database to store persistent information. Usually this database is MySQL. Normal MySQL administration is applicable to these..."