InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-based software applications such as Joomla 3 and Magento. It is ideal for scalable apps, as it performs stunningly well when managing huge amounts of data. Instead of locking the entire database table to append new information to 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. Plus, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and modifications should be treated. In case a specific task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will be retained undamaged and won’t be partially merged with newly added content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s part of the default set of features offered with our cloud hosting packages. If you would like to make use of a PHP script-powered app that needs InnoDB in particular, in order to be activated and to operate correctly, you won’t have any impediments since the InnoDB database storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you set up a new database and activate an application manually or use our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires InnoDB rather than MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also keep regular backups of all databases, so that we can swiftly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can make use of an open-source script-driven web app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud hosting platform where the MySQL database 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 – in case you use our one-click app installer. Either way, the required engine will be picked automatically once the app’s installation starts, so you won’t need to update anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Also, we’ll always be able to retrieve any of your MySQL databases in case you erase one by mistake, as we make a couple of database backups every day, each of which is kept for 7 days.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be activated on the server together with other necessary software, so you will not need to do anything if you decide to make use of PHP-based software applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can set up a new database and begin the app installation manually or using our 1-click installer. The system will recognize which engine the application in question needs and will assign it to the specific database, so the installation will proceed flawlessly and the application can import its data into that database. In this way, you can run applications with different prerequisites with regard to the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to pick any of the 3 Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to activate this storage engine manually to be able to manage PHP-driven software applications that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need to run large-size sites, it is quite likely that you’ll use InnoDB. You will be able to use other engines as well, so if a certain app needs MyISAM instead of InnoDB, you won’t have to deal with any difficulty while using it. The engine that will be used will be automatically recognized when the app installation starts, so you will not need to tweak any settings manually at any time.