coolnet560 Posted Monday at 08:58 AM Posted Monday at 08:58 AM 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 Monday at 09:42 AM Posted Monday at 09:42 AM 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 Monday at 03:32 PM Author Posted Monday at 03:32 PM 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 Tuesday at 05:20 PM Author Posted Tuesday at 05:20 PM (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 Tuesday at 05:21 PM by coolnet560
Marc Posted Wednesday at 09:45 AM Posted Wednesday at 09:45 AM You (or your host) would actively need to change the tables to using the INNODB engine.
Joey_M Posted Wednesday at 12:33 PM Posted Wednesday at 12:33 PM 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 Wednesday at 12:38 PM Posted Wednesday at 12:38 PM 4 minutes ago, Joey_M said: Is InnoDB recommended over MyISAM, for v4.7? Yes. Joey_M 1
Recommended Posts