InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved database crash recovery compared with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by lots of web developers that write highly scalable web applications, because it works more efficiently with huge amounts of data, while it keeps the server processing load low. What’s more, it uses row-level locking in case any information should be modified, whereas many other engines lock the entire database table and therefore require more time to complete several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the latest Joomla releases are two instances of widely used script-powered software applications which have switched over to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it’s an integral part of the standard set of features that we’re offering with our website hosting plans. In case you would like to make use of a script-based web app that needs InnoDB in particular, in order to be activated and to function properly, you won’t face any difficulties because the MySQL database storage engine is available on our in-house built cloud Internet hosting platform. No matter if you set up a brand new MySQL database and activate an application manually or use our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the app requires InnoDB instead of MyISAM. Besides the exceptional database crash recovery that InnoDB offers, we also perform daily database backups, so that we can easily restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our Linux semi-dedicated servers by default, so the moment you buy a new semi-dedicated account, you can go ahead and activate any PHP script-based application that needs this particular storage engine. A few engines are installed on our cloud website hosting platform, so when you create a brand-new database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be set in accordance with the given app’s requirements. This will permit you to activate and manage InnoDB-specific apps without needing to cope with any impediment and without changing any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a 7-day-old backup of all your MySQL databases, so if you delete or change any content by accident, we can swiftly recover it.

InnoDB in VPS Servers

When you buy a VPS server from our company, you will be able to take advantage of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to activate any open-source script-driven software app which requires InnoDB, as this database engine is part of the software package that will be pre-installed on the Virtual Private Server during its configuration. When you set up a brand new database via the Control Panel, you will simply have to start installing an application – manually or using our app installer. InnoDB will be set as the default engine as long as the app in question needs it, so you won’t have to do anything else in your account. Correspondingly, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features which you can select on the order form when you buy a dedicated server from us. Since this is the most powerful type of website hosting, it is very likely that you will run popular websites that will attract lots of visitors, and since InnoDB is among the very best options for such websites, we’ll activate it along with all the other software applications that are available with a Hepsia-equipped server. When you create a brand-new database in your account, there won’t be any active storage engine till you begin installing an open-source script, whether manually via your Internet browser or using the automatic scripts installer that is included in the Control Panel. The needed engine will be detected and will be set for the database in question, so you can make use of scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without the need to cope with any impediment.