InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by many web developers that create highly scalable web applications, due to the fact that it works much better with large data volumes, while it keeps the server processing load at a minimum. Furthermore, it locks only a single database row in case any information should be updated, whereas lots of other engines lock the entire database table and therefore require much more time to carry out several consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla™ releases are two examples of famous script-powered apps that have switched to InnoDB.

InnoDB in Shared Website Hosting

Any PHP script-driven software application that requires InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the database engine is offered with all our shared website hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We’ll perform daily content backups, so if you unintentionally remove a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your content the way it was just several hours earlier.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting come with InnoDB and you’ll be able to get the most out of all the features offered by this MySQL database storage engine with any open-source script-powered web application that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be selected depends on the requirements of the particular application. You will not need to do anything manually to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click application installer. To avoid any risk, we’ll maintain regular backups of all your databases, so if something goes wrong after an upgrade or if you remove some content unintentionally, we will be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS

When you obtain a virtual private server from us, you’ll be able to take full advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to install any PHP script-based application which needs InnoDB, as this MySQL storage engine is an integral part of the default software bundle that will be installed on your VPS server during its setup. When you create a brand new database using the hosting Control Panel, you simply have to start installing an application – manually or using our app installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not need to do anything else in your VPS account. Likewise, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you will not have to activate it manually if you want to run open-source PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the installation process – as soon as the installer wizard receives access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that need MyISAM, the other popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will permit you to run various scripts on one single server and to use the latter to its fullest capacity.