InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved database failure recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of web developers that write highly scalable web apps, as it works much more effectively with large amounts of data, while it keeps the server load low. Also, it locks only a single database row in case anything should be edited, whereas many other engines lock the entire table and thus require more time to perform several sequential tasks. Last, but not least, InnoDB complies with 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 scrambling or data loss. Magento and the newest Joomla versions are two instances of widely used PHP script-driven software platforms which have moved to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it is an essential part of the standard set of services that we are offering with our cloud hosting packages. If you would like to make use of a PHP script-powered app that needs InnoDB in particular, in order to be activated and to work properly, you won’t come across any obstacles because the MySQL storage engine is available on our in-house built cloud website hosting platform. Regardless of whether you create a brand new database and activate an app manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs InnoDB instead of MyISAM. Besides the remarkable database crash recovery that InnoDB offers, we also perform daily database backups, so that we can easily recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can install an open-source script-driven web app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud web hosting platform where the database storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer. In either case, the needed engine will be picked automatically once the app’s activation starts, so you won’t have to update anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. Also, we will always be able to restore any of your MySQL databases if you delete one by mistake, as we create a few database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS

All Linux VPS that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to use any PHP-based application that requires the database engine without needing to activate anything manually. You can select Hepsia on the VPS order page and your brand new server will be up and running within one hour, so you can log in and begin building your websites right away. When you set up a new database and begin the app activation process, our system will set the engine for this database automatically. In this way, you can manage different apps at the same time without having to modify anything on the VPS server. You can set up a WordPress-driven personal journal that uses the default MySQL engine – MyISAM, and a Magento-powered e-shop that uses InnoDB, for instance.