InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster database failure recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by a lot of web developers that build highly scalable apps, due to the fact that it works much more effectively with large amounts of data, while it keeps the server load low. Also, it locks only a single row in the database if anything should be modified, while lots of other engines lock the entire database table and thus require much more time to fulfill several consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest editions of Joomla are two instances of popular open-source script-powered web apps which have switched over to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosts, it’s an integral part of the standard set of features that we are offering with our shared website hosting packages. If you’d like to use a script-powered web app that needs InnoDB particularly, in order to be activated and to operate correctly, you will not come across any problems because the InnoDB database storage engine is available on our custom-developed cloud platform. No matter if you set up a brand new MySQL database and activate an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app needs it rather than MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also make regular database backups, so that we can easily restore any database in your shared website hosting account.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you’ll be able to select any of the 3 Control Panels that we are offering – Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to install this database storage engine manually in order to be able to use PHP script-driven software apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require to manage very large websites, it’s rather likely that you’ll use InnoDB. You will be able to make use of other engines too, so in case a specific application needs MyISAM instead of InnoDB, you will not run into any impediment while managing it. The engine that will be used will be recognized automatically the moment the app installation commences, so you will not have to tweak any setting manually whatsoever.