MySQL compatibility (5.1 vs 5.5)

[terraGirl]

Hi Zen Team,

Can you advise which Zen Cart versions officially support MySQL 5.5?

In the tutorial section, I found notes relating to MySQL 5 or higher, but nothing specific as to MySQL 5.1 vs 5.5. Forum posts seem to indicate some issues with modules, but not core?

Any advice / experiences you have on this?

Many thanks, Edith

[wilt]

Hi Edith

I currently have MySQL 5.5.24 installed and haven't seen any problems with core code. Although I can't speak for contributions.

However, our official test server (where we run all our unit/selenium web tests)
is still on 5.1, so we haven't yet officially endorsed anything above 5.1

[RodG]

Hi Edith,

I'd just like to backup Wilts comments. I'm also running MySQL 5.5.24 and haven't seen any problems with core code (or any modules I've tried).

Having said that, please be aware that most (if not all) MySQL upgrades have been backwards compatible. This is not true of PHP, which is also in version 5.x. (and I'm sure many people get these confused). You'll find that most people suffering compatibility issues are a result of the PHP updates rather than the MySQL upgrades.

Having said that, why are you asking? Are you planning an upgrade or a new installation? Perhaps if you could tell us about your current setup we will be in a better position to offer more definitive advice.
If you are planning a new install then needless to say, you should start out with the latest codebase available, keeping in mind that *you* have no control over which versions of MySQL or PHP is installed on any given server.

Cheers
Rod.

[DrByte]

Hi Edith

I currently have MySQL 5.5.24 installed and haven't seen any problems with core code. Although I can't speak for contributions.

I echo wilt's comments.
I too normally use MySQL 5.5 in all my development and production work. Haven't run into any problems related to using MySQL 5.5.x as far as Zen Cart v1.5.x core code goes.


Rod, terraGirl *is* a hosting company, so she's one of the rare few who actually do have total control over what version of MySQL she runs on her server

[terraGirl]

Many thanks for your input!

Yes, the query is related to one of our Shared servers, so I have no control over what software is installed and also not the full details of what weird and wonderful modifications are running.

The server is live (with live client sites), hence why I'm treading very carefully here. First step is assessing the most common software types (Zen Cart, Magento, WordPress, Joomla, OpenCart etc) for 5.5. compatibility which appears to be all good.

We probably will hold off with MySQL 5.5 for a bit longer (until after Xmas) and also run more tests on a non-client server first to assess.

Many thanks for your advice, that's been very helpful!