[Halld-offline] now in production [Re: New DB Servers -- HALLDDB-A and HALLDDB-B Online]

[Mark Ito]

Marty has been stress testing the new systems and has released them to 
us for production use.

The next step will be to change the default URL for work at JLab on the 
farm and otherwise to use the new hallddb-farm.jlab.org DNS alias. I'll 
try to remember to announce that when it is done.

Again, if you want to try it out on your own, see the message quoted below.

On 9/11/19 8:59 PM, Mark Ito wrote:
>
> IT has deployed a new pair of MySQL (MariaDB to be precise) database 
> servers, just for Hall D, just for the farm. You will recall we have 
> had problems with overloading hallddb.jlab.org in the past when too 
> many farm jobs demanded CCDB service. We are going to see if this helps.
>
> The new system is now in alpha test, so for all you volunteer alpha 
> testers, the magic words are:
>
>   export JANA_CALIB_URL=mysql://ccdb_user@hallddb-farm.jlab.org/ccdb
>
> N.B., access is read-only, as is appropriate for farm jobs. That said, 
> read-only access for any purpose should be fine.
>
> See the log entry from Marty Wise below for more details.
>
> -------- Forwarded Message --------
> Subject: 	[New Logentry] New DB Servers -- HALLDDB-A and HALLDDB-B Online
> Date: 	Wed, 11 Sep 2019 16:30:03 -0400
> From: 	wise at jlab.org
> To: 	baltzell at jlab.org, davidl at jlab.org, marki at jlab.org, unixadm at jlab.org
>
>
>
>     New DB Servers -- HALLDDB-A and HALLDDB-B Online
>     <https://cclogbooks.jlab.org/entry/3004234>
>
> Lognumber . Submitted by wise <https://cclogbooks.jlab.org/user/wise> 
> on Wed, 09/11/2019 - 16:29 
> <https://cclogbooks.jlab.org/entries?start_date=1568230140&end_date=1568237340&book=>. 
>
>
> Logbooks: 	SYSTEMLOG <https://cclogbooks.jlab.org/book/systemlog>
>
> Two new MariaDB servers are no online and undergoing final testing 
> prior to placing into production operation. These servers are for 
> Hall-D and will be read-only replicas of the HALLDDB server. They are 
> configured in a DNS round-robin arrangement using the name 
> "HALLDDB-FARM" and are intended to provide DB service to farm jobs. 
> Meanwhile, the legacy server will continue to operate in R/W mode and 
> service other non-farm workloads.
>
> This strategy has been developed to provide additional DB server 
> capacity to address peak loads frequently encountered which crippled 
> the legacy server, or at least crippled other applications running 
> against it.
>
> This same approach is being extended to CLASDB next and should be 
> available within the next few days. Later, similar changes will be 
> introduced to other large DB server systems to alleviate problems due 
> to high connection or computation loads on the existing DB servers.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20190929/0dd1bef3/attachment-0002.html>