<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Folks,<br>
<br>
FYI, Marty sent me a list of our database servers; see his message
below.<br>
<br>
I've wikitized it and posted it at<br>
<br>
<div class="moz-forward-container">
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/wiki/index.php/Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship">https://halldweb.jlab.org/wiki/index.php/Hall_D_MySQL/MariaDB_Servers_and_Replication_Relationship</a><br>
<br>
and linked it from the offline software wiki page.<br>
<br>
-- Mark<br>
<br>
-------- Forwarded Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Subject:
</th>
<td>DB replication setups for Hall D</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Date: </th>
<td>Tue, 26 May 2015 09:37:53 -0400 (EDT)</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">From: </th>
<td>Marty Wise <a class="moz-txt-link-rfc2396E" href="mailto:wise@jlab.org"><wise@jlab.org></a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">To: </th>
<td>'Mark Ito' <a class="moz-txt-link-rfc2396E" href="mailto:marki@jlab.org"><marki@jlab.org></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
margin-top:6.0pt;
margin-right:0in;
margin-bottom:.15in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Mark,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">A while back, you asked me for the list of
MySQL/MariaDB servers used in Hall D that provides the
replication relationships between them -- <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" style="border-collapse:collapse"
border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="4"
style="width:735.75pt;border:none;padding:.75pt .75pt
.75pt .75pt" width="981">
<p class="MsoNormal" style="text-align:center"
align="center"><b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Hall
D MySQL/MariaDB Servers and Replication
Relationships</span></b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">MasterServer.DB</span></b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt .75pt"
width="110">
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">SlaveServer</span></b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt .75pt"
valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Status<o:p></o:p></span></b></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt .75pt"
width="591">
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">NOTES</span></b><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:24.6pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:24.6pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">hallddb.*<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:24.6pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">hallddb-ext<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:24.6pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Production<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:24.6pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Full
replication of all DBs. Slave is operated Read-only
and visible from off-site. External DNS advertises
slave as hallddb.jlab.org<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:29.1pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:29.1pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluondb1.*<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:29.1pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluondb2<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:29.1pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Production<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:29.1pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Full
replication of all DBs. Slave is used for backups.
Not currently (yet) configured to be readonly.<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.6pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:15.6pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">hallddb.ccdb<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluondb1<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Production<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Only
the CCDB Database is replicated, no changes to it
should be made on GLUONDB1<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:20.1pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:20.1pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">halldweb.gluonwikidb<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:20.1pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluonweb<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:20.1pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Under
construction<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:20.1pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Only
the DB for the Gluex Wiki is replicated. No changes
to it should be made on GLUONWEB<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.6pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:15.6pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">halldweb.hdopswiki<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluonweb<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Under
Construction<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Only
the DB for the HDOPS Wiki is replicated. No changes
to it should be made on GLUONWEB<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.6pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:15.6pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">hallddb.ccdb<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluondb1<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Production<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:15.6pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Only
the ccdb database is replicated to GLUONDB1<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:.75pt .75pt .75pt .75pt;height:16.5pt">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">gluondb1.rcdb<o:p></o:p></span></p>
</td>
<td style="width:1.15in;padding:.75pt .75pt .75pt
.75pt;height:16.5pt" width="110">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">hallddb<o:p></o:p></span></p>
</td>
<td style="width:1.5in;padding:.75pt .75pt .75pt
.75pt;height:16.5pt" valign="top" width="144">
<p class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Production<o:p></o:p></span></p>
</td>
<td style="width:443.25pt;padding:.75pt .75pt .75pt
.75pt;height:16.5pt" width="591">
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black">Only
the rcdb database is replicated to HALLDDB<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Marty Wise (<a moz-do-not-send="true"
href="mailto:wise@jlab.org"><span style="color:blue">wise@jlab.org</span></a>)<br>
JLab IT/CNI<o:p></o:p></p>
</div>
<br>
</div>
<br>
</body>
</html>