InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved crash recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by many programmers that run scalable apps, as it works better with large volumes of data, while it keeps the server load low. Additionally, it uses row-level locking in case any info should be updated, whereas lots of other engines lock the entire database table and therefore require much more time to perform multiple consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest editions of Joomla are two instances of widespread PHP-driven software platforms that 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 hosting companies, it is part of the standard set of services that we’re offering with our shared hosting plans. If you want to use an open-source script-based application that requires InnoDB specifically, in order to be installed and to function correctly, you won’t encounter any obstacles since the InnoDB database storage engine is available on our in-house developed cloud hosting platform. Regardless of whether you set up a new database and install an app manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also carry out regular backups of all databases, so that we can quickly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can run a script-driven application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our avant-garde cloud web hosting platform where the MySQL database storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click app installer tool. In either case, the required engine will be picked automatically the moment the application’s activation starts, so you won’t need to modify anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to recover any of your databases if you erase one by accident, as we perform a few MySQL database backups every day, each of which is stored for 7 days.

InnoDB in VPS

If you pick a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the default software pack that will be 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 enable and use any PHP script-driven software app that needs InnoDB as soon as your VPS server is set up, which takes no more than one hour after the order submission process itself. A few engines are offered, so whenever you set up a MySQL database via the Hepsia Control Panel, a specific engine will be selected when the app installation process begins and our system will detect which engine is required by the application in question. In case you need MyISAM, for instance, you won’t need to do anything different than installing the application of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Hosting

When you order a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to enable this storage engine manually so as to be able to use open-source script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require to run large-scale sites, it’s pretty likely that you’ll resort to InnoDB. You will be able to use other engines too, so in case a particular app requires MyISAM rather than InnoDB, you won’t run into any difficulty while managing it. The engine that will be used will be automatically recognized when the app installation process commences, so you won’t need to configure any settings manually at any point.