InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got many advantages that have made it the preferred engine for numerous open-source script-powered software apps, such as Magento and Joomla™, which have moved to InnoDB for good. For example, importing immense amounts of data will be faster with InnoDB, since it locks only one row to carry out an operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. Put simply, appending new or modifying existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a certain problem occurs in the meantime, which is why the content that remains in the database will not be damaged.
InnoDB in Hosting
InnoDB is offered with all our Linux hosting packages by default, not as a paid upgrade or upon request, so you will be able to install and run any script-based web application which requires the InnoDB database engine without encountering any difficulty as soon as you open your account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, regardless of whether you use our 1-click installer or create the database and install the app manually, provided that the app requires it instead of the more popular MyISAM engine. We will perform daily database backups, so you can be sure that you won’t ever lose any data if you erase a database unintentionally or you overwrite some important information – you’ll just need to notify us and we’ll restore your content the way it was.