InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by numerous developers that build scalable web apps, as it works more efficiently with immense volumes of data, while it keeps the server load low. Furthermore, it locks only one database row if any info should be edited, whereas many other engines lock the entire database table and hence require much more time to handle multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla editions are two instances of popular PHP-driven web apps which have moved to InnoDB.

InnoDB in Shared Hosting

Any PHP script-based web application that needs InnoDB will run flawlessly on our avant-garde cloud hosting platform and the MySQL database engine comes with all our shared hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll perform regular content backups, so in case you accidentally delete a MySQL database that you need or you overwrite some part of it, we will be able to restore your database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you will be able to use all the features offered by this MySQL database storage engine with any open-source script-powered web app that needs it. InnoDB is one of the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the particular app’s prerequisites. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we will generate daily backups of all your MySQL databases, so if anything goes wrong following some update or if you remove some data by accident, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other needed pieces of software, so you won’t have to do anything if you decide to manage script-based software apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and start installing the application manually or using our single-click installer tool. The system will recognize which engine the app in question requires and will set it for the specific database, so the installation process will continue impeccably and the app can enter its data into that database. Thus, you can activate apps with different requirements in regard to the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to pick any of the 3 Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to install this storage engine manually in order to be able to use script-powered software apps that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need to run very large sites, it is very likely that you will resort to InnoDB. You’ll be able to use other engines too, so in case a specific app needs MyISAM rather than InnoDB, you will not have any problem while managing it. The engine that will be used will be automatically recognized as soon as the app installation begins, so you won’t need to fine-tune any settings manually whatsoever.