InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a better overall performance and an improved database failure recovery compared with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by many programmers that write highly scalable applications, because it works much more efficiently with immense amounts of data, while it keeps the server load at a minimum. Moreover, it locks only a single row in the database if anything should be modified, whereas many other engines lock the entire database table and thus require much more time to execute several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for whatever reason, the action is rolled back to prevent confusion or the loss of data. Magento and the newest versions of Joomla are two examples of famous open-source script-powered software apps that have moved to InnoDB.

InnoDB in Website Hosting

You’ll be able to activate any script-driven application that requires InnoDB if you have a website hosting with our company, as the MySQL storage engine is present on our leading-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run applications which require the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you will not have to update any setting manually at any time. What’s more, we’ll also generate regular backups of all the MySQL databases that you have in your account, so if you erase or overwrite anything, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel included with each of our semi-dedicated server packages and you start installing an open-source script-based application either manually or using our one-click application installer, the storage engine for the MySQL database will be selected automatically on the basis of the given app’s prerequisites. As InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any point. To prevent any chance of losing information if you update an app or if you remove a database by accident, we’ll make backups of all your MySQL databases each and every day, so if anything goes wrong, we can rescue your data.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you will be able to select any of the three hosting Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to install this MySQL database storage engine manually so as to be able to use script-based web apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you need to manage very large websites, it is quite possible that you will use InnoDB. You’ll be able to use other engines as well, so if a specific app needs MyISAM instead of InnoDB, you will not experience any complication while running it. The engine that will be used will be detected automatically as soon as the app installation begins, so you won’t need to edit any settings manually whatsoever.