InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has a lot of advantages which have made it the preferred engine for lots of PHP script-driven software applications, including Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, as it locks only a single database row to accomplish a particular operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is treated. Put simply, adding new or updating existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case a given problem appears during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
InnoDB is offered with all our cloud plans by default, not upon request or as a paid upgrade, so you can activate and run any script-driven web app which requires the database engine without the need to deal with any difficulty once you open your account. InnoDB will be pre-selected as the default engine for a given database during the app activation, no matter if you use our one-click installer or create the database and set up the app manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will keep regular backups of all your databases, so you can be sure that you’ll never lose any content if you erase a database by accident or you overwrite some crucial info – you just have to alert us and we’ll restore your data the way it was.