InnoDB is a popular database engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has a lot of strong sides which make it the engine of choice for plenty of PHP script-powered web applications, among them Magento and Joomla, which have moved to InnoDB permanently. For example, adding large amounts of data will be faster with InnoDB, due to the fact that it locks only one database row to execute a given operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is handled. To put it simply, importing new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back if any problem appears during the process, which is why the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with other website hosting service providers, it is included in the standard set of features that we’re offering with our shared hosting plans. If you would like to make use of a script-driven software application that needs InnoDB particularly, in order to be activated and to operate correctly, you will not have to deal with any impediments as the database engine is available on our custom-built cloud platform. No matter if you set up a brand new MySQL database and activate an app manually or make use of our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the particular application needs it instead of MyISAM. In addition to the excellent database failure recovery offered by InnoDB, we also store regular backups of all databases, so we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated hosting plans by default, so once you buy a new account, you can go on and activate any open-source script-based app that requires the MySQL storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a brand-new database and begin installing an app manually, or opt to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be set on the basis of the requirements of the particular app. This will allow you to activate and manage InnoDB-specific apps without experiencing any complication and without updating any settings in your account. To be on the safe side, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you remove or alter any content by mistake, we can easily restore it.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the default software bundle that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not need to set up anything manually and you’ll be able to enable and use any script-based web app that needs InnoDB as soon as your VPS is up and running, which takes no more than one hour after the order submission procedure itself. A few engines are offered, so every time you set up a database using the Hepsia hosting Control Panel, a particular engine will be picked when the app installation begins and our system will automatically detect the engine that is required by the app in question. If you need to use MyISAM, for instance, you won’t have to do anything different than installing the application of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s an integral part of the default software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is assembled, you’ll be able to log in and to install any kind of PHP-based application that needs this particular MySQL storage engine. When you set up a new database through the hosting Control Panel, there won’t be any activated engine until you begin installing an application. Once the app configuration wizard starts entering content into the newly created database, the engine will be picked automatically on the basis of the specific app’s prerequisites, so you can use both InnoDB and MyISAM without having to select either one of them explicitly at any moment. Thus, you can make use of a broad collection of apps for your websites.