InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a significantly better overall performance and a faster crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is used by many developers that write scalable applications, due to the fact that it works much more efficiently with immense volumes of data, while it keeps the server load at a minimum. Furthermore, it locks only one database row in case any information should be updated, while lots of other engines lock the entire database table and therefore need much more time to carry out multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the latest Joomla editions are two examples of popular PHP script-based web apps which have shifted over to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting companies, it’s an essential part of the standard set of services offered with our website hosting plans. In case you wish to use a script-driven web application that requires InnoDB specifically, in order to be activated and to perform properly, you will not have any problems since the storage engine is available on our custom-developed cloud web hosting platform. Regardless of whether you set up a brand-new database and activate an application manually or make use of our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it instead of MyISAM. Besides the amazing crash recovery that InnoDB offers, we also generate daily backups of all databases, so that we can easily recover any database in your shared account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages support InnoDB and you can take full advantage of all the features offered by this storage engine with any PHP-powered software application that needs it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the requirements of the specific app. You will not have to do anything manually in order to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click app installer. To be on the safe side, we will maintain daily backups of all your databases, so if something goes wrong following some update or if you remove some content by mistake, we will be able to get the database back to the way it was on any of the past seven days.

InnoDB in VPS Web Hosting

In case our in-house built Hepsia hosting Control Panel is picked during the signup process for your new Linux VPS web hosting packages , InnoDB will be installed on the VPS server together with other needed pieces of software, so you won’t need to do anything if you decide to manage PHP-powered software apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new database and begin installing the application manually or using our single-click installer tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can dump its content in that database. In this way, you can install apps with different requirements with regard to the MySQL engine without the need to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

InnoDB comes as standard with all dedicated servers hosting ordered with the Hepsia Control Panel. It is an integral part of the default software package that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is set up, you’ll be able to sign in and to activate any type of PHP-powered application that requires this particular storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app setup wizard starts importing data into the database, the engine will be selected automatically depending on the requirements of the given application, so you can use both MyISAM and InnoDB without the need to select either one of them explicitly at any time. In this way, you can make use of a vast range of applications for your sites.