InnoDB is a storage engine for MySQL databases, which is used by widespread open-source script-powered web applications such as Joomla 3 and Magento. It is excellent for scalable apps, because it excels in managing huge data volumes. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same period of time. Furthermore, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be treated. If a certain operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and won’t be partially merged with new content.

InnoDB in Cloud Hosting

InnoDB is available with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any open-source script-based application that needs the InnoDB database engine without any problems once you activate your shared account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, irrespective of whether you take advantage of our 1-click installation tool or create the database and install the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any data if you delete a database by mistake or you overwrite some key information – you just have to notify us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with all our Linux semi-dedicated hosting by default, so the moment you buy a new semi-dedicated account, you can go ahead and activate any PHP script-driven software application that needs this particular database engine. A few engines are pre-installed on our cloud platform, so when you create a brand-new database and start installing an application manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be picked based on the requirements of the particular application. This will permit you to install and run InnoDB-specific applications without needing to deal with any difficulty and without the need to configure any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your databases, so if you remove or change any content by accident, we can swiftly recover it.

InnoDB in Dedicated Hosting

InnoDB comes by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It is included in the software bundle that we install on all Hepsia-managed dedicated servers, so once your machine is set up, you’ll be able to log in and to install a various PHP script-based software application that needs this particular database storage engine. If you create a new database via the Control Panel, there won’t be any activated engine until you start installing an application. Once the app installation wizard begins dumping data in the database, the engine will be set automatically on the basis of the requirements of the specific app, so you can run both MyISAM and InnoDB without having to select either one of them explicitly at any point. Therefore, you can make use of an immense range of apps for your sites.