InnoDB is a database engine for MySQL databases, which is used by famous PHP script-driven software applications like Magento and Joomla 3.x. It’s perfect for scalable applications, because it performs amazingly well when managing huge data volumes. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same period of time. Besides, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – a set of rules that indicate how data inserts and updates should be handled. In case a given task has not been fully completed for some reason, the action will be rolled back. In this way, the content in the database will be retained intact and won’t be partially mixed with newly imported content.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting providers, it is an essential part of the default set of features offered with our web hosting plans. If you’d like to make use of a PHP-powered application that requires InnoDB specifically, in order to be activated and to work correctly, you won’t come across any obstacles as the MySQL database engine is available on our in-house built cloud platform. No matter if you set up a brand new MySQL database and install an app manually or make use of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app needs it instead of MyISAM. In addition to the incredible database crash recovery that InnoDB is offering, we also generate daily database backups, so that we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting come with InnoDB and you can make use of all the features offered by this storage engine with any PHP-powered application that needs it. It’s one of the engines that are available on our cloud hosting platform, so the one that will be selected depends on the particular app’s requirements. You will not have to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click application installer. To avoid any risk, we will store daily backups of all your MySQL databases, so if something goes wrong after an upgrade or if you delete some data accidentally, we’ll be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS

If you choose a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the default software pack that will be pre-installed on your VPS server before we hand it over to you. You will not need to set up anything manually and you’ll be able to install and run any open-source script-based web application that needs InnoDB when your VPS server is ready, which takes no more than sixty minutes after the order submission procedure itself. A number of engines are offered, so anytime you set up a MySQL database using the Hepsia Control Panel, a specific engine will be activated once the app activation commences and our system will automatically recognize the engine that is required by the application in question. In case you need MyISAM, for example, you won’t need to do anything different from installing the app of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our in-house developed Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not need to activate it manually if you would like to activate PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to start the setup – as soon as the script setup wizard obtains access to the database in question and starts inserting content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to install scripts that require the other widely used MySQL engine – MyISAM, so you will not have to configure any settings on the dedicated server. This will allow you to activate different scripts on one single physical server and to use it to its maximum potential.