InnoDB is a database storage engine for MySQL databases, which is used by popular PHP script-based web applications such as Joomla™ 3 and Magento. It is perfect for scalable applications, as it works exceptionally well when handling large data volumes. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same length of time. Besides, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that indicate how data imports and updates should be handled. In case a certain operation has not been entirely completed for any reason, the action will be rolled back. Thus, the database content will be retained safe and sound and will not be partially merged with newly imported content.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any open-source script-powered web application that needs the InnoDB storage engine without any difficulties as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app activation, regardless of whether you take advantage of our one-click installation tool or create the database and install the app manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll store daily database backups, so you can be sure that you’ll never lose any content if you erase a database by accident or you overwrite some vital information – you will just need to get in touch with us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting include InnoDB and you’ll be able to take full advantage of all the options offered by this MySQL database engine with any script-driven software application that needs it. InnoDB is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the requirements of the respective app. You won’t need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we’ll perform daily MySQL database backups, so if something goes wrong after some update or if you erase some content by accident, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS

In case our in-house developed Hepsia Control Panel is chosen during the registration process for your new Linux virtual private servers , InnoDB will be activated on the VPS server along with other needed pieces of software, so you won’t have to do anything if you choose to activate open-source script-driven software apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand-new database and begin the app installation procedure manually or through our 1-click installer. The system will automatically detect which engine the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can dump its content in that database. In this way, you can make use of applications with different prerequisites with regard to the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Hosting

If you order a new dedicated server, you’ll be able to choose any of the 3 Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to install this database storage engine manually to be able to run PHP-powered web apps that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you require in order to run very large Internet sites, it’s very possible that you will use InnoDB. You will be able to use other engines as well, so if a given application requires MyISAM rather than InnoDB, you won’t experience any difficulty while using it. The engine that will be used will be automatically detected as soon as the app installation procedure starts, so you won’t need to tweak any setting manually at any time.