InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by lots of devs that create highly scalable apps, as it works much better with large volumes of data, while it keeps the server processing load at a minimum. What’s more, it locks only a single row in the database in case any information should be edited, whereas lots of other engines lock the entire table and therefore require more time to fulfill several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla versions are two examples of widespread open-source script-driven software platforms that have moved to InnoDB.

InnoDB in Shared 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 services that we’re offering with our shared website hosting plans. If you’d like to make use of a PHP-powered software application that needs InnoDB specifically, in order to be installed and to work correctly, you won’t have to deal with any difficulties as the MySQL storage engine is available on our custom cloud hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or make use of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB rather than MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also make regular backups of all databases, so we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our Linux semi-dedicated plans by default, so as soon as you purchase a new semi-dedicated account, you can go on and install any PHP-powered application that needs the MySQL database engine. A number of engines are installed on our cloud hosting platform, so when you set up a brand new database and begin installing an application manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the requirements of the respective app. This will allow you to install and manage InnoDB-specific apps without needing to cope with any problem and without having to modify any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a seven-day-old backup of all your databases, so if you remove or alter any content unintentionally, we can quickly recover it.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the registration process for a new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server along with other necessary software, so you won’t need to do anything if you decide to install PHP-based web applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a new database and start installing the application manually or using our single-click installation tool. The system will recognize the engine that the particular app needs and will set it for the specific database, so the installation process will continue flawlessly and the app can import its content into that database. Therefore, you can make use of applications with various requirements in regard to the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options which you can choose on the server configuration page when you purchase a dedicated server from us. As this is the most powerful kind of hosting, it is quite likely that you’ll run very popular websites that will draw lots of visitors, and since InnoDB is among the very best choices for such sites, we will enable it together with all the other software applications that are offered with a Hepsia-equipped dedicated server. If you set up a brand new MySQL database in your dedicated server account, there won’t be any active MySQL storage engine until you begin installing a PHP script, whether manually through your browser or using the automatic script installer tool that is included in the hosting Control Panel. The required engine will be recognized automatically and will be set for that database, so you can use scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without coming across any impediment.