InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by many programmers that write scalable web applications, because it works much more effectively with immense data volumes, while it keeps the server load at a minimum. Additionally, it locks only one database row if any information should be edited, while many other engines lock the entire database table and hence require much more time to complete several consecutive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for some reason, the action is rolled back to prevent scrambling or data loss. Magento and the newest Joomla versions are two instances of widely used script-driven web apps that have switched to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosts, it is an integral part of the default set of services that we are offering with our cloud hosting plans. If you’d like to use a PHP script-driven web app that needs InnoDB specifically, in order to be activated and to work properly, you won’t come across any obstacles as the InnoDB storage engine is available on our in-house built cloud hosting platform. No matter if you set up a brand-new database and install an application manually or make use of our 1-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given app requires InnoDB rather than MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also perform daily database backups, so we can quickly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our Linux semi-dedicated service by default, so the moment you get a new semi-dedicated account, you can move on and install any script-driven web application that needs this particular MySQL database storage engine. Several engines are pre-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 use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected depending on the respective app’s requirements. This will allow you to install and manage InnoDB-specific apps without any problems and without editing any settings in your semi-dedicated account. To be on the safe side, we’ll always have a seven-day-old backup of all your MySQL databases, so if you delete or edit any content accidentally, we can swiftly recover it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to use any script-based app that needs this MySQL database storage engine without the need to set up anything manually. You can pick Hepsia on the VPS order form and your brand new VPS server will be up and running within 1 hour, so you can log in and begin creating your web sites right away. When you set up a brand new MySQL database and start the app installation process, our system will select the engine for that MySQL database automatically. Thus, you can activate various applications at the same time without having to edit anything on the Virtual Private Server. You can set up a WordPress personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven web shop that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

All Linux dedicated service that are ordered with our custom-built Hepsia Control Panel include a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t need to activate it manually in case you wish to activate open-source PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to initiate the installation – as soon as the script configuration wizard gains access to the database and starts entering content into 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 will also be able to install scripts that need the other popular MySQL engine – MyISAM, so you will not need to edit any settings on the server. This will permit you to activate a variety of scripts on a single physical machine and to use it to its maximum potential.