InnoDB is a storage engine for MySQL databases, which is used by well known PHP-powered applications such as Joomla 3 and Magento. It’s ideal for scalable applications, since it performs remarkably well when handling huge volumes of data. Instead of locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute much more tasks for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. In case a particular task has not been fully completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially merged with new content.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting companies, it is an essential part of the standard set of features that we are offering with our web hosting packages. If you’d like to use a PHP-driven application that requires InnoDB particularly, in order to be activated and to function properly, you won’t come across any obstacles since the InnoDB storage engine is available on our custom-built cloud platform. No matter if you create a new database and install an application manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires it rather than MyISAM. In addition to the excellent database crash recovery offered by InnoDB, we also store regular database backups, so that we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans include InnoDB and you’ll be able to make use of all the features of this MySQL database storage engine with any open-source script-based application that needs it. InnoDB is among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the specific application. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we will store daily backups of all your MySQL databases, so if something goes wrong following some update or if you erase some content by mistake, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is selected during the signup process for a new VPS plans , InnoDB will be activated on the server together with other necessary software, so you won’t need to do anything if you decide to activate open-source script-based software apps that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a new database and begin the app installation procedure manually or using our single-click installer. The system will automatically detect the engine that the application in question requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can enter its data into that database. In this way, you can install apps with various requirements about the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to select any of the three hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to install this MySQL database storage engine manually so as to be able to use open-source script-driven software applications that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the resources that you require in order to manage large-size websites, it is very likely that you will use InnoDB. You’ll be able to use other engines as well, so in case a given app requires MyISAM rather than InnoDB, you won’t experience any impediment while managing it. The engine that will be used will be automatically detected the moment the app installation procedure commences, so you won’t have to alter any setting manually at any point.