{"_id":"58c10f5a2c3c720f00768bc0","parentDoc":null,"version":{"_id":"58c10f5a2c3c720f00768b87","project":"5735936aafab441700723a50","__v":4,"createdAt":"2017-03-09T08:16:26.385Z","releaseDate":"2017-03-09T08:16:26.385Z","categories":["58c10f5a2c3c720f00768b88","58c10f5a2c3c720f00768b89","58c10f5a2c3c720f00768b8a","58c10f5a2c3c720f00768b8b","58c10f5a2c3c720f00768b8c","58c10f5a2c3c720f00768b8d","58c10f5a2c3c720f00768b8e","58c10f5a2c3c720f00768b8f","58c10f5a2c3c720f00768b90","58c10f5a2c3c720f00768b91","58c10f5a2c3c720f00768b92","58c10f5a2c3c720f00768b93","58c11574b36d8c0f006fda47","58c2cdcafc6eed3900e97640","58c2ce8afc6eed3900e97663"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"2.0.0","version":"2.0"},"githubsync":"","user":"573592b84b0ab120000b7d44","__v":0,"project":"5735936aafab441700723a50","category":{"_id":"58c10f5a2c3c720f00768b8f","version":"58c10f5a2c3c720f00768b87","project":"5735936aafab441700723a50","__v":0,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-13T11:25:46.654Z","from_sync":false,"order":10,"slug":"configuration-options-1","title":"Configuration Options (Hosting)"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-13T15:23:31.171Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":0,"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``","excerpt":"","slug":"database","type":"basic","title":"[DATABASE]"}
``` [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``