Is there any reason not to use InnoDB by default?

[pauamma]

I just noticed that $LJ::USE_INNODB isn't listed in etc/config*, doc/config*, or cgi-bin/ljdefaults.pl. Before I file a bug, a question: is there any reason why the default/initial/suggested value should remain to the current "don't use it"?

Comments

[mark]

MyISAM is more portable, so some people prefer to use that on their local environments. Generally speaking though, there's no real reason to not do InnoDB that I can think of and I would support standardizing on that.

Something that should be thought about, though, is whether or not we should consider looking at some of the newer engines. InnoDB is somewhat old now, which is not necessarily a bad thing, but another point to consider is that they're owned by Oracle too.

[sophie]

MySQL itself is owned by Oracle too, now, though. :)

[pauamma]

Are you thinking of other MySQL storage engines? (I don't see any engine that would offer obvious advantages listed on that page.) Or (since MySQL is now owned by Sun Oracle), were you thinking of other database servers? (The first that comes to my mind is PostgreSQL, but there may be others worth looking at in that case.)

[mark]

Actually I was thinking of something even stranger -- MariaDB or Drizzle. Both done by people who have been involved in the MySQL world rather intimately, and both carry a lot of that same ethos.

They're similar, especially in the case of MariaDB, but the difference is that they're still independent projects and are gaining a lot of traction in the open source world. They're not Corporate Zomg Projects.

OTOH, MySQL will work for a long time to come I bet and it's so widely supported...

[denise]

I'm actually listening to a lightning talk about MongoDB right now!