InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database failure recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by numerous developers that write highly scalable web apps, as it works more efficiently with enormous volumes of data, while it keeps the server load low. What’s more, it uses row-level locking in case any information should be modified, while many other engines lock the entire table and therefore need much more time to complete multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for any reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla editions are two instances of widely used PHP script-based web applications that have moved to InnoDB.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with many other website hosting service providers, it’s an essential part of the standard set of services offered with our cloud web hosting packages. If you would like to make use of a PHP-powered app that requires InnoDB specifically, in order to be installed and to function correctly, you will not have any difficulties as the MySQL storage engine is available on our custom-developed cloud hosting platform. Irrespective of whether you set up a new MySQL database and install an application manually or take advantage of our single-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB instead of MyISAM. Besides the amazing database crash recovery that InnoDB offers, we also perform regular backups of all databases, so we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated service by default, so as soon as you create a new semi-dedicated account, you can move on and install any script-powered web app that requires this particular storage engine. A few engines are installed on our cloud web hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set based on the given app’s requirements. This will permit you to activate and manage InnoDB-specific apps without any problem and without needing to modify any settings in your account. To avoid any risk, we’ll always keep a seven-day-old backup of all your databases, so if you remove or change any content by mistake, we can quickly recover it.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the software bundle that will be installed on your Virtual Private Server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and manage any script-powered software app that needs InnoDB as soon as your VPS is set up, which takes no more than 60 minutes after the order submission procedure itself. A few engines are offered, so anytime you set up a MySQL database via the Hepsia Control Panel, a particular engine will be activated when the app activation commences and our system will automatically detect the engine that is required by the application in question. In case you need MyISAM, for instance, you will not need to do anything different than installing the desired app, whether manually or using our application installer.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated servers ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software package that will be pre-installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is assembled, you’ll be able to log in and to install any open-source script-based web application that needs this particular MySQL database storage engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app configuration wizard starts entering information into the database, the engine will be chosen automatically depending on the requirements of the app in question, so you can use both MyISAM and InnoDB without selecting either one explicitly at any time. In this way, you can use a large variety of applications for your websites.