InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-based web applications such as Joomla™ 3 and Magento. It’s ideal for scalable applications, because it works unbelievably well when managing large data volumes. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Furthermore, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be treated. If a certain operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept undamaged and won’t be partially mixed with new content.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting plans by default, not upon request or as a paid upgrade, so you can install and run any PHP script-based web app that needs the InnoDB database engine without any problems once you open your shared account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, regardless of whether you take advantage of our 1-click installation tool or create the database and set up the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll perform regular MySQL database backups, so you can be sure that you won’t ever lose any content if you delete a database by accident or you overwrite some key information – you simply need to notify us and we will restore your database back to normal.

InnoDB in Semi-dedicated Servers

You can install a PHP script-based web application that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our cutting-edge cloud hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our one-click app installer. Either way, the required engine will be picked automatically once the activation of the app begins, so you will not have to update anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to recover any of your databases in case you unintentionally erase one, as we generate a few backups every day, each of which is stored for 7 days.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It is included in the software package that will be installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is assembled, you’ll be able to log in and to activate any type of PHP-driven web application that needs this database engine. If you create a new database via the Control Panel, there won’t be any active engine until you start installing an app. As soon as the app setup wizard begins dumping information in the newly created database, the engine will be chosen automatically in accordance with the requirements of the given app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any moment. In this way, you can use a wide range of apps for your Internet sites.