InnoDB is a database engine for MySQL relational databases, which is used by well known PHP script-powered web applications like Joomla 3.x and Magento. It’s perfect for scalable applications, as it works amazingly well when managing enormous volumes of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Additionally, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and updates should be treated. In case a particular operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved intact and won’t be partially merged with newly added content.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosts, it’s part of the default set of features that we’re offering with our shared hosting plans. If you wish to use an open-source script-based app that requires InnoDB in particular, in order to be installed and to operate correctly, you won’t face any problems since the database engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you create a new MySQL database and activate an app manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the application requires it instead of MyISAM. In addition to the amazing database crash recovery that InnoDB is offering, we also perform daily database backups, so we can swiftly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you can get the most out of all the features of this storage engine with any PHP script-based web application that needs it. InnoDB is among the engines that are available on our cloud platform, so the one that will be used depends on the prerequisites of the given app. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click application installer. To avoid any risk, we will carry out regular database backups, so if something goes wrong after an update or if you delete some data by accident, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS Servers

If you buy a VPS server from our company, you’ll be able to take advantage of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to manage any script-powered application which needs InnoDB, as this particular MySQL storage engine is included in the software package that will be installed on your Virtual Private Server during its setup. When you create a brand-new MySQL database through the Control Panel, you will just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the app in question requires it, so you won’t need to do anything else in your account. Analogously, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans that are ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t have to add it manually if you need to run open-source scripts that require it. All it takes to run such a script is to set up a new MySQL database and to start the setup process – as soon as the setup wizard receives access to the database and begins inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You’ll also be able to activate scripts that need the other popular MySQL engine, MyISAM, so you will not have to configure any settings on the dedicated server. This will enable you to activate different scripts on a single machine and to use it to its full capabilities.