InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a better overall performance and an improved database failure recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by a lot of developers that write scalable applications, as it works more effectively with immense amounts of data, while it keeps the server processing load at a minimum. What’s more, it locks only a single database row if any info should be modified, whereas many other engines lock the entire database table and therefore need more time to handle several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla releases are two examples of widely used PHP-driven applications which have shifted over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting providers, it is an integral part of the standard set of services that we offer with our shared hosting packages. If you’d like to use a PHP-driven software app that requires InnoDB particularly, in order to be activated and to work properly, you won’t have any impediments as the storage engine is available on our custom-developed cloud website hosting platform. No matter if you create a brand-new database and activate an application manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the application needs InnoDB rather than MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also keep daily backups of all databases, so we can quickly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-based software app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud web hosting platform where the storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click application installer. Either way, the needed engine will be selected automatically once the app’s activation starts, so you will not need to configure anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases in case you accidentally delete one, as we carry out a few database backups every day, each of which is preserved for seven days.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia Control Panel is selected during the signup process for your new Linux virtual private servers , InnoDB will be installed on the server along with other essential pieces of software, so you will not have to do anything if you choose to activate open-source script-driven web applications that need this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a brand-new MySQL database and begin installing the app manually or through our one-click installer. The system will recognize the engine that the particular application requires and will set it for the specific MySQL database, so the installation process will continue impeccably and the application can import its content into that database. Therefore, you can activate applications with various prerequisites about the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers Hosting

InnoDB is available as standard with all Linux dedicated servers hosting ordered with the Hepsia Control Panel. It’s included in the default software package that will be installed on all Hepsia-equipped servers, so once your physical machine is ready, you’ll be able to log in and to activate any kind of PHP-based web app that needs this storage engine. If you create a new database through the Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app setup wizard starts dumping data in the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can run both InnoDB and MyISAM without the need to select either of them explicitly at any time. In this way, you can make use of a vast selection of apps for your Internet sites.