Page 1 of 1

Asking For Confirmation before MySQL Upgrade

Posted: Sat Dec 17, 2005 5:49 pm
by 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

Posted: Mon Dec 19, 2005 1:02 pm
by scott
Yes, everything is built with both RHEL and CentOS support in mind. You can either run "yum update" or "yum update mysql"

Thanks Scott

Posted: Mon Dec 19, 2005 5:55 pm
by 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

Posted: Tue Dec 20, 2005 2:18 pm
by scott
Haha, no I just have gaim. http://gaim.sf.net

Posted: Thu Jan 05, 2006 12:25 am
by 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

Posted: Fri Jan 06, 2006 11:51 am
by 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.