InnoDB is a database storage engine for MySQL databases, which is used by popular script-driven software apps like Joomla 3.x and Magento. It is ideal for scalable applications, as it works remarkably well when handling enormous data volumes. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. What’s more, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. If a given task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the database content will be retained intact and won’t be partially merged with newly appended content.

InnoDB in Web Hosting

InnoDB is available with all our Linux web hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any PHP script-driven web app that requires the InnoDB database storage engine without having to deal with any impediment as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, regardless of whether you take advantage of our 1-click installer or create the MySQL database and install the application manually, provided that the application requires it instead of the more famous MyISAM engine. We will create daily backups of all your MySQL databases, so you can be certain that you will never lose any data if you erase a database by accident or you overwrite some essential info – you simply need to alert us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so as soon as you obtain a new semi-dedicated account, you can move on and activate any PHP script-powered software app that requires the database engine. A couple of engines are installed on our cloud platform, so when you create a brand-new database and start installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the prerequisites of the particular app. This will allow you to install and manage InnoDB-specific apps without encountering any impediment and without having to change any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your MySQL databases, so if you remove or edit any content accidentally, we can quickly recover it.

InnoDB in VPS Web Hosting

In case our custom-built Hepsia Control Panel is picked during the registration process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you won’t have to do anything if you decide to manage PHP-powered apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a brand-new MySQL database and begin installing the application manually or through our 1-click installer tool. The system will detect which engine the application in question needs and will set it for the specific database, so the installation process will continue flawlessly and the app can insert its content into that database. Thus, you can install applications with various prerequisites concerning the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Servers Hosting

When you get a new dedicated server, you’ll be able to pick any of the three Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to enable this storage engine manually so as to be able to run PHP-powered applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need in order to manage large-size sites, it’s quite likely that you will resort to InnoDB. You will be able to make use of other engines as well, so if a certain application requires MyISAM instead of InnoDB, you won’t have any obstacle while running it. The engine that will be used will be recognized automatically the moment the app installation procedure commences, so you will not have to change any setting manually at any point.