InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-driven web apps such as Magento and Joomla™ v3. It is excellent for scalable apps, as it works remarkably well when managing immense data volumes. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. Also, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that specify how data imports and modifications should be handled. In case a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will stay undamaged and won’t be partially merged with newly imported content.
InnoDB in Website Hosting
You’ll be able to use any script-driven application that needs InnoDB in case you’ve got a website hosting plan with our company, as the MySQL database engine is present on our innovative cloud web hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can run apps which need the MyISAM engine without encountering any obstacle as well and, once again, the engine will be pre-selected, so you won’t need to edit any setting manually at any moment. In addition, we’ll also carry out daily backups of all the MySQL databases that you have in the shared hosting account, so if you delete or overwrite something, we can quickly get it back to the way it was on any of the past seven days.