coolnet560 Posted November 18 Posted November 18 I was wondering if there's a major difference between MariaDB and InnoDB. I know Maria works in the IP 4 and with the IP 5 coming out there will be requirement to use InnoDB. Is there a specific reason why InnoDB is needed?
Marc Posted November 18 Posted November 18 You are comparing 2 different things here. MariaDB is an alternative to MySQL. INNODB is the storage engine that is used. INNODB can be used on both MariaDB and MySQL. INNODB is simply the better storage engine. Its even the default for MySQL versions these days. If you want to read more about it, have a read here https://blog.devart.com/myisam-vs-innodb.html coolnet560 1
coolnet560 Posted November 18 Author Posted November 18 Ah thank you for the clarification. I’m having my hosting provider to convert it over to InnoDB for the IP 5 Marc 1
coolnet560 Posted November 19 Author Posted November 19 (edited) Question, when your hosting provider upgrades your database to support InnoDB is there anything that I would have to do to make sure it works or is that something the hosting provider needs to do. My provider upgraded the server to support InnoDB. 10.5.27-MariaDB-cll-lve - MariaDB Server Edited November 19 by coolnet560
Marc Posted November 20 Posted November 20 You (or your host) would actively need to change the tables to using the INNODB engine.
Joey_M Posted November 20 Posted November 20 2 hours ago, Marc said: You (or your host) would actively need to change the tables to using the INNODB engine. Is InnoDB recommended over MyISAM, for v4.7?
Jim M Posted November 20 Posted November 20 4 minutes ago, Joey_M said: Is InnoDB recommended over MyISAM, for v4.7? Yes. Joey_M 1
Recommended Posts