InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a much better overall performance and an improved database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of devs that build scalable apps, since it works much better with immense data volumes, while it keeps the server processing load low. Furthermore, it locks only one database row in case anything should be updated, while lots of other engines lock the entire table and hence need much more time to handle multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest Joomla releases are two instances of famous PHP-driven applications that have shifted over to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting providers, it is included in the standard set of services offered with our shared website hosting plans. If you’d like to make use of a script-driven app that requires InnoDB particularly, in order to be activated and to function correctly, you will not come across any obstacles since the database storage engine is available on our in-house built cloud website hosting platform. Irrespective of whether you create a brand-new database and activate an application manually or make use of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the app needs InnoDB instead of MyISAM. In addition to the exceptional database crash recovery offered by InnoDB, we also carry out regular backups of all databases, so that we can easily recover any database in your shared account.

InnoDB in Semi-dedicated Servers

You can run an open-source script-powered software application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our advanced cloud platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click app installer tool. Either way, the needed engine will be picked automatically once the app’s installation starts, so you won’t have to update anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to restore any of your MySQL databases if you delete one by accident, as we create a few backups every day, each of which is stored for one week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to make use of any script-powered application that needs the storage engine without having to install anything manually. You can pick Hepsia on the VPS configuration page and your brand-new Virtual Private Server will be ready within 1 hour, so you can log in and begin setting up your websites straight away. When you set up a new database and start the app installation process, our system will pick the engine for that database automatically. Thus, you can activate different apps simultaneously without the need to configure anything on the server. You can have a WordPress-based personal blog that uses MyISAM – the default MySQL engine, and a Magento online store that makes use of the InnoDB engine, for example.