I made some changes but I'm not sure if I understand this issue

Thanks @tsteur !
Can we somehow check if TokuDB is available? What if only MyISAM is available (I don't know if such case is possible)?

https://github.com/piwik/piwik/blob/master/config/global.ini.php#L22
This one shouldn't be hardcoded to InnoDB in my opinion. Better way would be to fallback to default-storage-engine. @mattab do you have any comments here?

This one shouldn't be hardcoded to InnoDB in my opinion. Better way would be to fallback to default-storage-engine

I don't understand the problem. It's basically the same with a different name or not?

Can we somehow check if TokuDB is available? What if only MyISAM is available (I don't know if such case is possible)?

I don't know how to do this without introducing a new step but then the tables are already created (and we have to run alter table engine=...). We need a database connection to get the available engines. I will delete my commit again as this seems like quite a bit of work.

Would it be maybe better to have a command to change the engine of all tables? Such a command should run very quickly after a fresh installation of Piwik

I've just updated ticket description. Maybe it's more clear now.

I don't think it's safe to use the default mysql engine. For example what if the default engine is set to an engine that does not support features we need? it is Piwik job to force users to use only engines that will work fine (Innodb or TokuDB).

If our goal is to let users install on TokuDB the current solution with new select field, should do the trick?

That's good point. There are also other compatible engines like XtraDB. Not sure how to proceed.

Our goal is to let users install Piwik on TokuDB. I would change this issue description to "Let users install Piwik on TokuDB database" and then close it as done?

Note to self: test what happens when installing selecting TokuDB and TokuDB is actually not available. Does it fail gracefully, show the form, and then let me select Innodb?

Final decision:

• we don't show the field during the installer to keep installer as clean as possible
• it will be possible to set the database engine in Piwik Enterprise with this change (from 2.14.0)

New FAQ published: How do I install Piwik using TokuDB table engine in a Mysql or MariaDB database?

Updated FAQ: How do I use another database like Postgresql, SQLite, Oracle? Will you support Nosql databases like Hadoop, Mongodb? to link to it

(Note: I didn't actually test it, but I tested with Myisam/Innodb which worked so I assume tokuDB will work too. if not, we will fix it next release after feedback from Piwik Enterprise team)