InnoDB is a very popular database storage engine for MySQL. It is an alternative to the default MyISAM engine and it has got many upsides that have made it the preferred engine for lots of script-powered applications, such as Magento and Joomla, which have moved to InnoDB permanently. For example, importing enormous volumes of data will be much faster with InnoDB, because it locks only a single database row to complete a given operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is treated. In simpler words, adding new or updating existent data will either be entirely completed, or will be canceled and the procedure will be rolled back if any problem shows up during the process, thus the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You will be able to run any open-source script-driven software application that requires InnoDB if you have a Linux shared hosting with us, as the storage engine is available on our cutting-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run apps that require the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be pre-selected, so you won’t need to edit anything manually at any moment. Furthermore, we will also carry out daily backups of all the MySQL databases that you’ve got in the shared hosting account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.