InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a better overall performance and an improved database crash recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by numerous programmers that create scalable web apps, because it works much more effectively with huge data volumes, while it keeps the server load at a minimum. Additionally, it uses row-level locking in case any info should be modified, while many other engines lock the entire database table and hence require more time to handle several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla editions are two instances of famous PHP-based web applications which have switched over to InnoDB.
InnoDB in Shared Web Hosting
You can install any PHP script-driven app that needs InnoDB if you have a shared web hosting with us, as the storage engine is present on our cutting-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can run applications that need the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you won’t need to modify any setting manually at any time. What’s more, we’ll also create regular backups of all the MySQL databases that you have in the shared hosting account, so in case you delete or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.