InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP-based web applications like Magento and Joomla v3. It’s perfect for scalable apps, as it works astonishingly well when managing enormous volumes of data. 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 operations for the same length of time. In addition, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and modifications should be handled. In case a particular operation has not been fully completed for any reason, the action will be rolled back. Thus, the content in the database will be retained intact and will not be partially mixed with newly entered content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting service providers, it’s an essential part of the standard set of services that we offer with our shared web hosting packages. If you want to make use of an open-source script-driven software app that requires InnoDB specifically, in order to be installed and to operate correctly, you won’t have to deal with any impediments because the database engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand new MySQL database and activate an application manually or use our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app requires InnoDB rather than MyISAM. Besides the remarkable database crash recovery that InnoDB offers, we also carry out regular database backups, so that we can easily recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you can make use of all the features offered by this database engine with any script-powered app that requires it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the particular app. You won’t have to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To avoid any risk, we’ll create regular MySQL database backups, so if something goes wrong after an update or if you erase some data accidentally, we’ll be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to make use of any open-source script-powered web app that needs the MySQL database engine without having to activate anything manually. You can select Hepsia on the VPS order page and your new server will be ready within the hour, so you can sign in and start building your web sites right away. Once you create a new MySQL database and start the app activation process, our system will choose the engine for that database automatically. Thus, you can manage various applications simultaneously without the need to configure anything on the Virtual Private Server. You can create a WordPress-powered online blog that uses MyISAM – the default MySQL engine, and a Magento-based shopping portal that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

When you get a new dedicated server, you will be able to select one of the three Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to install this database engine manually to be able to use PHP-powered software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you require to run large-scale websites, it’s pretty possible that you will resort to InnoDB. You will be able to make use of other engines as well, so in case a particular application needs MyISAM instead of InnoDB, you won’t encounter any difficulty while using it. The engine that will be used will be recognized automatically the moment the app installation commences, so you won’t need to edit any setting manually at any point.