InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved database failure recovery compared to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of developers that create highly scalable software applications, as it works much more efficiently with enormous amounts of data, while it keeps the server processing load low. Additionally, it locks only a single database row in case anything should be edited, whereas many other engines lock the entire database table and therefore need much more time to accomplish several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest releases of Joomla are two instances of widespread PHP-driven software platforms that have switched over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many other hosting companies, it’s included in the standard set of services that we’re offering with our shared hosting packages. In case you wish to use an open-source script-based web application that needs InnoDB particularly, in order to be activated and to work correctly, you won’t have to deal with any obstacles since the database storage engine is available on our in-house developed cloud platform. Regardless of whether you create a brand-new MySQL database and install an application manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. In addition to the excellent database failure recovery that InnoDB offers, we also keep regular database backups, so that we can quickly recover any database in your shared web hosting account.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually if you’d like to run PHP scripts that need it. All it takes to activate such a script is to set up a new database and to initiate the installation – as soon as the script configuration wizard acquires access to the database in question and starts inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to install scripts that need the other popular MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will enable you to activate a variety of scripts on a single machine and to use it to its maximum capacity.