InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery compared to the default engine used by MySQL – MyISAM. InnoDB is used by plenty of developers that build highly scalable software applications, due to the fact that it works much more effectively with immense amounts of data, while it keeps the server load low. In addition, it locks only a single row in the database if anything should be edited, whereas lots of other engines lock the entire database table and hence require more time to handle several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for any reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest releases of Joomla are two examples of famous open-source script-based applications that have moved to InnoDB.

InnoDB in Website Hosting

You can activate any open-source script-driven application that requires InnoDB if you have a website hosting package with us, as the MySQL database engine is present on our advanced cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can run apps which use the MyISAM engine without having to deal with any impediment as well and, again, the engine will be pre-selected, so you will not have to change any setting manually at any time. What’s more, we’ll also carry out daily backups of all the MySQL databases that you have in your shared web hosting account, so if you erase or overwrite anything, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting include InnoDB and you’ll be able to take full advantage of all the features of this MySQL database storage engine with any PHP script-based app that requires it. It is among the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the app in question. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To be on the safe side, we’ll perform daily database backups, so if something goes wrong after an update or if you remove some content by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Hosting

If our in-house built Hepsia Control Panel is picked during the signup process for a new Linux VPS hosting packages , InnoDB will be installed on the server along with other required software, so you will not have to do anything if you decide to activate PHP script-powered software apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand-new MySQL database and begin the app installation process manually or using our one-click installation tool. The system will automatically detect which engine the particular app needs and will assign it to the specific database, so the installation process will continue impeccably and the application can enter its content into that database. Thus, you can use applications with various prerequisites concerning the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Web Hosting

All dedicated web hosting ordered with our custom Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you would like to run open-source PHP scripts that need it. All it takes to install such a script is to create a new database and to start the installation – as soon as the installer wizard gains access to the database in question and starts inserting 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 activate scripts that need the other popular MySQL engine – MyISAM, so you won’t have to configure any settings on the server. This will allow you to run different scripts on a single server and to use it to its full capacity.