InnoDB is a storage engine for MySQL databases, which is used by widely used open-source script-based software applications such as Magento and Joomla 3.x. It is perfect for scalable applications, because it works very well when processing large data volumes. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same length of time. What’s more, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and updates should be handled. If a specific task has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be kept intact and won’t be partially mixed with newly appended content.

InnoDB in Cloud Hosting

Any PHP-driven application that requires InnoDB will run impeccably on our cutting-edge cloud website hosting platform and the MySQL database storage engine comes with all our cloud hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s requirements without the need to configure any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full potential. We will carry out daily content backups, so in case you unintentionally remove a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore your database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the Control Panel included with each of our semi-dedicated server plans and you start installing a PHP-powered software app either manually or using our single-click app installer, the MySQL database storage engine will be set automatically on the basis of the requirements of the app in question. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that requires it without any manual intervention needed on your end at any point. To prevent any risk of losing info if you update an app or if you erase a database by accident, we’ll make a backup of all your MySQL databases each and every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any PHP-powered web app that needs the database engine without the need to install anything manually. You can select Hepsia on the VPS order page and your new server will be ready within one hour, so you can sign in and start setting up your sites right away. Once you set up a brand new MySQL database and begin the app activation process, our system will select the engine for this database automatically. Thus, you can make use of different applications simultaneously without having to update anything on the Virtual Private Server. You can have a WordPress-based personal journal that uses MyISAM – the default MySQL engine, and a Magento-powered e-store that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB database engine, so you will not have to add it manually in case you would like to run PHP scripts that need it. All it takes to activate such a script is to create a new database and to start the setup – once the script setup wizard obtains access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you will not need to modify any settings on the dedicated server. This will permit you to activate various scripts on one single physical server and to use it to its maximum capabilities.