InnoDB is a database engine for MySQL relational databases, which is used by popular script-based software applications such as Magento and Joomla v3. It’s perfect for scalable applications, as it works stunningly well when managing enormous volumes of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same length of time. Besides, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that define how data imports and updates should be treated. If a certain operation has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and will not be partially merged with newly entered content.

InnoDB in Shared Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosts, it’s an essential part of the standard set of features that we offer with our shared web hosting plans. In case you want to make use of a PHP-powered web application that needs InnoDB in particular, in order to be activated and to operate correctly, you won’t have any difficulties because the database storage engine is available on our in-house built cloud web hosting platform. No matter if you create a brand-new database and activate an application manually or make use of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective app requires it instead of MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also store daily backups of all databases, so that we can swiftly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel included with all our semi-dedicated server packages and you start installing a PHP script-driven software application either manually or using our single-click application installer, the storage engine for the database will be picked automatically on the basis of the prerequisites of the given application. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any point. To avoid any risk of losing data if you update an application or if you remove a database by accident, we will perform a backup of all your MySQL databases each and every day, so if anything happens, we can rescue your content.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is chosen during the signup process for a new VPS web hosting plans , InnoDB will be installed on the VPS server together with other essential software, so you will not have to do anything if you choose to run PHP script-powered web apps that need this MySQL database 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 app manually or using our one-click installer tool. The system will automatically recognize which engine the particular application needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can dump its data in that database. Thus, you can make use of apps with different prerequisites in regard to the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It’s included in the software package that will be pre-installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is assembled, you’ll be able to sign in and to install any kind of open-source script-powered web application that requires this particular database engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you begin installing an application. Once the app setup wizard starts dumping data in the database, the engine will be selected automatically in accordance with the prerequisites of the app in question, so you can run both MyISAM and InnoDB without having to select either of them explicitly at any point. Thus, you can make use of an immense collection of apps for your sites.