Forums / Install & configuration / MySQL vs MySQLi (improved)
Piotrek Karaś
Monday 03 December 2007 10:30:32 pm
Hello there,
Can anyone comment on the differences between mysql and mysql improved library for mysql in the context of eZ Publish? Especially:
1) What would be the strengths of one over other for eZ in particular?
2) Is there ANY greater risk of coming across a bug (simply because mysqli hadn't been introduced until recently)? Or is it totally transparent, or some kind of abstraction layer takes care of differences?
3) If my hosting environment provides both for PHP5, would it be for any reason not recommended to switch between both options later on, having some content in?
Thanks for any suggestions,Piotrek
-- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
Jonny Bergkvist
Wednesday 30 January 2008 6:10:28 am
Hello,
The documentation page:http://ez.no/doc/ez_publish/technical_manual/4_0/installation/the_setup_wizard
Says the following: " Note that if the MySQLi extension is enabled in PHP, the "MySQL Improved" option will be available on the list. If you are going to use a MySQL database, it is recommended to select "MySQL Improved" instead of "MySQL"."
As Piotrek asks for, it would be great with some details of the difference between using mysql vs. mysqli in the context of eZp 4.
If you know, please share your information here :-)
Thanks, Jonny
Björn Dieding@xrow.de
Wednesday 30 January 2008 4:30:27 pm
http://www.php.net/mysqli
I can just point you to this url... As you can see it is kind of a software/driver upgrade with new functionality.
Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
Wednesday 30 January 2008 5:13:29 pm
Yup, I had already dealt with it before I first touched eZ Publish. Just thought there could be some eZ related issues.
How would you see lack of persistent connections for an eZ site with high traffic? Did actually eZ Publish make use of those at all?
Thanks
Martin Burger
Sunday 09 August 2009 1:48:50 am
Especially this page provides further information: http://www.php.net/manual/en/mysqli.overview.php
They advise to use MySQLi: "Note: If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use this extension. "
http://www.netbeyond.de/
Gaetano Giunta
Monday 10 August 2009 1:02:58 am
As for eZP-specifics, some corner cases are: - cluster-mode support still lacking- script to convert db from mysqli to oracle still lacking
Principal Consultant International Business Member of the Community Project Board
Monday 10 August 2009 1:15:13 am
Now, that's piece of concrete and practical info, Gaetano. Thanks!I think this could be mentioned somewhere, for example in the installation wizard.
Cheers,Piotrek