InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster crash recovery compared with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many web developers that build scalable web applications, due to the fact that it works better with large data volumes, while it keeps the server load low. In addition, it it locks only one row in the database in case any info should be updated, whereas many other engines lock the entire table and thus need much more time to execute multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest editions of Joomla™ are two examples of famous open-source script-powered software applications which have switched to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosts, it is an essential part of the default set of features offered with our shared hosting plans. If you want to make use of a script-driven software app that needs InnoDB particularly, in order to be installed and to perform correctly, you won’t face any problems because the InnoDB database engine is available on our custom-developed cloud web hosting platform. No matter if you create a new MySQL database and install an app manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific application needs InnoDB rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also store daily database backups, so we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

You can run a PHP-powered web app that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our advanced cloud platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click application installer tool. In either case, the needed engine will be selected automatically the moment the application’s activation starts, so you won’t have to change anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. In addition, we will always be able to restore any of your databases in case you remove one by mistake, as we create a few database backups every day, each of which is saved for 1 week.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the signup process for a new VPS web hosting plans , InnoDB will be activated on the server together with other needed pieces of software, so you will not need to do anything if you decide to make use of PHP-driven apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand new database and start the app installation procedure manually or through our single-click installation tool. The system will recognize which engine the particular application needs and will assign it to the specific MySQL database, so the installation process will continue impeccably and the app can dump its content in that database. Therefore, you can manage applications with different requirements in regard to the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to pick one of the three hosting Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to activate this MySQL database engine manually in order to be able to use script-based applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you require in order to run large-scale websites, it’s rather likely that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a particular application needs MyISAM rather than InnoDB, you will not encounter any impediment while using it. The engine that will be used will be automatically recognized when the app installation process commences, so you won’t have to tweak any settings manually at any moment.