InnoDB is a database engine for MySQL databases, which is used by widespread PHP script-based web applications such as Magento and Joomla 3. It is ideal for scalable apps, as it performs remarkably well when managing large volumes of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same period of time. Besides, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be treated. In case a certain operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be kept safe and sound and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting providers, it is included in the standard set of features that we are offering with our cloud hosting packages. In case you want to make use of a PHP script-driven application that needs InnoDB particularly, in order to be activated and to function properly, you will not have any difficulties since the InnoDB database storage engine is available on our in-house developed cloud website hosting platform. No matter if you set up a new MySQL database and install an application manually or use our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the application needs it rather than MyISAM. In addition to the excellent crash recovery that InnoDB is offering, we also perform regular database backups, so that we can swiftly recover any database in your shared hosting account.

InnoDB in Dedicated Servers

InnoDB comes as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is part of the default software package that will be installed on all Hepsia-equipped servers, so as soon as your machine is set up, you will be able to log in and to activate any kind of PHP script-powered app that requires this particular database engine. When you set up a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app setup wizard begins entering data into the database, the engine will be chosen automatically on the basis of the given app’s prerequisites, so you can use both InnoDB and MyISAM without selecting either one specifically at any point. In this way, you can make use of a broad selection of apps for your Internet sites.