InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a better overall performance and a faster database failure recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by numerous devs that write highly scalable software apps, because it works much better with large volumes of data, while it keeps the server load low. Moreover, it it locks only one row in the database if anything should be modified, whereas many other engines lock the entire table and hence require more time to process several successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest Joomla releases are two examples of popular script-driven software apps which have moved to InnoDB.

InnoDB in Cloud Hosting

Every open-source script-based app that requires InnoDB will function flawlessly on our leading-edge cloud website hosting platform and the MySQL storage engine is available with all our cloud hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to edit any setting in your shared web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full capacity. We will keep daily content backups, so in case you unintentionally delete a database that you need or you overwrite a certain part of it, we’ll be able to restore the database the way it was just several hours earlier.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers support InnoDB and you can take full advantage of all the features of this database storage engine with any script-driven web application that requires it. It’s among the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the given app’s prerequisites. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our single-click application installer tool. To avoid any risk, we’ll keep regular backups of all your databases, so if something goes wrong after some update or if you delete some content unintentionally, we will be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the standard software pack that will be pre-installed on your server before we hand it over to you. You will not have to activate anything manually and you’ll be able to enable and use any script-powered application that needs InnoDB once your VPS is up and running, which takes no more than sixty minutes after the order submission itself. A number of engines are offered, so anytime you create a database via the Hepsia hosting Control Panel, a specific engine will be selected when the app activation process begins and our system will automatically detect the engine that is required by the application in question. If you need to use MyISAM, for instance, you will not need to do anything different from installing the desired app, whether manually or using our application installer.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you’ll be able to choose one of the 3 hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to install this storage engine manually so as to be able to run script-driven web applications that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you need in order to run large-scale websites, it is quite possible that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a particular application requires MyISAM instead of InnoDB, you will not experience any problem while using it. The engine that will be used will be recognized automatically as soon as the app installation procedure begins, so you won’t have to edit any setting manually at any point.