What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a database engine for MySQL databases, which is used by popular script-based apps like Magento and Joomla™ 3.x. It’s perfect for scalable apps, because it performs astonishingly well when handling enormous data volumes. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same length of time. Furthermore, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and updates should be treated. In case a given task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and will not be partially mixed with newly added content.
InnoDB in Cloud Web Hosting
Any PHP-driven web app that requires InnoDB will run impeccably on our leading-edge cloud platform and the database storage engine comes with all our cloud web hosting
packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s specifications without the need to change any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to get the most out of its full capacity. We’ll generate daily content backups, so if you accidentally remove a MySQL database that you need or you overwrite a specific part of it, we’ll be able to restore the database the way it was just several hours ago.