InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and a faster database crash recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many developers that write scalable web apps, as it works better with enormous volumes of data, while it keeps the server load at a minimum. What’s more, it locks only a single database row in case anything should be updated, whereas lots of other engines lock the entire table and therefore require much more time to process multiple sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for some reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest versions of Joomla are two examples of widespread script-powered web applications which have shifted over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with other hosting companies, it is included in the default set of features that we offer with our cloud hosting plans. If you want to use a PHP-powered web app that requires InnoDB in particular, in order to be installed and to work correctly, you won’t experience any difficulties because the InnoDB database engine is available on our custom cloud web hosting platform. Regardless of whether you create a new MySQL database and activate an application manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular app requires InnoDB instead of MyISAM. In addition to the incredible database failure recovery that InnoDB is offering, we also generate regular backups of all databases, so we can easily recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel provided with each of our semi-dedicated server accounts and you start installing a PHP-based web app either manually or using our single-click application installer, the database storage engine will be set automatically on the basis of the prerequisites of the specific application. Since InnoDB is present on the cloud platform where your new account will be created, it will be set as the default engine for any application that requires it without the need for any manual action on your end at any time. To prevent any chance of losing data if you update an application or if you erase a database unintentionally, we will perform backups of all your databases every day, so if anything happens, we can recover your data.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software pack that will be pre-installed on your VPS server before we hand it over to you. You will not need to set up anything manually and you’ll be able to enable and manage any open-source script-powered software application that needs InnoDB once your VPS is up and running, which takes no more than one hour after the order submission procedure itself. A number of engines are available, so every time you set up a database via the Hepsia hosting Control Panel, a particular engine will be selected once the app activation begins and our system will automatically detect which engine is required by the application in question. In case you need to use MyISAM, for example, you won’t have to do anything different than installing the app of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you will not need to install it manually in case you’d like to activate open-source PHP scripts that need it. All it takes to activate such a script is to create a new database and to initiate the setup process – as soon as the setup wizard acquires access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You’ll also be able to install scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to modify any settings on the dedicated server. This will enable you to activate a variety of scripts on one single machine and to use it to its full potential.