Hall D MySQL/MariaDB Servers and Replication Relationship

From GlueXWiki
Jump to: navigation, search

MasterServer.DB

SlaveServer

Status

NOTES

hallddb.*

hallddb-ext

Production

Full replication of all DBs. Slave is operated Read-only and visible from off-site. External DNS advertises slave as hallddb.jlab.org

gluondb1.*

gluondb2

Production

Full replication of all DBs. Slave is used for backups. Not currently (yet) configured to be readonly.

hallddb.ccdb

gluondb1

Production

Only the CCDB Database is replicated, no changes to it should be made on GLUONDB1

halldweb.gluonwikidb

gluonweb

Under construction

Only the DB for the Gluex Wiki is replicated. No changes to it should be made on GLUONWEB

halldweb.hdopswiki

gluonweb

Under Construction

Only the DB for the HDOPS Wiki is replicated. No changes to it should be made on GLUONWEB

hallddb.ccdb

gluondb1

Production

Only the ccdb database is replicated to GLUONDB1

gluondb1.rcdb

hallddb

Production

Only the rcdb database is replicated to HALLDDB

From Marty Wise
--marki (talk) 15:03, 28 May 2015 (EDT)