InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has plenty of pluses which have made it the engine of choice for a lot of script-based web apps, among them Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding huge amounts of data will be faster with InnoDB, due to the fact that it locks only one database row to carry out a task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is handled. To put it simply, importing new or editing existing data will either be entirely completed, or will be aborted and the operation will be rolled back in case some problem occurs in the meantime, hence the content that remains in the database will not be damaged.
InnoDB in Cloud Hosting
Every script-powered web app that requires InnoDB will run flawlessly on our cutting-edge cloud platform and the MySQL storage engine comes with all our cloud hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll make daily backups of your content, so if you unintentionally erase a database that is important to you or you overwrite certain parts of it, we will be able to restore the database the way it was just several hours earlier.