InnoDB is a storage engine for MySQL relational databases, which is used by widespread script-based applications like Magento and Joomla 3. It is ideal for scalable apps, because it works unbelievably well when managing huge data volumes. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Furthermore, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – a set of rules that specify how data imports and updates should be handled. If a certain task has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved undamaged and won’t be partially mixed with new content.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many other hosting companies, it’s included in the standard set of services that we offer with our hosting plans. If you wish to make use of a PHP-driven app that requires InnoDB specifically, in order to be installed and to function correctly, you won’t face any impediments because the storage engine is available on our custom cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it instead of MyISAM. In addition to the amazing crash recovery that InnoDB offers, we also perform regular database backups, so that we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so once you purchase a new semi-dedicated account, you can go ahead and activate any script-driven software application that requires this particular MySQL storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a brand new database and start installing an application manually, or decide to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be picked on the basis of the prerequisites of the respective application. This will permit you to activate and run InnoDB-specific applications without needing to deal with any obstacle and without needing to change any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a one-week-old backup of all your databases, so if you delete or edit any content by accident, we can quickly recover it.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is selected during the signup process for your new VPS servers , InnoDB will be installed on the VPS server along with other necessary software, so you won’t need to do anything if you decide to activate script-powered apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new database and start the app installation manually or using our single-click installer tool. The system will automatically detect which engine the application in question requires and will assign it to the specific MySQL database, so the installation will proceed impeccably and the app can enter its data into that database. Therefore, you can run apps with various prerequisites in regard to the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers

When you order a new dedicated server, you will be able to select any of the three hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to enable this storage engine manually to be able to manage script-powered software apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you require to manage large-scale websites, it’s pretty likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a particular app needs MyISAM rather than InnoDB, you won’t come across any difficulty while managing it. The engine that will be used will be automatically recognized the moment the app installation starts, so you won’t need to alter any setting manually at any moment.