InnoDB is a database storage engine for MySQL databases, which is used by famous PHP-powered apps like Magento and Joomla™ v3. It’s perfect for scalable apps, because it performs really well when managing enormous amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and modifications should be handled. If a certain task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially mixed with newly inserted content.
InnoDB in Cloud Hosting
Every PHP script-based software application that requires InnoDB will run flawlessly on our leading-edge cloud web hosting platform and the MySQL database engine comes with all our cloud hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected based on the app’s requirements without having to edit any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We will keep daily backups of your content, so if you accidentally remove a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was only a couple of hours earlier.