Re: [HPC-Admins] [CELS Sysadmins] [systems] userbase db
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 So the database has been moved and I've successfully tested the MCS accounts pages. The python scripts on the command-line are failing, however. I'm going to try to get them fixed asap, but for now the data is moved and live on userbase.mcs.anl.gov. I'm on MUD or Jabber if you have any questions. Ken Cory Lueninghoener wrote:
Sounds good to me. I'll plan to disable our accounts system at the same time, and then re-enable it when we get the all's-clear.
On 06/30/2009 04:56 PM, Kenneth Raffenetti wrote: Good question. I will take down the accounts pages at 9am and revoke write privs to the database. From there I will transfer the data, re-enable the web interface, and send out a mail saying to change your configs.
Am I missing anything?
Ken
Cory Lueninghoener wrote:
How should we time our change? Will there be a window where no databases work, or should I plan to make the update at 9:00 and be confident that nothing gets lost?
On 06/30/2009 04:27 PM, Kenneth Raffenetti wrote: Reminder: This move will be taking place tomorrow morning @ 9am. Hunter had a great suggestion that we add a CNAME of userbase.mcs.anl.gov to the coredb server. I have done this and would strongly encourage any configs to access the MCS userbase use this hostname, as it can easily move with the database in the future.
Remember, userbase.mcs.anl.gov as the db hostname, *not* coredb
Thanks, Ken
Kenneth Raffenetti wrote:
Hi all,
I've gotten a few responses on this and there doesn't seem to be any major issues. I'm going to schedule this cutover for Wednesday morning at 9am. As a reminder, the hostname will be changing from mysql/aha/yeah.mcs.anl.gov to coredb.mcs.anl.gov for the userbase database only.
I plan on leaving the current userbase available for a day to give people time to update any scripts, but I will drop it altogether on Thursday morning.
Please let me know if there are any showstoppers at this time.
Thanks, Ken
Kenneth Raffenetti wrote:
Hi all, We're going to be retiring aha.mcs.anl.gov soon, and in the process we'll be splitting it's mysql databases between a "core" and "development" server to better protect systems services from server crashes. What this means is that userbase will be moving to a different hostname when we make this change. Now is the time to starting thinking about all the places where you read from userbase and how you can change the configs to point to the new location (coredb.mcs.anl.gov). I would like to go ahead with this next week, if possible. If you have any issues, please let me know. Otherwise, I will send out an outage announcement on Monday. Ken
This is the CELS Sysadmins mailing list. It is sent to memebers of: [email protected], [email protected], [email protected], [email protected]. Do not subscribe directly to this list. Thanks.
This is the CELS Sysadmins mailing list. It is sent to memebers of: [email protected], [email protected], [email protected], [email protected]. Do not subscribe directly to this list. Thanks.
This is the CELS Sysadmins mailing list. It is sent to memebers of: [email protected], [email protected], [email protected], [email protected]. Do not subscribe directly to this list. Thanks. _______________________________________________ systems mailing list [email protected] https://lists.alcf.anl.gov/cgi-bin/mailman/listinfo/systems
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkpLdG8ACgkQvRJB9CBtvwid9gCgnzin2+CbxiscsQ6+tq1Kf8FG 24gAn3oLt9W9MJyp/GbI4a8OCIcwVQ6W =xT1G -----END PGP SIGNATURE----- _______________________________________________ This is the CELS Sysadmins mailing list. It is sent to memebers of: [email protected], [email protected], [email protected], [email protected]. Do not subscribe directly to this list. Thanks.
participants (1)
-
Kenneth Raffenetti