InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a much better overall performance and an improved database failure recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is used by lots of programmers that build scalable software apps, due to the fact that it works better with enormous amounts of data, while it keeps the server load low. Moreover, it locks only a single row in the database in case any info should be modified, while many other engines lock the entire table and therefore require much more time to complete multiple successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for whatever reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla versions are two examples of widely used open-source script-based apps that have moved to InnoDB.

InnoDB in Website Hosting

You will be able to activate any open-source script-based web app that needs InnoDB if you have a website hosting with our company, as the MySQL database engine is present on our innovative cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can run apps that need the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you will not need to change any setting manually at any time. What’s more, we’ll also perform regular backups of all the databases that you have in the shared web hosting account, so if you delete or overwrite something, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually in case you wish to use scripts that need it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – once the script installation wizard accesses the database in question and starts entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to run scripts that need the other popular MySQL engine, MyISAM, so you will not have to modify any settings on the server. This will enable you to activate different scripts on a single machine and to use the latter to its fullest potential.