InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has a number of pluses which have made it the engine of choice for many PHP script-powered software apps, among them Magento and Joomla, which have moved to InnoDB permanently. For instance, adding large amounts of data will be much faster with InnoDB, since it locks only a single row to carry out a certain task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is treated. To put it simply, adding new or editing existing data will either be entirely completed, or will be canceled and the procedure will be rolled back if any problem appears in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
You’ll be able to run any script-based web app that requires InnoDB if you’ve got a cloud hosting with us, as the MySQL storage engine is present on our innovative cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can run apps which use the MyISAM engine without any difficulties as well and, again, the engine will be pre-selected, so you will not need to configure any setting manually at any time. Furthermore, we’ll also make regular backups of all the MySQL databases that you’ve got in the shared web hosting account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.