What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a much better overall performance and an improved database crash recovery compared with the default engine used by MySQL – MyISAM. InnoDB is used by plenty of devs that write highly scalable software apps, as it works more effectively with immense volumes of data, while it keeps the server processing load at a minimum. Also, it locks only a single database row if any info should be edited, while many other engines lock the entire table and thus need more time to process multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest releases of Joomla™ are two instances of widely used open-source script-driven apps that have shifted over to InnoDB.
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other website hosting service providers, it is an essential part of the standard set of features offered with our shared web hosting packages. In case you want to make use of an open-source script-powered web app that requires InnoDB particularly, in order to be activated and to perform correctly, you won’t face any obstacles because the InnoDB storage engine is available on our custom cloud hosting platform. No matter if you set up a brand new database and install an app manually or use our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the application requires it instead of MyISAM. Besides the incredible crash recovery that InnoDB offers, we also carry out daily database backups, so that we can swiftly restore any MySQL database in your shared account.