[Halld-online] Fwd: DB replication setups for Hall D

[Mark Ito]

Folks,

FYI, Marty sent me a list of our database servers; see his message below.

I've wikitized it and posted it at

https://halldweb.jlab.org/wiki/index.php/Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship

and linked it from the offline software wiki page.

   -- Mark

-------- Forwarded Message --------
Subject: 	DB replication setups for Hall D
Date: 	Tue, 26 May 2015 09:37:53 -0400 (EDT)
From: 	Marty Wise <wise at jlab.org>
To: 	'Mark Ito' <marki at jlab.org>



Mark,

A while back, you asked me for the list of MySQL/MariaDB servers used in 
Hall D that provides the replication relationships between them --

*Hall D MySQL/MariaDB Servers and Replication Relationships*

*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

Marty Wise (wise at jlab.org <mailto:wise at jlab.org>)
JLab IT/CNI



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-online/attachments/20150528/62058f25/attachment.html>