InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a significantly better overall performance and an improved crash recovery in comparison with the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of developers that build scalable web apps, since it works much better with immense data volumes, while it keeps the server processing load at a minimum. Moreover, it locks only a single row in the database if any information should be modified, whereas many other engines lock the entire table and hence need much more time to execute multiple consecutive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla are two examples of famous open-source script-driven software apps which have switched over to InnoDB.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it’s an integral part of the default set of features that we are offering with our cloud web hosting packages. In case you would like to make use of a PHP-based software app that requires InnoDB particularly, in order to be installed and to perform properly, you will not encounter any impediments because the storage engine is available on our custom cloud hosting platform. Regardless of whether you create a brand-new database and install an app manually or take advantage of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application needs InnoDB rather than MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also store regular backups of all databases, so that we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the hosting Control Panel offered with all our semi-dedicated server accounts and you begin installing a script-based software app either manually or using our single-click application installer, the MySQL database storage engine will be picked automatically based on the prerequisites of the given app. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any point. To avoid any chance of losing data if you update an application or if you delete a database by mistake, we will make a backup of all your MySQL databases each and every day, so if something goes wrong, we can recover your content.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually in case you’d like to use open-source PHP scripts that need it. All it takes to install such a script is to create a new database and to initiate the installation process – once the installer wizard receives access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to install scripts that require the other widely used MySQL engine – MyISAM, so you won’t have to update any settings on the server. This will enable you to run a variety of scripts on a single physical server and to use it to its maximum potential.