Learn more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by numerous devs that write highly scalable software applications, due to the fact that it works better with immense amounts of data, while it keeps the server load low. What’s more, it locks only a single row in the database if any information should be updated, whereas many other engines lock the entire table and thus require more time to carry out multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for whatever reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest Joomla™ versions are two examples of widely used open-source script-driven web applications which have moved to InnoDB.
InnoDB in Hosting
You can activate any open-source script-based software application that needs InnoDB in case you have a Linux hosting package with us, as the MySQL storage engine is available on our cutting-edge cloud web hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can run applications which require the MyISAM engine without the need to deal with any problem as well and, again, the engine will be selected automatically, so you won’t need to modify any setting manually at any moment. On top of that, we will also perform daily backups of all the databases that you have in your shared hosting account, so in case you delete or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.