Find out about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a better overall performance and a faster database crash recovery in comparison with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by many developers that build highly scalable apps, as it works much better with enormous amounts of data, while it keeps the server load at a minimum. Furthermore, it it locks only one row in the database if anything should be edited, while many other engines lock the entire database table and thus require much more time to complete multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the action is rolled back to prevent confusion or losing data. Magento and the latest editions of Joomla™ are two instances of popular PHP script-based apps which have moved to InnoDB.
InnoDB in Hosting
Every open-source script-powered web app that needs InnoDB will run impeccably on our avant-garde cloud hosting platform and the database storage engine comes with all our hosting packages. Each time you create a MySQL 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 prerequisites without having to modify any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to take advantage of its full capacity. We will make daily content backups, so if you accidentally erase a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore everything the way it was only a few hours ago.