{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"required","results":{"codes":[]},"settings":"","params":[]},"next":{"description":"","pages":[]},"title":"[DATABASE]","type":"basic","slug":"database","excerpt":"","body":"```\n[DATABASE]\n  DB_HOST = localhost\n  DB_PORT = 3306\n  DB_USER = anonymous\n  DB_PASS =\n\n  DB_SESSION_HOST = localhost\n  DB_SESSION_PORT = 3306\n  DB_SESSION_USER = ensrw\n  DB_SESSION_PASS = ensrw\n\n  DB_FALLBACK_HOST = mysql-eg-publicsql.ebi.ac.uk\n  DB_FALLBACK_PORT = 4157\n  DB_FALLBACK_USER = anonymous\n  DB_FALLBACK_PASS =\n\n  DB_FALLBACK2_HOST = ensembldb.ensembl.org\n  DB_FALLBACK2_PORT = 3306\n  DB_FALLBACK2_USER = anonymous\n  DB_FALLBACK2_PASS =\n```\nFour subsections with ``DB_[*_]HOST``, ``DB_[*_]PORT``, ``DB_[*_]USER`` and ``DB_[*_]PASS`` variables specify connection settings for:\n- ``DB_HOST`` etc. - the primary database host with species/multi-species databases.\n- ``DB_SESSION_HOST`` etc. - user-specific information, typically the only database to require read-write access and therefore a password protected connection.\n- ``DB_FALLBACK_HOST`` etc. - to reduce the amount of locally hosted data, it is often desirable to use alternate sources for some databases, the ``DB_FALLBACK_HOST`` host will be queried to find any required databases that are not available on ``DB_HOST``\n- ``DB_FALLBACK2_HOST`` etc. - especially with EnsemblGenomes sites, remote databases may be found on more than one host, the ``DB_FALLBACK2_HOST`` host will be queried to find any required databases that are not available on ``DB_HOST`` or ``DB_FALLBACK_HOST``","updates":[],"order":0,"isReference":false,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"58c10f5a2c3c720f00768bc0","parentDoc":null,"version":{"version":"2.0","version_clean":"2.0.0","codename":"","is_stable":true,"is_beta":false,"is_hidden":false,"is_deprecated":false,"categories":["58c10f5a2c3c720f00768b88","58c10f5a2c3c720f00768b89","58c10f5a2c3c720f00768b8a","58c10f5a2c3c720f00768b8b","58c10f5a2c3c720f00768b8c","58c10f5a2c3c720f00768b8d","58c10f5a2c3c720f00768b8e","58c10f5a2c3c720f00768b8f","58c10f5a2c3c720f00768b90","58c10f5a2c3c720f00768b91","58c10f5a2c3c720f00768b92","58c10f5a2c3c720f00768b93","58c11574b36d8c0f006fda47","58c2cdcafc6eed3900e97640","58c2ce8afc6eed3900e97663"],"_id":"58c10f5a2c3c720f00768b87","project":"5735936aafab441700723a50","releaseDate":"2017-03-09T08:16:26.385Z","createdAt":"2017-03-09T08:16:26.385Z","__v":4},"createdAt":"2016-05-13T15:23:31.171Z","githubsync":"","user":"573592b84b0ab120000b7d44","__v":0,"project":"5735936aafab441700723a50","category":{"sync":{"isSync":false,"url":""},"pages":[],"title":"Configuration Options (Hosting)","slug":"configuration-options-1","order":10,"from_sync":false,"reference":false,"_id":"58c10f5a2c3c720f00768b8f","version":"58c10f5a2c3c720f00768b87","createdAt":"2016-05-13T11:25:46.654Z","project":"5735936aafab441700723a50","__v":0}}
``` [DATABASE] DB_HOST = localhost DB_PORT = 3306 DB_USER = anonymous DB_PASS = DB_SESSION_HOST = localhost DB_SESSION_PORT = 3306 DB_SESSION_USER = ensrw DB_SESSION_PASS = ensrw DB_FALLBACK_HOST = mysql-eg-publicsql.ebi.ac.uk DB_FALLBACK_PORT = 4157 DB_FALLBACK_USER = anonymous DB_FALLBACK_PASS = DB_FALLBACK2_HOST = ensembldb.ensembl.org DB_FALLBACK2_PORT = 3306 DB_FALLBACK2_USER = anonymous DB_FALLBACK2_PASS = ``` Four subsections with ``DB_[*_]HOST``, ``DB_[*_]PORT``, ``DB_[*_]USER`` and ``DB_[*_]PASS`` variables specify connection settings for: - ``DB_HOST`` etc. - the primary database host with species/multi-species databases. - ``DB_SESSION_HOST`` etc. - user-specific information, typically the only database to require read-write access and therefore a password protected connection. - ``DB_FALLBACK_HOST`` etc. - to reduce the amount of locally hosted data, it is often desirable to use alternate sources for some databases, the ``DB_FALLBACK_HOST`` host will be queried to find any required databases that are not available on ``DB_HOST`` - ``DB_FALLBACK2_HOST`` etc. - especially with EnsemblGenomes sites, remote databases may be found on more than one host, the ``DB_FALLBACK2_HOST`` host will be queried to find any required databases that are not available on ``DB_HOST`` or ``DB_FALLBACK_HOST``