InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-based applications like Magento and Joomla™ 3. It’s perfect for scalable apps, because it works exceptionally well when handling enormous amounts of data. Instead of locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same period of time. Also, InnoDB offers a better database crash recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. If a particular task has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be kept undamaged and won’t be partially merged with newly imported content.
InnoDB in Shared Web Hosting
You’ll be able to install any PHP script-based application that needs InnoDB in case you’ve got a Linux shared web hosting package with us, as the storage engine is present on our innovative cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can install applications which use the MyISAM engine without any problems as well and, again, the engine will be selected automatically, so you will not need to edit anything manually at any point. On top of that, we will also generate regular backups of all the databases that you have in the account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the previous seven days.