LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   Update the kernel will Mysql Still work? (http://www.linuxquestions.org/questions/linux-server-73/update-the-kernel-will-mysql-still-work-695421/)

Joyce1981 01-06-2009 04:29 PM

Update the kernel will Mysql Still work?
 
If anybody knows if update the kernel to the latest one, will mysql database (version 4.1.20) work with the newest kernel or do I need to upgrade the mysql database software as well?

The latest stable version of linux kernel is 2.6.28.
The current kennel version of my linux server is 2.6.9-34.ELsmp


MySql database information are as follow:

# mysql -V

mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3



Thank you for your help in advance!

Best regards,
Joyce

FragInHell 01-06-2009 05:51 PM

The kernel update shouldn't affect it. But ensure you have a good backup of your Databases. You can always boot back to the old kernel if you really find a problem.

Joyce1981 01-07-2009 09:08 AM

Thank you for the information.I will update kernel on a test box.

Joyce

FragInHell 01-08-2009 04:47 AM

You should have no problems, I have done this on production servers many times, although caution is always advisable. As soon as you get complacent about these things thats when It hits you. Your more likely to have problem with HBA drivers / Multi-pathing or Vendor hardware drivers.

Hope all goes ok.

Joyce1981 01-08-2009 10:15 AM

Thank you for sharing your experience.

May I please ask you have done update the kernel through REDHAT Network or download the patch from Kernel.org?Which way has lower Risk?

Best regards,
Joyce

FragInHell 01-08-2009 05:27 PM

All our Server are Redhat, so we get them from Redhat, there are also several advantages to doing this.
1 - If it goes wrong you should have support
2 - They have probably already tested the new kernel and packaged it correctly.
3 - Its easier and less time consuming, if you have lots of machines to do.

harry edwards 01-08-2009 05:36 PM

One minor point is that a kernel update will not be active until a reboot; thus, your MySQL database will require some downtime. If you are not running a mission critical 24/7 system this will not matter: just thought I'd mention it.

Joyce1981 01-08-2009 05:55 PM

Thank you :)


All times are GMT -5. The time now is 08:58 PM.