InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and an improved database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by numerous programmers that create scalable apps, as it works much better with enormous data volumes, while it keeps the server load low. Also, it locks only one database row if anything should be edited, whereas many other engines lock the entire database table and therefore need more time to handle several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest editions of Joomla are two examples of popular PHP-powered software applications that have moved to InnoDB.

InnoDB in Cloud Web Hosting

InnoDB is available with all our cloud web hosting by default, not as a paid upgrade or upon request, so you can activate and manage any PHP-powered web application which needs the MySQL storage engine without having to deal with any difficulty once you order your shared hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, regardless of whether you make use of our one-click installer or create the MySQL database and install the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you won’t ever lose any content if you delete a database by accident or you overwrite some important information – you’ll simply have to touch base with us and we will restore the database back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans support InnoDB and you will be able to take advantage of all the features offered by this database storage engine with any PHP script-powered software app that needs it. It is one of the engines that are available on our cloud platform, so the one that will be selected depends on the particular app’s prerequisites. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we’ll carry out daily database backups, so if anything goes wrong after an upgrade or if you erase some content accidentally, we will be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is picked during the signup process for a new VPS hosting plans , InnoDB will be installed on the Virtual Private Server along with other essential software, so you won’t need to do anything if you decide to manage open-source script-driven apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand new MySQL database and begin installing the app manually or using our single-click installation tool. The system will detect the engine that the app in question needs and will assign it to the specific database, so the installation process will proceed impeccably and the application can insert its content into that database. Thus, you can install applications with different prerequisites about the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you will be able to pick any of the three hosting Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to enable this MySQL storage engine manually so as to be able to run PHP script-driven software applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need to run large-size websites, it’s pretty likely that you’ll use InnoDB. You will be able to make use of other engines too, so if a particular app requires MyISAM instead of InnoDB, you won’t have to deal with any difficulty while managing it. The engine that will be used will be detected automatically once the app installation process begins, so you won’t need to alter any settings manually at any point.