InnoDB is a database engine for MySQL relational databases, which is used by popular PHP script-based web applications like Joomla v3 and Magento. It is ideal for scalable apps, as it performs astonishingly well when processing huge volumes of data. Instead of locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same period of time. Also, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be treated. If a certain task has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and won’t be partially mixed with newly imported content.

InnoDB in Shared Hosting

Any script-based software application that requires InnoDB will run impeccably on our innovative cloud platform and the database engine is available with all our shared hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected on the basis of the app’s specifications without having to modify any setting in your shared account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We’ll perform regular content backups, so if you unintentionally delete a MySQL database that you need or you overwrite some part of it, we’ll be able to restore the database the way it was just several hours ago.

InnoDB in Semi-dedicated Servers

You can make use of a script-powered web app that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our innovative cloud platform where the MySQL database storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our 1-click application installer. Either way, the required engine will be picked automatically the moment the application’s installation starts, so you won’t need to edit anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases if you erase one by mistake, as we make a couple of backups every day, each of which is preserved for one week.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the registration process for your new VPS hosting plans , InnoDB will be activated on the Virtual Private Server along with other needed software, so you won’t have to do anything if you choose to use PHP script-driven software applications that require this MySQL storage 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 1-click installation tool. The system will automatically recognize which engine the particular application requires and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can insert its content into that database. Therefore, you can run apps with different prerequisites about the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to select one of the three hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to add this database engine manually so as to be able to use PHP-powered web apps that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you require to manage large-size websites, it’s quite likely that you will use InnoDB. You’ll be able to use other engines as well, so in case a certain app needs MyISAM instead of InnoDB, you will not come across any problem while running it. The engine that will be used will be recognized automatically once the app installation starts, so you won’t need to edit any setting manually whatsoever.