InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and an improved crash recovery in comparison to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by plenty of devs that run highly scalable software apps, because it works more efficiently with large data volumes, while it keeps the server load at a minimum. In addition, it uses row-level locking in case any information should be modified, while many other engines lock the entire database table and thus require much more time to process multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla™ editions are two examples of popular open-source script-driven software apps that have moved to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many hosting providers, it’s part of the standard set of features that we are offering with our shared hosting packages. If you’d like to use a PHP script-based software app that needs InnoDB specifically, in order to be installed and to work properly, you will not have any obstacles as the MySQL storage engine is available on our in-house built cloud website hosting platform. No matter if you create a new database and install an app manually or make use of our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app requires InnoDB instead of MyISAM. Besides the incredible crash recovery that InnoDB is offering, we also keep regular database backups, so we can easily recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the Control Panel offered with all our semi-dedicated server packages and you start installing a script-powered web application either manually or using our one-click application installer tool, the storage engine for the database will be selected automatically depending on the requirements of the given app. As InnoDB is present on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for any app that needs it without any manual intervention needed on your end at any time. To avoid any risk of losing information if you update an application or if you erase a database by mistake, we’ll make backups of all your MySQL databases every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the standard software package that will be pre-installed on your VPS server before we give it to you. You will not need to configure anything manually and you will be able to install and manage any PHP-based web app that needs InnoDB when your VPS server is ready, which takes no more than sixty minutes after the order submission process itself. Several engines are available, so whenever you set up a MySQL database via the Hepsia hosting Control Panel, a particular engine will be selected when the app installation commences and our system will recognize the engine that is required by the application in question. In case you need to use MyISAM, for example, you won’t have to do anything different from installing the application of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

InnoDB comes by default with all Linux dedicated web hosting plans ordered with the Hepsia Control Panel. It is an essential part of the default software package that will be installed on all Hepsia-equipped servers, so once your machine is ready, you’ll be able to log in and to install a various PHP script-driven web app that needs this particular database engine. If you set up a new database via the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard starts importing content into the newly created database, the engine will be picked automatically in accordance with the given app’s requirements, so you can use both InnoDB and MyISAM without the need to select either of them specifically at any point. Therefore, you can make use of a large collection of apps for your websites.