https://halldweb.jlab.org/wiki/index.php?title=Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship&feed=atom&action=history
Hall D MySQL/MariaDB Servers and Replication Relationship - Revision history
2024-03-29T13:59:57Z
Revision history for this page on the wiki
MediaWiki 1.24.1
https://halldweb.jlab.org/wiki/index.php?title=Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship&diff=67486&oldid=prev
Marki at 19:04, 28 May 2015
2015-05-28T19:04:13Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 19:04, 28 May 2015</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 74:</td>
<td colspan="2" class="diff-lineno">Line 74:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|}  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|}  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">From Marty Wise<br/></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>--[[User:Marki|marki]] ([[User talk:Marki|talk]]) 15:03, 28 May 2015 (EDT)</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>--[[User:Marki|marki]] ([[User talk:Marki|talk]]) 15:03, 28 May 2015 (EDT)</div></td></tr>
</table>
Marki
https://halldweb.jlab.org/wiki/index.php?title=Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship&diff=67485&oldid=prev
Marki: from Marty Wise
2015-05-28T19:03:38Z
<p>from Marty Wise</p>
<p><b>New page</b></p><div>{| border<br />
|-<br />
!<br />
MasterServer.DB<br />
!<br />
SlaveServer<br />
!<br />
Status<br />
!<br />
NOTES<br />
|-<br />
|<br />
hallddb.*<br />
|<br />
hallddb-ext<br />
|<br />
Production<br />
|<br />
Full replication of all DBs. Slave is operated Read-only and visible from off-site. External DNS advertises slave as hallddb.jlab.org<br />
|-<br />
|<br />
gluondb1.*<br />
|<br />
gluondb2<br />
|<br />
Production<br />
|<br />
Full replication of all DBs. Slave is used for backups. Not currently (yet) configured to be readonly.<br />
|-<br />
|<br />
hallddb.ccdb<br />
|<br />
gluondb1<br />
|<br />
Production<br />
|<br />
Only the CCDB Database is replicated, no changes to it should be made on GLUONDB1<br />
|-<br />
|<br />
halldweb.gluonwikidb<br />
|<br />
gluonweb<br />
|<br />
Under construction<br />
|<br />
Only the DB for the Gluex Wiki is replicated. No changes to it should be made on GLUONWEB<br />
|-<br />
|<br />
halldweb.hdopswiki<br />
|<br />
gluonweb<br />
|<br />
Under Construction<br />
|<br />
Only the DB for the HDOPS Wiki is replicated. No changes to it should be made on GLUONWEB<br />
|-<br />
|<br />
hallddb.ccdb<br />
|<br />
gluondb1<br />
|<br />
Production<br />
|<br />
Only the ccdb database is replicated to GLUONDB1<br />
|-<br />
|<br />
gluondb1.rcdb<br />
|<br />
hallddb<br />
|<br />
Production<br />
|<br />
Only the rcdb database is replicated to HALLDDB<br />
|} <br />
<br />
--[[User:Marki|marki]] ([[User talk:Marki|talk]]) 15:03, 28 May 2015 (EDT)</div>
Marki