You can configure OpenStack Compute to use any
SQLAlchemy-compatible database. The database name is
nova. The nova-conductor service is the
only service that writes to the database. The other Compute
services access the database through the nova-conductor service.
To ensure that the database schema is current, run the following command:
$ nova-manage db sync
If nova-conductor
is not used, entries to the database are mostly written by the
nova-scheduler
service, although all the services need to be able to update
entries in the database.
In either case, use these settings to configure the connection string for the nova database.
| Configuration option=Default value | Description |
| backend=sqlalchemy | (StrOpt) The backend to use for db |
| connection_trace=False | (BoolOpt) Add python stack traces to SQL as comment strings |
| connection=sqlite:////home/docwork/openstack-manuals-new/tools/autogenerate-config-docs/nova/nova/openstack/common/db/$sqlite_db | (StrOpt) The SQLAlchemy connection string used to connect to the database |
| connection_debug=0 | (IntOpt) Verbosity of SQL debugging information. 0=None, 100=Everything |
| db_backend=sqlalchemy | (StrOpt) The backend to use for bare-metal database |
| db_check_interval=60 | (IntOpt) Seconds between getting fresh cell info from db. |
| db_driver=nova.db | (StrOpt) driver to use for database access |
| idle_timeout=3600 | (IntOpt) timeout before idle sql connections are reaped |
| max_pool_size=None | (IntOpt) Maximum number of SQL connections to keep open in a pool |
| max_overflow=None | (IntOpt) If set, use this value for max_overflow with sqlalchemy |
| max_retries=10 | (IntOpt) maximum db connection retries during startup. (setting -1 implies an infinite retry count) |
| min_pool_size=1 | (IntOpt) Minimum number of SQL connections to keep open in a pool |
| pool_timeout=None | (IntOpt) If set, use this value for pool_timeout with sqlalchemy |
| retry_interval=10 | (IntOpt) interval between retries of opening a sql connection |
| slave_connection= | (StrOpt) The SQLAlchemy connection string used to connect to the slave database |
| sql_connection=sqlite:///$state_path/baremetal_$sqlite_db | (StrOpt) The SQLAlchemy connection string used to connect to the bare-metal database |
| sqlite_db=nova.sqlite | (StrOpt) the filename to use with sqlite |
| sqlite_synchronous=True | (BoolOpt) If true, use synchronous mode for sqlite |
