InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based web apps like Joomla 3 and Magento. It’s ideal for scalable apps, as it works exceptionally well when processing enormous data volumes. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that specify how data imports and modifications should be treated. In case a specific operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially mixed with newly added content.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it is part of the standard set of services that we offer with our shared hosting packages. In case you would like to make use of a PHP-based software application that requires InnoDB specifically, in order to be activated and to operate correctly, you will not face any problems as the InnoDB database storage engine is available on our custom-developed cloud web hosting platform. Regardless of whether you create a brand new database and activate an app manually or take advantage of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given app requires it instead of MyISAM. Besides the amazing database crash recovery that InnoDB offers, we also make daily backups of all databases, so that we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-powered application that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our cutting-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. In either case, the required engine will be selected automatically as soon as the app’s installation begins, so you won’t have to modify anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to restore any of your MySQL databases in case you erase one by accident, as we carry out several database backups every day, each of which is stored for one week.

InnoDB in VPS Web Hosting

If our custom Hepsia Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be activated on the VPS server along with other required software, so you will not need to do anything if you decide to manage open-source script-powered applications that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new database and start installing the application manually or using our single-click installation tool. The system will recognize the engine that the app in question needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its data into that database. In this way, you can use applications with various requirements with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

InnoDB is available as standard with all dedicated servers hosting ordered with the Hepsia Control Panel. It is an integral part of the software package that will be installed on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you’ll be able to log in and to activate any open-source script-driven software app that requires this particular MySQL database storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any active engine until you start installing an app. Once the app installation wizard starts dumping information in the newly created database, the engine will be set automatically on the basis of the requirements of the particular app, so you can use both MyISAM and InnoDB without having to select either one explicitly at any moment. Therefore, you can use a wide variety of applications for your websites.