Hi Koha team, Henri Damien just commited a few minuts ago a code that executes perfectly for him. But not for me. The reason : it's an imbricated SQL query. mySQL 4.0 don't handle imbricated SQL queries, where 4.1 does without problem. So the question is : do we want to define a minimum for running Koha ? (knowing that, for example, mandriva default mySQL is 4.0 If we use a too recent version of Koha, then it will be harder to install) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
It will be fine to have a default instalation, maybe MySQL 4.0 at least. The only distro that default installs something older is Debian, but can be easily upgraded. Till MySQL 4.1 becomes widely deployed we should keep with MySQL 4.0 Andres Paul POULAIN wrote:
Hi Koha team,
Henri Damien just commited a few minuts ago a code that executes perfectly for him. But not for me. The reason : it's an imbricated SQL query. mySQL 4.0 don't handle imbricated SQL queries, where 4.1 does without problem.
So the question is : do we want to define a minimum for running Koha ? (knowing that, for example, mandriva default mySQL is 4.0 If we use a too recent version of Koha, then it will be harder to install)
On Thu, May 26, 2005 at 05:00:11PM +0200, Paul POULAIN wrote:
So the question is : do we want to define a minimum for running Koha ? (knowing that, for example, mandriva default mySQL is 4.0 If we use a too recent version of Koha, then it will be harder to install) I think 4.0 is a minimum for sure. For example, 3.23 doesn't include query_cache so everything runs _very_ slowly. I've not tried out 4.1 but I'm not against it as a minimum. Since MySQL AB releases official RPMs for all version of MySQL, it's not too hard to install a newer version on RPM-based systems. Deb based systems have easy access to version 4.0.18 last time I checked, but no good way to get 4.1 -- but with 'alien' or some other method there might be an easy way to install 4.1.
My two cents, -- Joshua
Joshua Ferraro wrote:
On Thu, May 26, 2005 at 05:00:11PM +0200, Paul POULAIN wrote:
So the question is : do we want to define a minimum for running Koha ? (knowing that, for example, mandriva default mySQL is 4.0 If we use a too recent version of Koha, then it will be harder to install)
I think 4.0 is a minimum for sure. For example, 3.23 doesn't include query_cache so everything runs _very_ slowly. I've not tried out 4.1 but I'm not against it as a minimum. Since MySQL AB releases official RPMs for all version of MySQL, it's not too hard to install a newer version on RPM-based systems. Deb based systems have easy access to version 4.0.18 last time I checked, but no good way to get 4.1 -- but with 'alien' or some other method there might be an easy way to install 4.1.
My two cents,
FYI debian has 4.1 available in "testing". The default mysql-server currently is 4.0.24 for "testing" ("stable" is 3.23.49). http://packages.debian.org/testing/misc/mysql-server-4.1 gvb
On Thu, May 26, 2005 at 11:24:10AM -0400, Jerry Van Baren wrote:
FYI debian has 4.1 available in "testing". The default mysql-server currently is 4.0.24 for "testing" ("stable" is 3.23.49). Great! That means it's actually quite easy to get 4.1 installed on debian stable with a little apt-pinning.
-- Joshua
Joshua Ferraro a écrit :
I think 4.0 is a minimum for sure. For example, 3.23 doesn't include query_cache so everything runs _very_ slowly. I've not tried out 4.1 but I'm not against it as a minimum. Since MySQL AB releases official RPMs for all version of MySQL, it's not too hard to install a newer version on RPM-based systems. Not so easy : binary format of mysql databases differs from another version to another one. So, once you've installed a version X & have some DB, it's quite not so easy to update, because you have to dump everything, delete everything, install mysql X+1, and reload databases. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
I Think that you can have both instaled the OLD and the newer version. Can be tricky, but you will have less downtime and nearly seamless migration. Andres Paul POULAIN wrote:
Joshua Ferraro a écrit :
I think 4.0 is a minimum for sure. For example, 3.23 doesn't include query_cache so everything runs _very_ slowly. I've not tried out 4.1 but I'm not against it as a minimum. Since MySQL AB releases official RPMs for all version of MySQL, it's not too hard to install a newer version on RPM-based systems.
Not so easy : binary format of mysql databases differs from another version to another one. So, once you've installed a version X & have some DB, it's quite not so easy to update, because you have to dump everything, delete everything, install mysql X+1, and reload databases.
On Thu, May 26, 2005 at 05:32:59PM +0200, Paul POULAIN wrote:
Not so easy : binary format of mysql databases differs from another version to another one. So, once you've installed a version X & have some DB, it's quite not so easy to update, because you have to dump everything, delete everything, install mysql X+1, and reload databases. I think that only applies when going from a higher version to a lower version (I upgraded from 3.23 to 4.0 without using mysqldump). Here are the official upgrade guides (since we don't use InnoDB tables there is less of a problem): http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Note that it is probably a good idea to upgrade to 4.0 before upgrading to 4.1. Also, if you're going to attempt to upgrade, please make backups in case of an emergency and please try it on a test machine before a production machine ;-). I should include a section on how to upgrade to mysql 4.0/4.1 in my installation manuals -- I'll put that on my list. -- Joshua
participants (4)
-
Andrés Tarallo -
Jerry Van Baren -
Joshua Ferraro -
Paul POULAIN