Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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
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!
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.
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.
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.
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.
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.
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.