InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a much better overall performance and an improved database failure recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of devs that build highly scalable apps, since it works more effectively with immense data volumes, while it keeps the server load at a minimum. What’s more, it locks only a single row in the database if any info should be updated, whereas lots of other engines lock the entire database table and therefore need more time to fulfill several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed for any reason, the action is rolled back to avoid confusion or data loss. Magento and the newest versions of Joomla are two instances of popular open-source script-based web applications that have shifted over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with other web hosting companies, it is part of the standard set of features that we offer with our cloud hosting packages. In case you’d like to use a PHP-powered software app that requires InnoDB specifically, in order to be activated and to perform correctly, you will not have any difficulties because the InnoDB database storage engine is available on our custom-built cloud web hosting platform. Irrespective of whether you set up a new MySQL database and install an app manually or use our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given app needs InnoDB instead of MyISAM. Besides the exceptional database failure recovery that InnoDB offers, we also generate regular database backups, so that we can easily restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with each of our Linux semi-dedicated services by default, so once you purchase a new semi-dedicated account, you can go ahead and install any open-source script-driven software application that requires the storage engine. Several engines are installed on our cloud web hosting platform, so when you set up a new MySQL database and start installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the prerequisites of the given application. This will allow you to activate and run InnoDB-specific applications without needing to cope with any problem and without the need to configure any settings in your semi-dedicated account. To avoid any risk, we will always have a 7-day-old backup of all your MySQL databases, so if you delete or change any content by mistake, we can swiftly rescue it.

InnoDB in VPS Hosting

If our custom-built Hepsia hosting Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server together with other needed pieces of software, so you won’t need to do anything if you decide to use script-based web apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin the app installation procedure manually or using our 1-click installation tool. The system will detect which engine the app in question requires and will set it for the specific MySQL database, so the installation will continue impeccably and the app can import its content into that database. Thus, you can install applications with different requirements with regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

InnoDB is included as standard with all dedicated hosting services ordered with the Hepsia Control Panel. It is part of the default software package that we install on all Hepsia-managed servers, so as soon as your machine is ready, you’ll be able to log in and to install a various PHP-based web application that needs this MySQL storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any activated engine until you begin installing an app. Once the app setup wizard begins dumping information in the newly created database, the engine will be set automatically depending on the requirements of the particular app, so you can run both InnoDB and MyISAM without having to select either of them specifically at any point. Thus, you can use a large range of apps for your sites.