InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a significantly better overall performance and an improved database failure recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by a lot of programmers that create highly scalable apps, since it works much better with huge data volumes, while it keeps the server load at a minimum. Additionally, it locks only a single database row if anything should be modified, whereas many other engines lock the entire database table and therefore need more time to process several sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest releases of Joomla are two examples of popular PHP-based applications that have shifted over to InnoDB.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with many other website hosting service providers, it’s part of the standard set of services that we’re offering with our hosting plans. If you would like to use an open-source script-powered app that requires InnoDB specifically, in order to be installed and to perform correctly, you will not have any problems because the MySQL storage engine is available on our custom-built cloud hosting platform. Regardless of whether you create a brand-new MySQL database and activate an app manually or use our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB instead of MyISAM. Besides the amazing database crash recovery offered by InnoDB, we also generate regular backups of all databases, so we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated hosting plans by default, so the moment you obtain a new semi-dedicated account, you can move on and activate any open-source script-based software application that needs this particular database engine. A couple of engines are pre-installed on our cloud hosting platform, so when you create a new database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be chosen on the basis of the requirements of the respective application. This will permit you to install and run InnoDB-specific applications without needing to cope with any complication and without the need to configure any settings in your account. To be on the safe side, we will always have a 7-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can quickly recover it.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the software pack that will be pre-installed on your server before we hand it over to you. You will not need to activate anything manually and you’ll be able to enable and manage any open-source script-driven software application that requires InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission process itself. Several engines are offered, so anytime you create a database using the Hepsia Control Panel, a specific engine will be selected when the app activation process starts and our system will automatically recognize which engine is required by the application in question. If you need to use MyISAM, for example, you won’t need to do anything different than installing the chosen app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia Control Panel come with a software bundle that is pre-activated and among everything else, you will get the InnoDB database engine, so you won’t need to activate it manually in case you wish to run PHP scripts that need it. All it takes to run such a script is to set up a new database and to begin the installation process – as soon as the installer wizard accesses the database in question and starts inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to activate scripts that need the other popular MySQL engine, MyISAM, so you won’t have to change any settings on the dedicated server. This will allow you to install different scripts on a single machine and to use the latter to its full capacity.