InnoDB is a popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got plenty of strengths that make it the preferred engine for plenty of PHP-driven apps, such as Joomla and Magento, which have shifted over to InnoDB permanently. For example, importing huge data volumes will be much faster with InnoDB, because it locks only a single row to execute a certain operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is handled. Put simply, adding new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back if any problem occurs during the process, so the content that remains in the database will not be lost.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared packages by default, not upon request or as a paid upgrade, so you will be able to install and manage any open-source script-based application that needs the MySQL database storage engine without having any problem as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a specific database during the app installation process, regardless of whether you make use of our one-click installer or create the MySQL database and set up the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll make daily MySQL database backups, so you can be certain that you won’t ever lose any data in case you erase a database by mistake or you overwrite some vital info – you will just have to touch base with us and we’ll restore your database the way it was.