InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is preferred by many devs that run scalable web apps, due to the fact that it works much better with enormous volumes of data, while it keeps the server processing load low. Furthermore, it locks only a single database row in case any information should be edited, while lots of other engines lock the entire database table and thus need more time to carry out multiple successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla releases are two instances of widely used script-powered software apps that have moved to InnoDB.

InnoDB in Hosting

Any PHP script-powered software application that needs InnoDB will function impeccably on our cutting-edge cloud web hosting platform and the storage engine is offered with all our hosting plans. Every time you create a MySQL database manually or our app installer tool 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 specifications without the need to configure any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We will generate daily content backups, so in case you accidentally delete a database that is important to you or you overwrite some part of it, we will be able to restore the database the way it was just a few hours earlier.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated packages come with InnoDB and you can take full advantage of all the features of this MySQL storage engine with any open-source script-based web app that requires it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the app in question. You will not have to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we will make daily MySQL database backups, so if anything goes wrong following an update or if you remove some data by mistake, we will be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be included in the software bundle that will be pre-installed on your Virtual Private Server before we give it to you. You won’t need to set up anything manually and you’ll be able to install and manage any PHP script-based software app that needs InnoDB when your VPS is up and running, which takes no more than sixty minutes after the order submission process itself. A number of engines are offered, so anytime you create a MySQL database via the Hepsia Control Panel, a particular engine will be picked once the app activation starts and our system will automatically detect the engine that is required by the app in question. In case you need MyISAM, for instance, you won’t have to do anything different from installing the desired application, whether manually or using our app installer.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually if you’d 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 initiate the setup process – as soon as the setup wizard obtains access to the database in question 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 activate scripts that require the other very popular MySQL engine – MyISAM, so you will not need to configure any settings on the dedicated server. This will allow you to activate various scripts on one single machine and to use the latter to its full capacity.