InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP script-powered applications such as Joomla 3.x and Magento. It is perfect for scalable applications, because it excels in managing immense volumes of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same length of time. Besides, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that indicate how data imports and updates should be handled. In case a particular task has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept undamaged and will not be partially mixed with newly added content.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting service providers, it is an integral part of the default set of services offered with our hosting plans. In case you want to use an open-source script-based app that needs InnoDB in particular, in order to be activated and to function properly, you will not face any obstacles because the MySQL database engine is available on our custom-built cloud platform. Irrespective of whether you create a new MySQL database and activate an application manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular app needs it rather than MyISAM. Besides the outstanding database crash recovery offered by InnoDB, we also make regular backups of all databases, so we can swiftly recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting include InnoDB and you can get the most out of all the features offered by this database storage engine with any script-based app that needs it. It is one of the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the requirements of the respective app. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To be on the safe side, we will keep daily database backups, so if anything goes wrong after some update or if you erase some data by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Hosting

In case our custom-built Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server together with other required software, so you will not need to do anything if you decide to activate open-source script-driven web applications that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin the app installation process manually or using our single-click installer tool. The system will detect which engine the particular app needs and will assign it to the specific database, so the installation process will proceed impeccably and the app can insert its data into that database. Thus, you can make use of apps with different requirements regarding the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Web Hosting

When you purchase a new dedicated server, you’ll be able to select any of the 3 hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database engine manually in order to be able to use script-powered applications that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the system resources that you require in order to manage large-scale sites, it is pretty likely that you’ll resort to InnoDB. You will be able to use other engines too, so if a specific application requires MyISAM instead of InnoDB, you won’t experience any complication while using it. The engine that will be used will be detected automatically once the app installation process begins, so you will not need to tweak any settings manually at any moment.