[FQuest Notice] MYSQL06 Kernel update

[Terra]

When: 1/3/2004
Window: 2:00am - 5:00am EST
Duration: 2 - 10 minutes

MYSQL06 will be rebooted to bring forth a minor kernel tweak which will allow us to better monitor the server loading...

--
Terra
sysAdmin
FutureQuest

[Armand]

Warning: dense moment.

Umm how do we even tell what MySQL server we are on? Wasn't on the 'Server Info' in the CNC.. so was curious if there was an easy way to find out such that I missed.

[Arthur]

Hello Joe,

You could look up the IP address of mysql.yourdomain.com and then check which of our dedicated MySQL servers it points to. However, we have made a quick addition to the CNC and you'll now find the name under 'Server Info' :)

Arthur

[Armand]

Wow... very cool. Thanks. Just figured I might not be the only that wasn't sure what MySQL server they were on.

[Arthur]

MYSQL06 will be going down in a few minutes.

Arthur

[Arthur]

The reboot has been completed, the new kernel is in place and the server is back in full production.

Arthur

[phppete]

Arthur,

When you take a MySQL server offline do you do anything to prevent the chance of it going down as data is being entered? I am just wondered about the risks of corrupted tables if someone was inserting data at the very point MySQL goes offline, do you lock all tables first to prevent that?

Just curious.

Thanks

Pete

[Arthur]

MySQL will, when you gracefully shut it down (which was the case here), lock all tables, wait for all queries to finish and then flush all data to disk, thus ensuring no data is lost or corrupted. And after that, the server is rebooted.

Arthur

[phppete]

Thanks Arthur :)