InnoDB is a database engine for MySQL databases, which is used by widespread open-source script-powered software apps such as Magento and Joomla v3. It is perfect for scalable apps, because it performs astonishingly well when handling large volumes of data. Rather than 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 process much more operations for the same length of time. In addition, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data inserts and modifications should be treated. In case a particular operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain safe and sound and will not be partially merged with new content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it is an integral part of the standard set of services that we’re offering with our cloud hosting plans. In case you want to use a PHP-driven application that needs InnoDB specifically, in order to be installed and to perform properly, you won’t face any impediments as the MySQL database engine is available on our in-house built cloud hosting platform. Regardless of whether you create a brand new MySQL database and activate an application manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs it rather than MyISAM. Besides the amazing database crash recovery offered by InnoDB, we also carry out daily database backups, so we can quickly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can run an open-source script-powered application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our avant-garde cloud platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our one-click application installer. Either way, the required engine will be chosen automatically the moment the activation of the application starts, so you will not have to update anything manually, no matter if the app requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to restore any of your databases in case you accidentally delete one, as we generate a few backups every day, each of which is kept for seven days.

InnoDB in Dedicated Servers Hosting

If you obtain a new dedicated server, you will be able to select any of the 3 Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to enable this storage engine manually in order to be able to run script-powered apps that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you require in order to manage large-size sites, it’s quite likely that you will resort to InnoDB. You’ll be able to use other engines too, so in case a particular application requires MyISAM instead of InnoDB, you will not experience any impediment while managing it. The engine that will be used will be automatically recognized as soon as the app installation procedure starts, so you will not need to change any settings manually at any time.