InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a significantly better overall performance and an improved database failure recovery in comparison to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by a lot of web developers that build scalable software applications, since it works more effectively with immense volumes of data, while it keeps the server processing load low. Furthermore, it locks only one database row in case any info should be edited, while many other engines lock the entire database table and hence need much more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla editions are two instances of popular PHP-based software apps that have shifted over to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with other website hosting service providers, it is an integral part of the default set of services that we are offering with our shared website hosting plans. If you’d like to make use of a PHP script-powered software app that needs InnoDB particularly, in order to be installed and to work correctly, you will not come across any difficulties since the database engine is available on our custom-built cloud Internet hosting platform. No matter if you set up a brand new MySQL database and activate an application manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific application needs it rather than MyISAM. Besides the excellent crash recovery offered by InnoDB, we also keep daily database backups, so we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can make use of a PHP script-powered application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are created on our advanced cloud web hosting platform where the MySQL storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our single-click app installer tool. In either case, the needed engine will be chosen automatically the moment the activation of the application starts, so you will not have to configure anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your databases if you erase one by accident, as we carry out a couple of backups every day, each of which is kept for one week.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia hosting Control Panel include a software package that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually if you want to use open-source PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to begin the installation – as soon as the installation wizard gets access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you will not have to change any settings on the server. This will allow you to run different scripts on a single physical server and to use it to its fullest capabilities.