InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has many strengths which have made it the engine of choice for lots of open-source script-based applications, including Magento and Joomla™, which have moved to InnoDB permanently. For instance, importing enormous volumes of data will be faster with InnoDB, because it locks only one row to carry out a particular task, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is handled. Simply put, adding new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a given problem occurs during the process, thus the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it’s an essential part of the default set of features that we offer with our cloud web hosting packages. In case you’d like to make use of a PHP script-driven software application that needs InnoDB specifically, in order to be installed and to function properly, you will not encounter any impediments as the InnoDB database engine is available on our in-house built cloud Internet hosting platform. Regardless of whether you create a brand new MySQL database and activate an app manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires it instead of MyISAM. In addition to the outstanding crash recovery that InnoDB is offering, we also perform regular database backups, so that we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated packages come with InnoDB and you will be able to make use of all the features of this storage engine with any open-source script-powered software app that requires it. It is one of the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the specific application. You will not need to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we’ll perform daily backups of all your MySQL databases, so if something goes wrong following some update or if you delete some content unintentionally, we will be able to restore the database the way it was on any of the past 7 days.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is one of the features that you can choose on the order form when you purchase a dedicated server from us. As this is the most powerful type of website hosting, it’s rather likely that you’ll manage very popular Internet sites that will draw lots of people, and since InnoDB is among the very best options for such Internet sites, we will install it together with all the other software apps that come with a Hepsia-equipped server. If you set up a new MySQL database in your dedicated server account, there won’t be any activated MySQL database storage engine until you start installing a script, whether manually via your web browser or using the automatic scripts installer tool that is included in the Control Panel. The needed engine will be detected automatically and will be set for the database in question, so you can install scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without the need to deal with any difficulty.