Asking For Confirmation before MySQL Upgrade

[cjharman]

Hello!

Scott! I must first say that your site is awesome, and what you are doing is great! I've learned alot today reading through your site. Also, all the users here have posted some helpful information!

I am PHp programmer... and feel pretty comfortable using Putty, but i've never had to upgrade software on a server. The main reason I am upgrading MySQL is for the query cache abilities... so while I think i know what i am doing (lol.. yeah right) I just wanted to bounce some stuff off of the PROs here.

I am upgrading MySQL from 3.23.58-15.RHEL3.1 to the latest version here at ART. My Server is running the following:

OS CentOS 3.3
PSA 7.5.4-centos3.3.build75050824.12
PHP 4.3.2
MySQL 3.23.58-15.RHEL3.1

I have already input the line old_passwords=1 in my.cnf file

I have configured YUM to use the following

Code: Select all

[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/3ES/
exclude=spamassassin

[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/3ES/
exclude=spamassassin

1. The first thing I need to confirm is that I am getting these rpms from 3ES, this will cover CentOS 3.3?

2. Second... I just issue the command 'yum update mysql' ?

3. Third... restart the server then every thing should be fine and dandy?

Thanks for your help!
Joe

[scott]

Yes, everything is built with both RHEL and CentOS support in mind. You can either run "yum update" or "yum update mysql"

[cjharman]

Alrighty... i am going to give it a go tonight... hey... on a side note.. i see that you almost have every IM client known to man... LOL

Cheers! I will post and let everyone know how it went!
Joe

[scott]

Haha, no I just have gaim. http://gaim.sf.net

[cjharman]

K.. everything seem to go pretty good... only one small glitch...

when i restart mysql, it doesn't seem to start... it takes 2 attempts to get mysql to operate... any ideas?

Thanks
Joe

[scott]

I put together a new mysql package in the [atomic-testing] channel, which is sourced from the FC4 design. I havent seen the slow start/stop issues with that version.