[Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

[Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Marc Laporte-3
Hi!

MariaDB 10.2 and MySQL 5.5 now have InnoDB as the default.

https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/
https://dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html
https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html


I propose to also do this for Tiki 18. MyISAM support would remain as an option.

The benefits outweigh the risks.:
https://stackoverflow.com/questions/20148/myisam-versus-innodb
https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb


A big benefit I see, is safety against data inconsistency without
locking all the table, as explained by Ricardo: "If you are only
running innodb tables, then you can do that with the table in
read/write: mysqldump –single-transaction


If there are concerns or if we run out of time, we can also do it
after Tiki 18LTS

Best regards,

--
Marc Laporte

http://WikiSuite.org
http://PluginProblems.com
http://Avan.Tech

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Jonny Bradley-4
Thanks Marc

+1 for 18.x certainly, maybe 17.1 too (or is that too weird, a bit late for that sort of change for 17.0 now I think, although I'm fairly sure it would be safe)

jonny


> On 27 Jun 2017, at 21:28, Marc Laporte <[hidden email]> wrote:
>
> Hi!
>
> MariaDB 10.2 and MySQL 5.5 now have InnoDB as the default.
>
> https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/
> https://dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html
> https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html
>
>
> I propose to also do this for Tiki 18. MyISAM support would remain as an option.
>
> The benefits outweigh the risks.:
> https://stackoverflow.com/questions/20148/myisam-versus-innodb
> https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb
>
>
> A big benefit I see, is safety against data inconsistency without
> locking all the table, as explained by Ricardo: "If you are only
> running innodb tables, then you can do that with the table in
> read/write: mysqldump –single-transaction
>
>
> If there are concerns or if we run out of time, we can also do it
> after Tiki 18LTS
>
> Best regards,
>
> --
> Marc Laporte
>
> http://WikiSuite.org
> http://PluginProblems.com
> http://Avan.Tech
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Dr. Sassafras
There isn't as much testing behind it as MyISAM. There are subtle differences in the way they work. I wouldn't want to introduce a change in behaviour mid tiki 17.

MyISAM isn't being developed further, all efforts are going into InnoDB, so it looks like it's being phased out slowly.

I'm not sure if we use it, but it appears as though fulltext indexes in InnoDB were introduced in MySQL 5.6, so that may be a consideration.

Brendan

> On Jun 27, 2017, at 4:32 PM, Jonny Bradley <[hidden email]> wrote:
>
> Thanks Marc
>
> +1 for 18.x certainly, maybe 17.1 too (or is that too weird, a bit late for that sort of change for 17.0 now I think, although I'm fairly sure it would be safe)
>
> jonny
>
>
>> On 27 Jun 2017, at 21:28, Marc Laporte <[hidden email]> wrote:
>>
>> Hi!
>>
>> MariaDB 10.2 and MySQL 5.5 now have InnoDB as the default.
>>
>> https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/
>> https://dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html
>> https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html
>>
>>
>> I propose to also do this for Tiki 18. MyISAM support would remain as an option.
>>
>> The benefits outweigh the risks.:
>> https://stackoverflow.com/questions/20148/myisam-versus-innodb
>> https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb
>>
>>
>> A big benefit I see, is safety against data inconsistency without
>> locking all the table, as explained by Ricardo: "If you are only
>> running innodb tables, then you can do that with the table in
>> read/write: mysqldump –single-transaction
>>
>>
>> If there are concerns or if we run out of time, we can also do it
>> after Tiki 18LTS
>>
>> Best regards,
>>
>> --
>> Marc Laporte
>>
>> http://WikiSuite.org
>> http://PluginProblems.com
>> http://Avan.Tech
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Torsten Fabricius-5
In reply to this post by Marc Laporte-3
Re: Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Author: Bernard Sfez / Tiki Specialist

I see both tracks (17.1 or 18.0) and I have some fears about this straight with 18.
I believe it’s gonna be cool if you start a Tiki from scratch, but what about upgrading or switching branch.

I would have like test compatibility as well as tools for a smooth switch.
We don’t want to be afraid of people doing changes (improvement) that make Tiki better we want to promote them and help transitions. :)

Couldn't we start testing (even in an experimental branch) in 17.1 ?

--
Reply Link: <https://tiki.org//tiki-view_forum_thread.php?forumId=26&comments_reply_threadId=65739&comments_parentId=65739&post_reply=1#form>



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Cloutier, Philippe (DGARI-Consultant)
Wooo, I must not have seen forum integration working that way in a long time!

Bernard, what testing are you proposing?


> -----Message d'origine-----
> De : Bernard Sfez / Tiki Specialist [mailto:[hidden email]]
> Envoyé : 3 juillet 2017 04:55
> À : [hidden email]
> Objet : Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal
> to approve
>
> Re: Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve
>
> Author: Bernard Sfez / Tiki Specialist
>
> I see both tracks (17.1 or 18.0) and I have some fears about this straight with 18.
> I believe it’s gonna be cool if you start a Tiki from scratch, but what about upgrading or switching
> branch.
>
> I would have like test compatibility as well as tools for a smooth switch.
> We don’t want to be afraid of people doing changes (improvement) that make Tiki better we want to
> promote them and help transitions. :)
>
> Couldn't we start testing (even in an experimental branch) in 17.1 ?
>
> --
> Reply Link: <https://tiki.org//tiki-
> view_forum_thread.php?forumId=26&comments_reply_threadId=65739&comments_parentId=6573
> 9&post_reply=1#form>
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Bernard Sfez-3
Wooo, I must not have seen forum integration working that way in a long time!

Same :)

Well I’d like to see that simple as possible for the end user.
An option in the installer sound to me like the right option.

Have a Tiki17 (using MyISAM) having a Tiki17.1 with an option in the installer to convert to InnoDB and upgrade (backup should be done message) the database.

Test = conversion + upgrade database + tada (it work fine). ;)


Bernard

On 3 Jul 2017, at 16:43 , Cloutier, Philippe (DGARI-Consultant) <[hidden email]> wrote:

Wooo, I must not have seen forum integration working that way in a long time!

Bernard, what testing are you proposing?


-----Message d'origine-----
De : Bernard Sfez / Tiki Specialist [[hidden email]]
Envoyé : 3 juillet 2017 04:55
À : [hidden email]
Objet : Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal
to approve

Re: Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Author: Bernard Sfez / Tiki Specialist

I see both tracks (17.1 or 18.0) and I have some fears about this straight with 18.
I believe it’s gonna be cool if you start a Tiki from scratch, but what about upgrading or switching
branch.

I would have like test compatibility as well as tools for a smooth switch.
We don’t want to be afraid of people doing changes (improvement) that make Tiki better we want to
promote them and help transitions. :)

Couldn't we start testing (even in an experimental branch) in 17.1 ?

--
Reply Link: <https://tiki.org//tiki-
view_forum_thread.php?forumId=26&comments_reply_threadId=65739&comments_parentId=6573
9&post_reply=1#form>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Bernard Sfez | bsfez.com


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Cloutier, Philippe (DGARI-Consultant)

Apologies for the awkward formatting below…

 

De : Bernard Sfez [mailto:[hidden email]]
Envoyé : 3 juillet 2017 11:16
À : Tiki developers <[hidden email]>
Objet : Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

 

Wooo, I must not have seen forum integration working that way in a long time!

 

Same :)

 

Well I’d like to see that simple as possible for the end user.

An option in the installer sound to me like the right option.

 

[Philippe Cloutier] Has the installer not allowed selecting the engine for years?

 

Have a Tiki17 (using MyISAM) having a Tiki17.1 with an option in the installer to convert to InnoDB and upgrade (backup should be done message) the database.

 

[Philippe Cloutier] Making conversions easier would be great, but if we don’t, I do not see why conversion issues would be a reason to keep defaulting to MyISAM.

 

Test = conversion + upgrade database + tada (it work fine). ;)

 

 

Bernard

 

On 3 Jul 2017, at 16:43 , Cloutier, Philippe (DGARI-Consultant) <[hidden email]> wrote:

 

Wooo, I must not have seen forum integration working that way in a long time!

Bernard, what testing are you proposing?



-----Message d'origine-----
De : Bernard Sfez / Tiki Specialist [[hidden email]]
Envoyé : 3 juillet 2017 04:55
À : [hidden email]
Objet : Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal
to approve

Re: Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Author: Bernard Sfez / Tiki Specialist

I see both tracks (17.1 or 18.0) and I have some fears about this straight with 18.
I believe it’s gonna be cool if you start a Tiki from scratch, but what about upgrading or switching
branch.

I would have like test compatibility as well as tools for a smooth switch.
We don’t want to be afraid of people doing changes (improvement) that make Tiki better we want to
promote them and help transitions. :)

Couldn't we start testing (even in an experimental branch) in 17.1 ?

--
Reply Link: <https://tiki.org//tiki-
view_forum_thread.php?forumId=26&comments_reply_threadId=65739&comments_parentId=6573
9&post_reply=1#form>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

 

Bernard Sfez | bsfez.com

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|

Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Bernard Sfez-3
An option in the installer sound to me like the right option.
 
[Philippe Cloutier] Has the installer not allowed selecting the engine for years?
 
Have a Tiki17 (using MyISAM) having a Tiki17.1 with an option in the installer to convert to InnoDB and upgrade (backup should be done message) the database.
 
[Philippe Cloutier] Making conversions easier would be great, but if we don’t, I do not see why conversion issues would be a reason to keep defaulting to MyISAM.


I didn’t wrote anywhere we should keep defaulting to MyISAM.

I’m trying to think of the best/easy process for end user.

Bernard


 
Test = conversion + upgrade database + tada (it work fine). ;)
 
 
Bernard
 
On 3 Jul 2017, at 16:43 , Cloutier, Philippe (DGARI-Consultant) <[hidden email]> wrote:
 
Wooo, I must not have seen forum integration working that way in a long time!

Bernard, what testing are you proposing?



-----Message d'origine-----
De : Bernard Sfez / Tiki Specialist [[hidden email]]
Envoyé : 3 juillet 2017 04:55
À : [hidden email]
Objet : Re: [Tiki-devel] Moving to InnoDB instead of MyISAM as the default database engine: Proposal
to approve

Re: Moving to InnoDB instead of MyISAM as the default database engine: Proposal to approve

Author: Bernard Sfez / Tiki Specialist

I see both tracks (17.1 or 18.0) and I have some fears about this straight with 18.
I believe it’s gonna be cool if you start a Tiki from scratch, but what about upgrading or switching
branch.

I would have like test compatibility as well as tools for a smooth switch.
We don’t want to be afraid of people doing changes (improvement) that make Tiki better we want to
promote them and help transitions. :)

Couldn't we start testing (even in an experimental branch) in 17.1 ?

--
Reply Link: <https://tiki.org//tiki-
view_forum_thread.php?forumId=26&comments_reply_threadId=65739&comments_parentId=6573
9&post_reply=1#form>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
 
Bernard Sfez | bsfez.com
 
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Bernard Sfez | bsfez.com


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel