MySQL 5 and Stored Procedures

[stehbens]

Hi All!
I've recently switched hosting providers here, and i've been quite impressed with the features offered to free accounts. Nice job guys. :biggthump

I've got a question regarding the MySQL version being used (4.xx). Is there any plans on upgrading to v5.xx any time soon? The reason I ask is v5 supports stored procedures and functions (as well as various performance improvements and bug fixes over v4).

I've been developing a new/content management system from scratch, and utilises quite a few stored procedures to do a lot of the complicated operations my DB needs to perform server side, to avoid large amounts of website to DB server data transfer.
If I can i'd like to avoid redeveloping these part of my site to execute the sql directly against the DB, but i'll change if I have no other option.

thanks for you help

 

[Dannz]

I agree that MySQL v5 would be great to have, though I understand there are some issues with upgrading - like might have to reload databases which are set up (??). Might it be an idea to have this on just one of the servers?

Also I'd really really like to have SSH or SSL access to MySQL so I can use a GUI such as Navicat. There shouldn't be any reason why this can't be done (security is good especially if access is limited to IP addresses), and it makes admin a lot easier.

 

[stehbens]

Ahh true, after a bit of research I believe there are some incompatibilities with some mysql4 and 5 features. Notably, some Join statements run faster on Mysql4, but others run better on 5. But my research was limited to what I could do today while bored at work, so I don't have a complete idea on what will definitely break. :happysad:
Although 1 thing is for sure, Stored procedures and functions are only supported in v5+, which is my problem at the moment. :eek4:
So i guess at this stage I need to look at not using these features, as the hosting provider I switched here from, although they had MySql 5, wouldn't give people the permissions to create (or execute) Stored Procs/Functions. Not even their website MySql management tool supported it.
But I wouls still like to know from the hosts if they have plans on upgrading soon. As if its in the next month or so, then I wont bother changing my DB access layer, anything outside of that though, means i'm going to have to change as I don't have that kinda time to spare. :dunno:

 

[Corey]

We have no immediate plans to change this as it hasn't really been requested. I've also read horror stories of people upgrading from 4 to 5. I can only imagine trying to do that on a server with 2,000+ accounts

-Corey