InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP script-powered software apps like Joomla™ 3 and Magento. It’s ideal for scalable apps, because it works incredibly well when handling large data volumes. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can perform much more tasks for the same length of time. What’s more, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and updates should be handled. If a specific task has not been entirely completed for some reason, the action will be rolled back. In this way, the database content will remain safe and sound and won’t be partially merged with newly appended content.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it’s an essential part of the standard set of services that we’re offering with our shared hosting packages. In case you want to make use of a script-based web app that requires InnoDB in particular, in order to be installed and to function correctly, you will not have any problems since the MySQL database storage engine is available on our custom-developed cloud hosting platform. Regardless of whether you create a new database and activate an application manually or use our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app requires InnoDB rather than MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also perform regular backups of all databases, so that we can easily recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel coming with all our semi-dedicated server packages and you begin installing a PHP script-powered application either manually or using our 1-click app installer tool, the database storage engine will be picked automatically based on the prerequisites of the specific application. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any time. To avoid any chance of losing data if you update an app or if you erase a database by accident, we’ll make backups of all your databases each day, so if something goes wrong, we can rescue your content.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any open-source script-driven software app that requires this particular database engine without needing to activate anything manually. You can pick Hepsia on the VPS order page and your brand-new VPS server will be ready within sixty minutes, so you can log in and begin setting up your web sites straight away. When you create a brand new database and start the app activation process, our system will set the engine for that database automatically. In this way, you can install different apps at the same time without updating anything on the server. You can create a WordPress-powered personal weblog that uses the default MySQL engine – MyISAM, and a Magento e-commerce portal that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually in case you would like to run scripts that need it. All it takes to install such a script is to set up a new database and to initiate the installation – as soon as the script installation wizard gets access to the database and starts entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to run scripts that require MyISAM – the other very popular MySQL engine, so you won’t have to update any settings on the server. This will permit you to install a variety of scripts on a single physical server and to use it to its fullest potential.