InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a much better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of devs that create scalable web applications, since it works much better with enormous volumes of data, while it keeps the server processing load at a minimum. Also, it locks only one database row if anything should be modified, while many other engines lock the entire table and hence need much more time to process several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest versions of Joomla are two examples of widespread script-powered software apps that have switched over to InnoDB.

InnoDB in Cloud Hosting

Any open-source script-powered software app that requires InnoDB will run impeccably on our avant-garde cloud website hosting platform and the MySQL database storage engine is available with all our cloud hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s specifications without having to configure any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to make the most of its full potential. We’ll perform daily backups of your content, so in case you accidentally delete a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you start installing a PHP-driven application either manually or using our single-click application installer tool, the MySQL database storage engine will be picked automatically on the basis of the prerequisites of the app in question. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any point. To prevent any risk of losing info if you update an application or if you delete a database by mistake, we will perform a backup of all your databases each and every day, so if anything happens, we can recover your content.

InnoDB in Dedicated Servers

When you order a new dedicated server, you’ll be able to select one of the 3 hosting Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to enable this MySQL database storage engine manually so as to be able to manage script-driven software apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require in order to manage large-size websites, it’s pretty possible that you will use InnoDB. You’ll be able to use other engines as well, so in case a specific application requires MyISAM instead of InnoDB, you won’t run into any difficulty while using it. The engine that will be used will be detected automatically when the app installation process commences, so you won’t have to alter any settings manually at any moment.