Database
========

We support only Postgres database.

Multiple hosts
--------------

The `dsn` parameter of service database config should be specified to enable multihost option for Postgres.

DSN may be specified in the following format: `luna:luna@postgres01:5432,postgres02:5432/luna_video_manager?some_option=some_value`.
It is possible to partially fill in the DSN string (e.g. `postgres01,postgres02/luna_video_manager`), and then the missing parameters will be filled in from proprietary parameter values (or defaults).

At startup, the service will create a pool of connections to one of DSN hosts available.
In case of problems with establishing a connection after several unsuccessful attempts, the service will again try to set up a connection pool to any of DSN hosts available.

DB scheme
---------
.. image:: video_manager_db.png

.. automodule:: luna_video_manager.db.video_manager_db_tools.models.video_manager_models
	:members: