InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of programmers that build scalable software applications, since it works more efficiently with large amounts of data, while it keeps the server load low. Also, it locks only a single database row if anything should be modified, whereas many other engines lock the entire table and hence need much more time to carry out several consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the latest Joomla editions are two examples of widespread script-based software apps which have switched over to InnoDB.

InnoDB in Shared Hosting

You can activate any PHP-driven application that needs InnoDB in case you’ve got a shared hosting plan with us, as the MySQL storage engine is available on our advanced cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can run apps that require the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be selected automatically, so you won’t have to update any setting manually at any moment. What’s more, we’ll also create regular backups of all the databases that you’ve got in your shared hosting account, so in case you delete or overwrite something, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can install a PHP-based web application that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer. In either case, the needed engine will be selected automatically the moment the app’s activation begins, so you won’t need to modify anything manually, no matter if the application requires InnoDB or the more regularly used MyISAM. Also, we will always be able to restore any of your MySQL databases in case you erase one by mistake, as we perform a couple of backups every day, each of which is saved for 1 week.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to pick one of the 3 Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to install this MySQL database storage engine manually so as to be able to run script-driven apps that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you need in order to run large-size websites, it’s pretty likely that you will resort to InnoDB. You’ll be able to use other engines too, so in case a certain app needs MyISAM instead of InnoDB, you will not encounter any difficulty while running it. The engine that will be used will be recognized automatically the moment the app installation procedure commences, so you will not need to modify any settings manually at any point.