| Portal Home | Client Area | Announcements | Knowledgebase | Support Tickets | Downloads |
Announcements
You are here: Portal Home > Announcements > Mysql 5+ and updates - Cpanel/Plesk Full Managed Services
04/21/2008 00:00
Mysql 5+ and updates - Cpanel/Plesk Full Managed Services
We need our servers to be running MySQL V5 + instead of 4.1 for a few reasons. The main one is for added security in MySQL 5 but also for database speed improvements and stability. We have not had any problems with the current versions for reliability but the potential security issues are the biggest concerns at the moment.
Some issues may come into play. Some web scrips my need to be informed or configured for MySQL 5. Most scripts should work as the Cpanel updater will convert all databases to the new format. However, we are not responsible to configure your web scripts. Potential for corruption is possible, so all databases will be backed up prior to the upgrade. Now we need to do this ASAP so there is only a one to two hour window before this will commence. (Posted 9:15 am EST)
We are first running the standard Cpanel up dates, which are in progress. After this we will backup everything on each server including databases. Then update Apache for the new script loaders. Then MySQL will be upgraded. Apache updated again and then Cpanel update again to sink all changes.
This will take the better part of the day and there is also potential for downtime at the web server level meaning you will not see your sites at times during this day of Monday the 21st 2008. The servers themselves will not be down at all. The Apache web server needs to be shut down during the Cpanel and Apache updates plus MySQL needs to be shut down during the database conversion from 4.1 to 5.0.1+ (whatever the current version is).
If you get the chance, you should put your sites in maintenance mode but I can not give an actual window ETA as the timing may fluctuate as problems arise. Hopefully, everything will work perfect and go smooth as the last few major updates have.
Thank you for being with us and understanding how important it is to be and remain secure in the face of the on-slot of hacker attempts.
If your web script can not run with MySQL 5 then we will have to work something out later. Sorry for any inconvenience this may present. Don't forget we maintain a daily backup of all Cpanel web site accounts for seven days straight plus a monthly backup. This means that if your site does not like MySQL, then it is possible to move it to another MySQL 4+ server with no real issues. If we have to we will run a special non-public MySQL 4.1 only server (no other services running) just for web sites depending on out-of-date web scripts stuck on MySQL 4 but will be a last resort effort if can not update, configure for use another script that supports MySQL 5+. One more point to keep in mind is that MySQL 4 is at end of life support from the developers anyway. It is smart for that reason alone to move to MySQL 5.