InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by plenty of devs that write scalable apps, as it works better with huge volumes of data, while it keeps the server processing load at a minimum. Additionally, it uses row-level locking in case any info should be modified, while many other engines lock the entire table and hence require much more time to handle several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or losing data. Magento and the latest Joomla versions are two instances of popular PHP script-driven software applications which have switched over to InnoDB.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it’s an essential part of the default set of features offered with our shared web hosting plans. In case you would like to make use of a PHP-powered software app that needs InnoDB in particular, in order to be activated and to operate properly, you will not face any problems because the database engine is available on our custom-built cloud platform. Irrespective of whether you create a brand new database and install an app manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB rather than MyISAM. In addition to the remarkable crash recovery that InnoDB is offering, we also store daily database backups, so we can swiftly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans come with InnoDB and you can take advantage of all the features offered by this MySQL storage engine with any PHP-powered web app that requires it. It is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not need to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer tool. To avoid any risk, we’ll generate daily backups of all your MySQL databases, so if something goes wrong following some update or if you erase some content unintentionally, we will be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an indivisible part of the standard software bundle that will be pre-installed on your VPS server before we hand it over to you. You won’t need to set up anything manually and you’ll be able to install and manage any PHP-based application that requires InnoDB once your Virtual Private Server is set up, which takes no more than 1 hour after the order process itself. Several engines are offered, so every time you set up a database via the Hepsia hosting Control Panel, a particular engine will be activated once the app installation process begins and our system will recognize the engine that is required by the application in question. In case you need MyISAM, for example, you won’t need to do anything different than installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It’s part of the software bundle that will be installed on all Hepsia-managed servers, so once your machine is up and running, you’ll be able to log in and to activate a various open-source script-powered web application that needs this particular storage engine. When you create a new database via the Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app activation wizard starts inserting information into the newly created database, the engine will be chosen automatically in accordance with the specific app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any point. Thus, you can make use of a large collection of apps for your websites.