InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a better overall performance and a faster crash recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by a lot of developers that build scalable web applications, because it works better with enormous amounts of data, while it keeps the server load low. Also, it locks only a single row in the database in case anything should be edited, whereas lots of other engines lock the entire table and thus need more time to handle several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or the loss of data. Magento and the latest Joomla™ versions are two examples of popular script-based software platforms that have switched to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with other hosting service providers, it’s an integral part of the standard set of features that we are offering with our shared hosting plans. If you would like to use a script-driven software app that requires InnoDB in particular, in order to be activated and to function correctly, you won’t come across any obstacles as the MySQL 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 application manually or make use of our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it rather than MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also maintain daily backups of all databases, so we can swiftly recover any database in your shared account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated services come with InnoDB and you’ll be able to take advantage of all the options offered by this MySQL database storage engine with any script-driven software application that needs it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the particular app’s prerequisites. You will not have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To be on the safe side, we’ll carry out daily backups of all your MySQL databases, so if something goes wrong after an upgrade or if you remove some content by accident, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS

All Linux VPS services that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-driven software app that needs this storage engine without setting up anything manually. You can select Hepsia on the VPS configuration page and your brand new server will be ready within 60 minutes, so you can log in and start building your web sites right away. Once you create a brand-new database and start the app activation process, our system will choose the engine for this database automatically. In this way, you can install various apps at the same time without the need to update anything on the VPS server. You can create a WordPress personal journal that uses the default MySQL engine – MyISAM, and a Magento-based e-store that uses the InnoDB engine, for example.

InnoDB in Dedicated Hosting

All dedicated hosting ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually in case you would like to activate scripts that require it. All it takes to install such a script is to set up a new MySQL database and to initiate the installation – once the installer wizard accesses the database and begins inserting data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to use scripts that need the other popular MySQL engine, MyISAM, so you won’t have to modify any settings on the dedicated server. This will permit you to use a variety of scripts on one single machine and to use it to its full capacity.