LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 04-16-2007, 02:17 AM   #1
nesargha
Member
 
Registered: May 2006
Distribution: rhel 4, red hat 9, fedora core 2
Posts: 51

Rep: Reputation: 15
Question how to upgrade php and mysql on live server


hi guys,

We have red hat 9.0 linux, with php 4.2.2 and MySQL - 3.23.54, this machine also runs sendmail, squid (internet). The php and mysql was installed from the red hat 9.0 CD (rpm).

1. we want to upgrade php and mysql for some of our programming needs.

2. since its a live server what are the things we have to look into ( impact on other programs).

3. we know upgrading the distro is good and solve our problems but our priority is to upgrade the s/w not distro.

right now we have taken the backup of the of mysql database and the list of programs that use php and mysql.
my
rpm -qa | grep php
php-4.2.2-17
php-manual-4.2.2-17
php-snmp-4.2.2-17
php-devel-4.2.2-17
php-ldap-4.2.2-17
php-mysql-4.2.2-17
php-pgsql-4.2.2-17
php-imap-4.2.2-17
php-odbc-4.2.2-17
rpm -qa | grep mysql
mysql-server-3.23.54a-11
php-mysql-4.2.2-17
mysql-3.23.54a-11
If any of you guys have gone through the same process please let us know how we can solve this problem.

thanks in advance.
 
Old 04-16-2007, 03:39 AM   #2
thekillerbean
Member
 
Registered: Jan 2002
Distribution: Ubuntu 12.04.2 (Precise)
Posts: 89

Rep: Reputation: 16
FWIW, I have upgraded MySQL on a live server without any impact whatsoever - well, not a single user reported any issues either on the day or within 2 weeks of the upgrade. Cannot say the same for PHP as I did not upgrade that one!

MySQL was upgraded from 3.23 to 5.1!

Cheers,
tkb.
 
Old 04-16-2007, 07:45 AM   #3
reddazz
Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 73
Moved: This thread is more suitable in Linux Server and has been moved accordingly to help your thread/question get the exposure it deserves.
 
Old 04-16-2007, 09:38 AM   #4
Jzarecta
Member
 
Registered: Dec 2005
Location: Villahermosa, Bucharest, Birminham, Brooklyn, Beverly
Distribution: Mandriva
Posts: 118

Rep: Reputation: 15
Oops sorry, is too early in the morning here. Anyway I think that the best way to upgrade a service might be with a second box (mirroring). This way you will just switch the routing tables to the different IP. The other way is just to upgrade and apply the upgrade by doing a service restart. This will create a very tiny downtime but is not like you would need to reboot the whole system.

New fancy ways is to have a virtual PC this virtual PC will act as a mirror and you can just use sockets to re route the service. This however might need more technical experience on using internal sockets since you are no longer in a network but in a internal socket/service connection matrix.

Last edited by Jzarecta; 04-16-2007 at 10:02 AM.
 
Old 04-16-2007, 09:44 AM   #5
nesargha
Member
 
Registered: May 2006
Distribution: rhel 4, red hat 9, fedora core 2
Posts: 51

Original Poster
Rep: Reputation: 15
hi guys,

I hope this moving helps me

Last edited by nesargha; 04-16-2007 at 10:43 AM.
 
Old 04-16-2007, 11:26 AM   #6
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Most MySQL RPM's will shutdown MySQL and restart after the install or upgrade. In best practice, you may want to shut these down yourself and make sure you have a full backup or mysqldump of the databases and tables.

For PHP, in most cases, you can install while Apache is running, but it's best practice to schedule a downtime, install and make sure you meet all dependencies for both or all upgrades as PHP install would require an Apache restart for the new modules to get picked up.

In your case, you're running an older version of Redhat, it might be safe to build a new server with upgrades and transfer the databases and data over, as meeting all required dependencies can and will be a lot of work unless you rebuild your own RPM's for your platform as Redhat 9 itself is old and you may want to do more than a PHP and MySQL update.
 
Old 04-17-2007, 01:11 AM   #7
Jzarecta
Member
 
Registered: Dec 2005
Location: Villahermosa, Bucharest, Birminham, Brooklyn, Beverly
Distribution: Mandriva
Posts: 118

Rep: Reputation: 15
Quote:
Originally Posted by trickykid
Most MySQL RPM's will shutdown MySQL and restart after the install or upgrade. In best practice, you may want to shut these down yourself and make sure you have a full backup or mysqldump of the databases and tables.
Actually I will recomend to double backup not jut the mysqldump but also the binaries that are usually stored on /var/lib/mysql/

Also when you do a mysqldump make sure to use the --create-options this will includes the database creation and not just the table dump.

More info at man mysqldump
 
Old 04-17-2007, 01:38 AM   #8
nesargha
Member
 
Registered: May 2006
Distribution: rhel 4, red hat 9, fedora core 2
Posts: 51

Original Poster
Rep: Reputation: 15
Hi Guys,

Thanks for the reply, Yes i know red hat 9 is older ver, but right now our priority is to upgrade php & mysql, I will surely look into that aspect also.

If you people have any other advice please let me know, I am planning to do this weekend so by that time i want to gather more info and plan myself before starting to do the task.

Last edited by nesargha; 04-17-2007 at 01:40 AM.
 
Old 04-18-2007, 03:12 AM   #9
nesargha
Member
 
Registered: May 2006
Distribution: rhel 4, red hat 9, fedora core 2
Posts: 51

Original Poster
Rep: Reputation: 15
hey guys,

i think MYSQL will go smoothly, what about PHP have any one upgraded php, if so please share your experience with me.

Thanks
 
Old 04-19-2007, 02:06 AM   #10
Jzarecta
Member
 
Registered: Dec 2005
Location: Villahermosa, Bucharest, Birminham, Brooklyn, Beverly
Distribution: Mandriva
Posts: 118

Rep: Reputation: 15
Quote:
Originally Posted by nesargha
hey guys,

i think MYSQL will go smoothly, what about PHP have any one upgraded php, if so please share your experience with me.

Thanks
PHP needs to be defined on the httpd.conf since you have to define the php4 and regular php. PHP 'reload' when the apache server reload.
 
Old 01-20-2009, 05:28 AM   #11
patil
LQ Newbie
 
Registered: Jan 2009
Posts: 3

Rep: Reputation: 0
My SQL problem

hi guys,

We have red hat linux, with php 4.0 and MySQL - 4.0.18-32.23, this machine also runs postfix, squid (internet). The php and mysql was installed from the red hat 9.0 CD (rpm).

1. we want to upgrade php and mysql for some of our programming needs.

2. since its a live server what are the things we have to look into ( impact on other programs).

3. we know upgrading the distro is good and solve our problems but our priority is to upgrade the s/w not distro.

right now we have taken the backup of the of mysql database and the list of programs that use php and mysql.

rpm -qa | grep mysql
mysql-4.0.18-32.23
mysql-client-4.0.18-32.1
apache2-mod_auth_mysql-20030510-208.1
mysql-shared-4.0.18-32.1
qt3-mysql-3.3.1-35.11
perl-DBD-mysql-2.9003-22.1
python-mysql-0.9.3b2-90.1
php4-mysql-4.3.4-43.61

Please help me how to upgrade mysql to 5.x

Regards,
Patil
 
Old 01-20-2009, 06:58 AM   #12
patil
LQ Newbie
 
Registered: Jan 2009
Posts: 3

Rep: Reputation: 0
Question Mysql upgradation

Please check the below lines

rpm -qa | grep mysql
mysql-4.0.18-32.23
mysql-client-4.0.18-32.1
apache2-mod_auth_mysql-20030510-208.1
mysql-shared-4.0.18-32.1
qt3-mysql-3.3.1-35.11
perl-DBD-mysql-2.9003-22.1
python-mysql-0.9.3b2-90.1
php4-mysql-4.3.4-43.61

Please suggest me how to upgrade to 4.1.x and live mailserver is running without distrubing.

Wating for reply

Regards,
Patil
 
Old 01-21-2009, 12:32 AM   #13
nesargha
Member
 
Registered: May 2006
Distribution: rhel 4, red hat 9, fedora core 2
Posts: 51

Original Poster
Rep: Reputation: 15
Hi Patil,

Upgrade ur redhat 9.0, even we tried to upgrade the only the s/w keeping the distro, but later we found that security wise and by all other means its good to upgrade the distro, as red hat 9.0 is very old version and it lacks some of the security updates which the newer version has.

Since your ar also having email server running on it i advice you to update it as there are changes of hackers hacking into ur redhat 9.0 and using it send spam mails (if this happen ur ip would be blocked and blacklisted in email blacklisted db and you will not able to send or receive mails from ur server). Ours red 9.0 was hacked even though we had closed all the ports and had a good linux admin looking after it.

you can do the upgrading work on sat/sunday when no one will be accessing their mails.

and its on no use just updating the s/w when ur whole distro is outdated, how long will you do this.

If your in or around blore (within karnataka) and need any help then i can get u professional help, who will take care of whole upgrade without any single issue.

-
nes

Last edited by nesargha; 01-21-2009 at 12:35 AM.
 
Old 01-21-2009, 01:03 AM   #14
patil
LQ Newbie
 
Registered: Jan 2009
Posts: 3

Rep: Reputation: 0
nesargha,

Thanks for your help, I am living in bangalore itself, so please contact on you can give your mail ID I will reply for it, even I need your help to upgrade mysql.

Regards,
patil

Last edited by patil; 01-26-2009 at 06:05 AM.
 
  


Reply

Tags
live, mysql, php, server, upgrade


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a client install for MySql so PHP can connect to MySQL Server? alar Linux - Software 8 07-03-2007 08:42 PM
PHP+MySQL application on a live CD cppansi Programming 1 05-16-2006 05:13 AM
Upgrade to MySQL-5.0.18 breaks PHP mysql functions MarkVickers Slackware 5 05-03-2006 01:10 AM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 05:16 PM
Upgrade mysql and php acrors Red Hat 1 08-31-2004 11:30 AM


All times are GMT -5. The time now is 12:45 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration