InnoDB is a database storage engine for MySQL databases, which is used by famous PHP script-powered software applications such as Joomla v3 and Magento. It’s ideal for scalable applications, as it works remarkably well when managing large amounts of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Besides, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and modifications should be handled. If a particular task has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will be retained intact and will not be partially mixed with newly added content.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP-driven software app which requires the MySQL database engine without having to deal with any difficulty once you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, irrespective of whether you make use of our one-click installation tool or create the database and install the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We’ll maintain regular backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you erase a database by accident or you overwrite some vital information – you just need to contact us and we will restore your data back to normal.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting come with InnoDB and you will be able to make use of all the features of this database storage engine with any script-based web app that requires it. It’s among the engines that are available on our cloud hosting platform, so the one that will be selected depends on the prerequisites of the specific app. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our one-click app installer tool. To be on the safe side, we will create daily database backups, so if anything goes wrong following an update or if you delete some content by accident, we will be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS

If you purchase a virtual private server from our company, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to run any script-based software application which needs InnoDB, as this particular database storage engine is an essential part of the standard software package that will be installed on the VPS server during its creation. When you create a brand-new database via the hosting Control Panel, you will just need to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you won’t need to do anything else in your account. Analogously, if an app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Hosting

InnoDB is included by default with all Linux dedicated hosting ordered with the Hepsia Control Panel. It is an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is ready, you’ll be able to log in and to activate a various PHP script-driven web app that needs this database storage engine. When you set up a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an app. Once the app activation wizard starts importing data into the newly created database, the engine will be picked automatically in accordance with the prerequisites of the respective app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any moment. In this way, you can make use of a broad selection of apps for your sites.