InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got a lot of pluses which have made it the preferred engine for many PHP-powered software applications, among them Joomla™ and Magento, which have moved to InnoDB for good. For example, importing large data volumes will be faster with InnoDB, since it locks only a single database row to execute a specific operation, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Put simply, adding new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case a certain problem occurs in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with other hosting companies, it’s an essential part of the default set of features that we’re offering with our shared web hosting plans. If you wish to use a PHP script-powered app that requires InnoDB particularly, in order to be installed and to function correctly, you won’t come across any difficulties because the storage engine is available on our custom-built cloud Internet hosting platform. Irrespective of whether you set up a brand-new MySQL database and activate an application manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires it rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also make regular backups of all databases, so that we can quickly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting services come with InnoDB and you will be able to use all the features offered by this database storage engine with any PHP-powered software app that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the specific application. You won’t have to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our single-click application installer tool. To avoid any risk, we’ll perform daily database backups, so if anything goes wrong after an upgrade or if you remove some data by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Hosting

In case our in-house built Hepsia Control Panel is selected during the registration process for your new Linux virtual private servers , InnoDB will be installed on the VPS server together with other required software, so you will not have to do anything if you decide to make use of PHP-based applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new database and begin the app installation procedure manually or using our 1-click installation tool. The system will recognize which engine the app in question needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can insert its data into that database. In this way, you can manage applications with various requirements in regard to the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Web Hosting

InnoDB is included as standard with all dedicated web hosting that are ordered with the Hepsia hosting Control Panel. It is an essential part of the software package that will be pre-installed on all Hepsia-equipped servers, so as soon as your machine is set up, you will be able to log in and to activate a various PHP-based app that requires this database storage engine. If you create a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. As soon as the app configuration wizard begins entering information into the newly created database, the engine will be selected automatically in accordance with the given app’s requirements, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any moment. Thus, you can use a vast variety of apps for your websites.