InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides 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 used by numerous developers that create scalable software apps, because it works more efficiently with huge amounts of data, while it keeps the server load low. Moreover, it uses row-level locking in case anything should be updated, while many other engines lock the entire database table and thus need more time to execute several successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for whatever reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla editions are two examples of widespread script-driven web apps which have moved to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosting companies, it’s part of the default set of services that we’re offering with our shared website hosting packages. In case you’d like to use a script-driven application that requires InnoDB particularly, in order to be installed and to perform properly, you won’t encounter any difficulties because the InnoDB database engine is available on our in-house built cloud hosting platform. No matter if you set up a new MySQL database and activate an application manually or use our one-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs InnoDB instead of MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also keep regular database backups, so that we can quickly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you will be able to get the most out of all the features of this MySQL database storage engine with any script-driven application that needs it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given app. You won’t need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To be on the safe side, we will keep daily database backups, so if something goes wrong following some update or if you erase some data by mistake, we’ll be able to restore the database the way it was on any of the previous 7 days.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t have to activate it manually in case you would like to run PHP scripts that require it. All it takes to use such a script is to create a new database and to start the setup process – once the installer wizard receives access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You’ll also be able to use scripts that require MyISAM – the other widely used MySQL engine, so you won’t have to configure any settings on the server. This will permit you to use various scripts on a single physical machine and to use it to its maximum capabilities.