InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP-driven applications such as Joomla™ 3 and Magento. It is ideal for scalable apps, as it performs incredibly well when processing enormous data volumes. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. Also, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data inserts and modifications should be handled. If a specific task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain intact and will not be partially merged with new content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it is part of the default set of features that we offer with our shared web hosting packages. If you’d like to use a PHP-powered software app that needs InnoDB particularly, in order to be installed and to operate correctly, you will not face any problems since the database engine is available on our custom-built cloud website hosting platform. Irrespective of whether you set up a brand-new database and install an app manually or take advantage of our one-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the particular app needs InnoDB instead of MyISAM. In addition to the incredible database failure recovery offered by InnoDB, we also make regular database backups, so we can quickly restore any MySQL database in your shared hosting account.

InnoDB in Dedicated Hosting

InnoDB comes by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software package that we install on all Hepsia-equipped servers, so once your machine is set up, you will be able to sign in and to install any kind of open-source script-driven web app that needs this particular storage 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 app. Once the app installation wizard starts entering content into the newly created database, the engine will be selected automatically depending on the requirements of the specific app, so you can run both MyISAM and InnoDB without the need to select either one specifically at any time. In this way, you can make use of a large selection of applications for your websites.