InnoDB is a database engine for MySQL databases, which is used by widespread PHP-powered apps like Magento and Joomla 3.x. It’s excellent for scalable apps, as it performs really well when handling huge volumes of data. Rather than 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 handle a lot more tasks for the same period of time. Plus, InnoDB offers a faster database crash recovery and supports transactions and foreign keys – rules that define how data inserts and updates should be treated. In case a certain task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and will not be partially mixed with new content.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting providers, it’s an integral part of the standard set of services that we are offering with our cloud web hosting plans. In case you’d like to make use of a PHP script-powered application that requires InnoDB particularly, in order to be activated and to work properly, you will not come across any problems as the InnoDB storage engine is available on our custom-developed cloud website hosting platform. Irrespective of whether you set up a brand new MySQL database and install an application manually or make use of our 1-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB rather than MyISAM. Besides the incredible database crash recovery offered by InnoDB, we also store regular backups of all databases, so we can swiftly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-based software app that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our leading-edge cloud web hosting platform where the database storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click app installer. In either case, the needed engine will be selected automatically as soon as the installation of the app starts, so you won’t have to configure anything manually, regardless of whether the app requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to recover any of your MySQL databases if you remove one by accident, as we perform a few database backups every day, each of which is kept for one whole week.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you will be able to select one of the 3 hosting Control Panels offered by us – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database engine manually so as to be able to run script-powered software apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you need to run large-scale websites, it is very likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a specific app needs MyISAM rather than InnoDB, you will not need to deal with any impediment while managing it. The engine that will be used will be automatically recognized when the app installation begins, so you will not need to change any settings manually at any point.