InnoDB is a database storage engine for MySQL relational databases, which is used by widespread open-source script-based software applications like Joomla v3 and Magento. It is perfect for scalable applications, because it performs stunningly well when managing huge 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 row, so it can perform a lot more tasks for the same period of time. Besides, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. If a certain task has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and will not be partially merged with newly appended content.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting providers, it’s included in the standard set of features that we offer with our shared web hosting packages. If you wish to make use of an open-source script-powered app that requires InnoDB particularly, in order to be installed and to function correctly, you will not have any obstacles as the MySQL database storage engine is available on our custom-developed cloud web hosting platform. No matter if you set up a brand-new MySQL database and install an application manually or use our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the given app requires it instead of MyISAM. In addition to the remarkable crash recovery offered by InnoDB, we also perform daily backups of all databases, so that we can easily recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you start installing a PHP script-driven software application either manually or using our 1-click app installer, the storage engine for the MySQL database will be picked automatically depending on the requirements of the particular application. As InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting 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 moment. To avoid any risk of losing information if you update an application or if you erase a database by accident, we will carry out backups of all your databases each day, so if anything goes wrong, we can retrieve your content.

InnoDB in VPS Web Hosting

In case our custom-built Hepsia hosting Control Panel is selected during the registration process for your new Linux virtual private servers , InnoDB will be installed on the Virtual Private Server along with other required pieces of software, so you won’t have to do anything if you choose to use PHP script-driven web applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new database and begin the app installation manually or through our one-click installation tool. The system will detect which engine the application in question needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the application can insert its content into that database. Thus, you can make use of applications with different prerequisites about the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is among the options that you can select on the server configuration page when you buy a dedicated server from us. As this is the most powerful kind of web hosting, it is very likely that you will manage very popular Internet sites that will attract plenty of visitors, and since InnoDB is one of the very best options for such Internet sites, we’ll activate it together with all the other software applications that are offered with a Hepsia-equipped server. When you set up a new MySQL database in your dedicated account, there won’t be any activated MySQL storage engine till you begin installing an open-source script, whether manually through your Internet browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The needed engine will be detected and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having to deal with any obstacle.