InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and an improved database crash recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by lots of devs that write scalable web applications, as it works more efficiently with enormous data volumes, while it keeps the server processing load low. Also, it locks only a single database row if any information should be updated, whereas many other engines lock the entire database table and thus require much more time to execute multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for any reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest Joomla releases are two instances of famous PHP-driven applications which have switched to InnoDB.

InnoDB in Shared Web Hosting

Any PHP script-driven software app that requires InnoDB will function flawlessly on our innovative cloud platform and the storage engine is offered with all our shared web hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s specifications without the need to update any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to make the most of its full capacity. We’ll make daily backups of your content, so in case you accidentally delete a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore everything the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Servers

You can make use of a PHP script-based web app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our advanced cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click app installer. Either way, the required engine will be picked automatically the moment the installation of the app starts, so you won’t need to modify anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you unintentionally delete one, as we perform a few database backups every day, each of which is stored for one whole week.