Portal:Cloud VPS/Admin/DB
Material may not yet be complete, information may presently be omitted, and certain parts of the content may be subject to radical, rapid alteration. More information pertaining to this may be available on the talk page.
This page describes the DB (database) usage by our Openstack deployments.
Databases
Production deployments must use a production database server/service, probably m5-master.eqiad.wmnet in coordination with the DBA team. Some deployments use a local mysql database in the control boxes.
Each component of Openstack uses a different database: nova, nova-api, glance, keystone, neutron, etc.
GRANTS
Openstack services require a specific set of database GRANTs to work:
TODO: elaborate
Connection throttling
We had some issues in the past because Openstack assumes unlimited usage capabilities in the database. This is not true in our case, specially in production, since m5-master.eqiad.wmnet is shared with other different services.
TODO: elaborate in what has been done by Brooke to throttle connections.