InnoDB is a database storage engine for MySQL databases, which is used by widespread script-powered web applications such as Joomla™ v3 and Magento. It is perfect for scalable apps, because it works amazingly well when managing enormous amounts of data. Rather than locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same period of time. What’s more, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be handled. If a certain task has not been fully completed for some reason, the action will be rolled back. Thus, the content in the database will remain intact and will not be partially mixed with newly entered content.

InnoDB in Hosting

You’ll be able to run any PHP script-based application that needs InnoDB in case you’ve got a Linux hosting with our company, as the database storage engine is available on our advanced cloud web hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can run applications which need the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be selected automatically, so you won’t have to update anything manually at any moment. Furthermore, we will also make regular backups of all the MySQL databases that you have in the account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans include InnoDB and you can make use of all the features of this MySQL database engine with any script-powered software app that needs it. It is among the engines that we have on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the specific app. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we’ll maintain regular backups of all your databases, so if anything goes wrong after an upgrade or if you erase some data by accident, we’ll be able to get the database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

In case our in-house developed Hepsia Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the VPS server along with other required pieces of software, so you won’t have to do anything if you choose to run open-source script-based apps that need this MySQL database engine. The default MySQL engine, MyISAM, will be installed too. You can create a new MySQL database and begin installing the app manually or through our one-click installation tool. The system will recognize which engine the particular application requires and will set it for the specific MySQL database, so the installation process will continue impeccably and the app can enter its content into that database. In this way, you can run applications with various requirements regarding the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you want to activate PHP scripts that need it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup – as soon as the setup wizard accesses the database and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to activate scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will allow you to install different scripts on one single server and to use the latter to its fullest capabilities.