Learn what a database engine is, what exactly are the advantages of the InnoDB engine and why it's gaining so much popularity.
InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got plenty of strong sides which have made it the preferred engine for a lot of open-source script-powered web apps, including Joomla™ and Magento, which have switched to InnoDB permanently. For instance, importing large amounts of data will be much faster with InnoDB, because it locks only one database row to carry out an operation, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is handled. Simply put, importing new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if any problem shows up in the meantime, so the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
InnoDB is offered with all our Linux cloud packages by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP-powered web application that requires the MySQL database storage engine without the need to deal with any problem once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation, regardless of whether you take advantage of our one-click installer or create the MySQL database and activate the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll perform daily backups of all your databases, so you can rest assured that you’ll never lose any content in case you erase a database by accident or you overwrite some essential information – you just have to inform us and we will restore your database back to normal.