InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-driven applications like Magento and Joomla v3. It’s excellent for scalable apps, as it works remarkably well when processing enormous data volumes. Instead of locking the whole table to add new information to a database as many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same period of time. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and updates should be handled. In case a certain operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially mixed with newly added content.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it’s an integral part of the default set of features offered with our shared web hosting packages. In case you would like to use a PHP-powered app that needs InnoDB in particular, in order to be activated and to function properly, you won’t have to deal with any obstacles since the InnoDB database storage engine is available on our custom-built cloud Internet hosting platform. Regardless of whether you create a brand new database and activate an app manually or make use of our 1-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. In addition to the remarkable database crash recovery that InnoDB is offering, we also make daily backups of all databases, so that we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the hosting Control Panel included with all our semi-dedicated server accounts and you start installing a PHP script-based web application either manually or using our one-click app installer, the storage engine for the database will be selected automatically on the basis of the given app’s prerequisites. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without the need for any manual intervention on your end at any point. To prevent any risk of losing information if you update an app or if you delete a database by mistake, we’ll carry out a backup of all your MySQL databases each and every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Web Hosting

All Linux VPS web hosting packages that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any PHP-driven software app that requires this particular MySQL storage engine without the need to set up anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be set up within sixty minutes, so you can sign in and start creating your websites straight away. Once 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 activate different applications at the same time without the need to modify anything on the server. You can set up a WordPress-based personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-commerce site that makes use of InnoDB, for example.

InnoDB in Dedicated Servers Hosting

If you obtain a new dedicated server, you’ll be able to pick any of the three hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to enable this MySQL database engine manually in order to be able to run PHP script-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you require to manage large-size Internet sites, it’s very likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a particular application needs MyISAM rather than InnoDB, you won’t come across any difficulty while running it. The engine that will be used will be automatically detected when the app installation begins, so you will not need to change any setting manually at any point.