InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has many advantages which have made it the engine of choice for many PHP-driven software applications, among them Magento and Joomla, which have moved to InnoDB permanently. For instance, adding large amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to carry out a specific task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is treated. Put simply, importing new or modifying existent data will either be fully completed, or will be annulled and the procedure will be rolled back if some problem shows up in the meantime, which is why the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting providers, it is an integral part of the default set of features that we offer with our cloud hosting plans. If you would like to make use of a PHP script-driven software application that needs InnoDB specifically, in order to be installed and to function correctly, you will not have to deal with any obstacles since the MySQL database storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you set up a brand new database and install an app manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app needs InnoDB instead of MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also keep daily backups of all databases, so we can easily recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated service by default, so once you get a new semi-dedicated account, you can move on and activate any script-driven web app that needs the database engine. A few engines are installed on our cloud website hosting platform, so when you create a brand new database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected on the basis of the requirements of the specific app. This will permit you to activate and run InnoDB-specific applications without having any complication and without updating any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your MySQL databases, so if you erase or edit any content by mistake, we can quickly recover it.

InnoDB in VPS Servers

All VPS service that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to make use of any open-source script-based web app that requires the MySQL database engine without the need to activate anything manually. You can select Hepsia on the VPS order page and your brand-new VPS server will be set up within the hour, so you can log in and begin creating your sites right away. Once you set up a brand-new MySQL database and start the app activation process, our system will select the engine for that MySQL database automatically. Thus, you can manage different apps simultaneously without the need to update anything on the server. You can have a WordPress-based personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven online store that uses InnoDB, for instance.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to enable this storage engine manually so as to be able to use open-source script-driven web applications that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you require in order to manage very large Internet sites, it is rather possible that you will use InnoDB. You will be able to make use of other engines as well, so if a particular application needs MyISAM rather than InnoDB, you will not have any complication while using it. The engine that will be used will be automatically recognized as soon as the app installation begins, so you will not need to tweak any settings manually at any point.