InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and an improved database failure recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by a lot of web developers that write highly scalable applications, since it works better with immense volumes of data, while it keeps the server load low. Additionally, it locks only a single database row in case any information should be updated, whereas many other engines lock the entire table and therefore need more time to handle several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest releases of Joomla™ are two instances of famous open-source script-powered applications which have shifted over to InnoDB.

InnoDB in Cloud Web Hosting

You can use any PHP script-based web app that needs InnoDB if you’ve got a cloud web hosting with our company, as the MySQL database engine is available on our leading-edge cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can install apps which need the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be selected automatically, so you will not need to modify anything manually at any time. In addition, we will also create regular backups of all the MySQL databases that you’ve got in your shared hosting account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you can use all the options offered by this MySQL database engine with any PHP-based web application that requires it. It is among the engines that we have on our cloud hosting platform, so the one that will be used depends on the prerequisites of the app in question. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we will maintain daily MySQL database backups, so if something goes wrong following an upgrade or if you delete some data by mistake, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Servers

When you acquire a VPS server from us, you’ll be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will allow you to run any script-powered application that requires InnoDB, as the database engine is an integral part of the software bundle that will be pre-installed on the VPS server during its configuration. When you set up a brand new database using the hosting Control Panel, you simply have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your VPS account. Equivalently, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to add it manually in case you’d like to activate PHP scripts that need it. All it takes to install such a script is to create a new MySQL database and to initiate the installation – as soon as the script setup wizard acquires access to the database in question and begins importing 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 particular script. You will also be able to activate scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to edit any settings on the dedicated server. This will enable you to install various scripts on one single physical server and to use it to its maximum capacity.