From: Christian Holm Christensen (cholm@hehi03.nbi.dk)
Date: Fri Sep 26 2003 - 05:40:18 EDT
Hi Flemming et al, [Mail sent to brahms-dev-l, not the original recipients, as per Flemmings request (see below)] Flemming Videbaek <fvidebaek@optonline.net> wrote concerning Fw: brahms-db0 [Thu, 25 Sep 2003 18:07:37 -0400] ---------------------------------------------------------------------- > I have gotten the following suggestions from Tony. I will like to > know if there are comments to such a move. I think it's a splendid idea. MySQL has matured a lot lately (transactions, etc.), so we'd probably get a more stable server (though I can't remember having trouble with the MySQL server at all :-) If RCF is willing to do the conversion to the new format, or at least give us clear and concise instructions, then I'm happy. Come to think of it, I think RCF _has_ to do it for us, as the database is located in system directories (/var/lib/mysql or something). > It might also imply we should update on the pii's too. What are the > considerations to be aware of? I don't know the specifics, but I would guess that the MySQL server is backward compatible with the clients. However, if that's not the case, we probably only need to upgrade the client libraries, recompile ROOT and BRAT, and we're done. Oh, just remembered we have our own MySQL server for the run and conditions database. Hmm. Perhaps we should upgrade that too. Presumably it's simple. My guess is, that MySQL has some instructions on their web-page for the transition process. > Flemming > > > PS I sent this from home so therefore the limite distribution, but I > think I included those who may have an interest later e-mails can go > to dev-l This message puts it on brahms-dev-l :-) > ----- Original Message ----- > From: "Tony W. Chan" <tony@bnl.gov> > To: <videbaek@bnl.gov> > Cc: <hollowec@bnl.gov> > Sent: Thursday, September 25, 2003 5:49 PM > Subject: brahms-db0 > > > | Flemming, > | > | BRAHMS still has brahms-db0 running RH 7.2 with an old version > | of MySQL (3.23.49a). Are you interested in upgrading the OS to > | RH 8.0 and to a new version of MySQL (4.0.12)? Really old Red Hat - let's kill that beast :-) For this machine, it might actually be a good idea to use the 2.6 kernel when it's released. The new kernel threads means much better threads, and as the MySQL server is aggressively threaded, it could probably benefit a lot from that. > | The db file formats in 3.23.49a are no longer supported by MySQL, > | so they would have to be converted to a new format. We've done > | that in the past in our own db machines. So I guess it's a simple procedure. > | As in the case of other software packages, the new MySQL version > | fixes some bugs, improves performance and reliability, at least > | according to their Web site. Well, that's usually how things work in the FLOSS (Free/Libre/OpenSource Software) world, but not necessarily true in the proprietary world (think of Win95 -> Win98 - jikes). > | Let me know if you are interested so we can make preparations. > | I would imagine that if you want to upgrade, it has to be done > | in advance of the next RHIC run, but after whatever re-pass of > | any reconstruction you may be planning. Yes, before the run, so that we can test it a bit. Perhaps we should set up a test database server first? Another possibility with the new MySQL server is to do replication. We could exploit that by having to database host (the existing brahms-db0 and an old rcas machine converted to brahms-db1), both having the exact same databases via replication. In that way, we have redundancy to deal with failures. Perhaps the replicating host should be somewhere else than at BNL? Yours, ___ | Christian Holm Christensen |_| | ------------------------------------------------------------- | | Address: Sankt Hansgade 23, 1. th. Phone: (+45) 35 35 96 91 _| DK-2200 Copenhagen N Cell: (+45) 24 61 85 91 _| Denmark Office: (+45) 353 25 404 ____| Email: cholm@nbi.dk Web: www.nbi.dk/~cholm | |
This archive was generated by hypermail 2.1.5 : Fri Sep 26 2003 - 05:40:51 EDT