InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database failure recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by a lot of programmers that create highly scalable web apps, since it works much better with huge volumes of data, while it keeps the server load low. Furthermore, it locks only a single row in the database in case anything should be modified, while lots of other engines lock the entire table and hence require more time to handle multiple successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest Joomla versions are two examples of widespread open-source script-based applications that have moved to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it is included in the standard set of services offered with our shared hosting packages. If you would like to make use of a PHP script-driven app that needs InnoDB in particular, in order to be activated and to work correctly, you won’t come across any difficulties as the database storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a brand new database and install an app manually or make use of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application requires InnoDB rather than MyISAM. Besides the exceptional crash recovery offered by InnoDB, we also store daily database backups, so we can swiftly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the hosting Control Panel provided with all our semi-dedicated server packages and you begin installing a PHP script-based app either manually or using our 1-click application installer tool, the MySQL database storage engine will be set automatically on the basis of the given app’s prerequisites. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any time. To prevent any risk of losing data if you update an app or if you delete a database by mistake, we’ll carry out a backup of all your databases each day, so if something goes wrong, we can rescue your content.

InnoDB in Dedicated Servers Hosting

When you purchase a new dedicated server, you will be able to pick any of the 3 hosting Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to enable this MySQL database storage engine manually to be able to use PHP script-based apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you need to run large-size Internet sites, it’s quite likely that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a specific app needs MyISAM rather than InnoDB, you won’t have to deal with any obstacle while using it. The engine that will be used will be detected automatically the moment the app installation procedure starts, so you won’t need to modify any settings manually at any moment.