|
WHSP-Mark M
|
 |
« on: March 12, 2007, 09:55:38 AM » |
|
Hello All, We will proceeding with a planned upgrade of MySQL and PHP on our system. Due to the amount of servers that will need to be upgraded we will be doing our conversions 6 servers a week starting WEDNESDAY, MARCH 14TH. The first servers to be upgraded are listed below:
battlezone.vosn.net
centipede.vosn.net
contra.vosn.net
csx001.whspn.net
csx002.whspn.net
digdug.vosn.net
The PHP upgrade is to 4.4.5 which is a small security upgrade and should not cause any problems. The MySQL upgrade will see the installation of version to 4.1.21. This upgrade is necessary to stay current with the various bug fixes & security updates but also brings along some new features that some are sure to like. All of these upgrades are all part of the process to bring PHP5 support to our clients at a later time. With this upgrade, the default charset is altered on each database to use 'latin1' which may cause some websites using other defined charset's to display it's content incorrectly. Please open a support ticket with our staff if this is the case. Below is a list of some new features in this version of MySQL: - MySQL 4.1 supports subqueries. Many queries can be more efficiently written without using a subquery, but there are the exceptions, and subqueries are a standard ANSI SQL feature, so it's about time MySQL supported this.
- Supports Unicode (UTF-8), allowing for much more extensive internationalization. Different character sets can also be set per column, table or database, which could be necessary if the data stored is from many languages.
- Support for geographical data (OpenGIS)
- As if one wasn't enough, MySQL 4.1 can now send multiple warnings to the client (useful for bulk data processing).
- More minor speed improvements (probably counteracted by all the extra bulk MySQL 4.1 now carries - it's a bit early to tell whether these will be noticeable).
- Although the MySQL manual is one of the best manuals out there, MySQL 4.1 comes with a HELP command, applicable only to that version.
- Support for derived tables, for example:
SELECT table1.field1 FROM table, (SELECT * FROM table2) table3 WHERE table1.field1=table3.field1
- Support for multi-line queries, which allows you to run several queries, and then read the results afterwards.
- Various maintenance statements will be stored in the binary log, meaning you may be able to simplify your maintenance tasks when replicating.
- CREATE... LIKE allows you to easily create a new table with the exact structure of an existing table.
Once the above servers have been completed we will announce the next batch. We very well may take on more then 6 servers a week depending on support requests stemming from the upgrades. As always if there are any questions or concerns, please do let us know. Thanks! WebHSP Support Team. Note: This is for our shared servers only, VPS clients will not be affected. |
|
|
|
« Last Edit: March 12, 2007, 11:32:33 AM by WHSP-Mark M »
|
Logged
|
|
|
|
htperkins
Newbie
 Offline
Posts: 1
|
 |
« Reply #1 on: March 12, 2007, 01:02:52 PM » |
|
Very good news, and hopefully the beginning to a slew of much needed upgrades!  Hopefully other web hosting services follow suite, as Web HSP is very respected among the shared hosting community. |
|
|
|
|
Logged
|
|
|
|
scanreg
Newbie
Offline
Posts: 1
|
|
« Reply #2 on: March 13, 2007, 05:23:34 AM » |
|
If possible, please do a full data backup as close to the upgrades as possible so that there would be the least loss (fingers crossed) Put your helmets on, and good luck  |
|
|
|
|
Logged
|
|
|
|
|
WHSP-Mark M
|
|
« Reply #3 on: March 13, 2007, 05:36:52 AM » |
|
htperkins - Thank you for your kind comments, they are always appreciated. scanreg - All of our nightly backups on our shared servers are full backups, so in the event that disaster strikes, we are ready  . There should be little need for the backups however as we have completed these upgrades on a few of our quieter servers and everything went off without a hitch. Fingers certainly crossed all the same. Regards, Mark |
|
|
|
|
Logged
|
|
|
|
BassX
Newbie
Offline
Posts: 9
|
|
« Reply #4 on: March 13, 2007, 03:22:56 PM » |
|
It looks like the server I'm on (not listed above) was previously upgraded to MySQL 4.1.21 but its PHP version is still 4.4.3.
Are we going to get the PHP upgrade in the future?
|
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #5 on: March 14, 2007, 02:18:09 PM » |
|
BassX, All of the servers will be upgraded. The servers mentioned above are only the first batch. Once they have been upgraded successfully and all issues (if any) that arise as a result have been dealt with, we will move on the the next batch. Breaking them down in this way will help to keep the process organized and on schedule. You will be notified by email prior to the upgrades. Please let us know if you have any further questions or concerns. Thanks. --Kevin |
|
|
|
|
Logged
|
|
|
|
|
makulit
|
|
« Reply #6 on: March 14, 2007, 05:02:57 PM » |
|
Hello. How long is the ugrade gonna be for? How long is my website gonna be down for?
|
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #7 on: March 14, 2007, 07:02:10 PM » |
|
makulit, Downtime during the upgrade has been minimal. 1-10min roughly. The scheduled upgrades for the following servers have been completed. battlezone.vosn.net centipede.vosn.net contra.vosn.net csx001.whspn.net csx002.whspn.net digdug.vosn.net Thanks. |
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #8 on: March 15, 2007, 01:57:34 PM » |
|
Hello, On MONDAY, MARCH 19th, we will proceeding with a planned upgrade of MySQL and PHP on the following servers: - eclipse.vosn.net
- frogger.vosn.net
- gamble.vosn.net
- joust.vosn.net
- liberty.vosn.net
- megaman.vosn.net
Please let us know if you have any questions or concerns regarding the upgrades. Thanks. WebHSP Support Team. |
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #9 on: March 19, 2007, 05:18:14 PM » |
|
Hello All, The server upgrades on the following servers have been completed successfully: - eclipse.vosn.net
- frogger.vosn.net
- gamble.vosn.net
- joust.vosn.net
- liberty.vosn.net
- megaman.vosn.net
Please let us know if you have any questions, concerns or run into any issues. Thank you, WebHSP Support Team. |
|
|
|
« Last Edit: March 20, 2007, 06:48:29 AM by WHSP-Mark M »
|
Logged
|
|
|
|
|
WHSP-Mark M
|
|
« Reply #10 on: March 20, 2007, 06:56:06 AM » |
|
Hello, On THURSDAY, MARCH 22nd, we will proceeding with a planned upgrade of MySQL and PHP on the following servers: - moria.vosn.net
- mrdo.vosn.net
- pacman.vosn.net
- paperboy.vosn.net
- qbert.vosn.net
Please let us know if you have any questions or concerns regarding the upgrades. Thanks. WebHSP Support Team. |
|
|
|
« Last Edit: March 20, 2007, 07:06:48 AM by WHSP-Mark M »
|
Logged
|
|
|
|
Aravis
Newbie
Offline
Posts: 2
|
|
« Reply #11 on: March 21, 2007, 03:26:44 PM » |
|
Hello,
I'm on the csx001.whspn.net server and while I see that my PHP has been upgraded to 4.4.6, my MySQL is still 4.0.27-standard.
Also, since the upgrade I'm getting 403 and 404 error messages when I try to rebuild my index.html on my blog, informing me that I don't have permission to access its cgi. When I go into my cpanel file manager and edit my index.html there, the change appears on my blog at first, but then disappears and reverts to the index prior to my changes. I haven't altered permissions or anything either on my blog or in my cpanel and am able to use my blog otherwise. Since this has only just begun to happen, I'm led to believe it's related to the upgrade. Any assistance you could provide would be helpful.
Thanks!
|
|
|
|
« Last Edit: March 21, 2007, 03:30:52 PM by Aravis »
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #12 on: March 21, 2007, 04:52:15 PM » |
|
Aravis,
Thank you for bringing this to our attention. You are correct. The timing of the issue would definitely lead one to believe that the problem is related to the recent upgrade. I have not yet determined that to be the case, however, I'm investigating the problem now.
I will submit a trouble ticket on your behalf. You can expect to here back from me shortly regarding the matter.
Thank you for your patience,
WebHSP Support Team.
|
|
|
|
|
Logged
|
|
|
|
Aravis
Newbie
Offline
Posts: 2
|
|
« Reply #13 on: March 22, 2007, 10:08:38 AM » |
|
Thanks! They were able to resolve the issue. I have to say I love this company. It's rare that I have a problem and when I do, the response is always swift, courteous and attentive.
Thanks again!
|
|
|
|
|
Logged
|
|
|
|
|
WHSP-Mark M
|
|
« Reply #14 on: March 22, 2007, 10:15:34 AM » |
|
Hi Connie,
We are always happy to hear that, and if you should need anything else, you know where to find us.
All the best.
Regards,
Mark,
|
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #15 on: March 22, 2007, 07:22:47 PM » |
|
Hello All, The server upgrades on the following servers have been completed successfully: - moria.vosn.net
- mrdo.vosn.net
- pacman.vosn.net
- paperboy.vosn.net
- qbert.vosn.net
Please let us know if you have any questions, concerns or run into any issues. Thank you, WebHSP Support Team. |
|
|
|
|
Logged
|
|
|
|
|
WHSP-Mark M
|
|
« Reply #16 on: March 26, 2007, 08:05:09 AM » |
|
Hello, On WEDNESDAY, MARCH 28th, we will proceeding with a planned upgrade of MySQL and PHP on the following servers: - silver.vosn.net
- tempest.vosn.net
- varsity.vosn.net
- venture.vosn.net
- zelda.vosn.net
Please let us know if you have any questions or concerns regarding the upgrades. Thanks. WebHSP Support Team. |
|
|
|
|
Logged
|
|
|
|
|
WHSP-Kevin
|
|
« Reply #17 on: March 28, 2007, 08:16:11 PM » |
|
Hello All, The server upgrades on the following servers have been completed successfully: - silver.vosn.net
- tempest.vosn.net
- varsity.vosn.net
- venture.vosn.net
- zelda.vosn.net
Please let us know if you have any questions, concerns or run into any issues. Thank you, WebHSP Support Team. |
|
|
|
|
Logged
|
|
|
|
|
