{"__v":1,"_id":"5735f173e004e80e00efd3eb","category":{"__v":0,"_id":"5735b9ba4b0ab120000b7dd4","project":"5735936aafab441700723a50","version":"5735936aafab441700723a53","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-13T11:25:46.654Z","from_sync":false,"order":7,"slug":"configuration-options-1","title":"Configuration Options (Hosting)"},"parentDoc":null,"project":"5735936aafab441700723a50","user":"573592b84b0ab120000b7d44","version":{"__v":12,"_id":"5735936aafab441700723a53","project":"5735936aafab441700723a50","createdAt":"2016-05-13T08:42:18.615Z","releaseDate":"2016-05-13T08:42:18.615Z","categories":["5735936aafab441700723a54","5735a32931a73b1700887c94","5735b55beceb872200abbc6c","5735b56eb667601700d3bd6f","5735b9ba4b0ab120000b7dd4","5735b9c94b0ab120000b7dd5","5735cb131f16241700c8a0f7","5735e5c4e4824c3400aa1f21","5735e5d9e4824c3400aa1f23","5735e5f2ec67f6290013ac72","573ecfe0804f901700a9dfc7","573f276c7eeb8b190094ca7d"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":false,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-13T15:23:31.171Z","link_external":false,"link_url":"","githubsync":"","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``