CODEWITHSUNDEEP
phpmysql
motioz
motioz

Reputation: 662

Is it safe to Upgrade mysql 5.1 to 5.5 on my vps?

I have a virtual server with CPANEL-whm and I see a possibility to Upgrade the mysql to 5.5, Is it safe ?

Upvotes: 0

Views: 2464

Answers (4)

Jerry Saravia
Jerry Saravia

Reputation: 3837

Test it. Install mysql 5.1 on your own machine or some machine that isn't critical then upgrade to mysql 5.5. Then run any tests that you might have. On VPS you usually have free reign about what's installed and what isn't so you should be able to install anything you catch in your testing.

If you don't have any tests, familiarize yourself with the changes made in the upgrade and determine if there will be any immediate impact from the changes.

Never just upgrade because.

Upvotes: 0

Petah
Petah

Reputation: 46040

Check out the migration guide:

http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

There is not many huge differences, mostly just how the InnoDB plugin works internally, and some encoding stuff.

Upvotes: 0

adrien
adrien

Reputation: 4439

It depends : do you use some functionnalities that are not available and/or were updated between the two versions? etc.

Best way to know : try on another server, test the application, if everything works then do it on your live production server.

Upvotes: 0

zerkms
zerkms

Reputation: 254944

No one could guarantee you that.

And if someone says it is safe - don't trust them

PS: the rule of thumb: it works - don't touch it

Upgrades without some particular reason (ie some bug your software affected by was fixed) never lead to something good

Upvotes: 2

Related Questions