InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is used by lots of web developers that run scalable web apps, since it works much better with enormous volumes of data, while it keeps the server processing load low. Moreover, it it locks only one row in the database in case any info should be updated, while many other engines lock the entire database table and hence need more time to perform several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for whatever reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla™ versions are two examples of famous PHP-powered applications which have shifted over to InnoDB.

InnoDB in Hosting

Any PHP script-powered web application that needs InnoDB will function impeccably on our leading-edge cloud website hosting platform and the database engine is offered with all our hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to change any setting in your hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll keep daily content backups, so in case you unintentionally remove a MySQL database that you need or you overwrite specific parts of it, we will be able to restore your content the way it was only several hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the Control Panel included with each of our semi-dedicated server plans and you start installing a script-powered application either manually or using our single-click application installer tool, the storage engine for the database will be selected automatically based on the prerequisites of the given application. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any time. To prevent any risk of losing data if you update an application or if you remove a database unintentionally, we will perform a backup of all your MySQL databases each and every day, so if something goes wrong, we can retrieve your data.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our custom Hepsia Control Panel include a software bundle that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you would like to activate scripts that need it. All it takes to install such a script is to set up a new MySQL database and to begin the setup – as soon as the script configuration wizard gains access to the database and starts importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you won’t have to update any settings on the server. This will enable you to use various scripts on one single physical machine and to use the latter to its full capabilities.