Difference between revisions of "Hall D MySQL/MariaDB Servers and Replication Relationship"

From GlueXWiki
Jump to: navigation, search
(from Marty Wise)
 
 
Line 74: Line 74:
 
|}  
 
|}  
  
 +
From Marty Wise<br/>
 
--[[User:Marki|marki]] ([[User talk:Marki|talk]]) 15:03, 28 May 2015 (EDT)
 
--[[User:Marki|marki]] ([[User talk:Marki|talk]]) 15:03, 28 May 2015 (EDT)

Latest revision as of 15:04, 28 May 2015

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)