InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database failure recovery in comparison with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by many devs that build highly scalable software applications, because it works much better with enormous amounts of data, while it keeps the server load at a minimum. Also, it locks only a single database row in case any info should be updated, while lots of other engines lock the entire database table and therefore require more time to execute multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for any reason, the action is rolled back to prevent scrambling or losing data. Magento and the latest Joomla editions are two instances of popular open-source script-powered software apps which have switched over to InnoDB.

InnoDB in Cloud Website Hosting

You’ll be able to activate any PHP-based web application that needs InnoDB in case you’ve got a cloud website hosting plan with us, as the MySQL database storage engine is available on our cutting-edge cloud web hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is required. You can run apps which require the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be selected automatically, so you won’t need to edit any setting manually at any time. In addition, we’ll also make daily backups of all the databases that you’ve got in the account, so if you erase or overwrite anything, we can swiftly restore it the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you would like to activate open-source scripts that need it. All it takes to use such a script is to create a new database and to initiate the setup process – as soon as the script configuration wizard gets access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that require the other very popular MySQL engine – MyISAM, so you will not need to change any settings on the dedicated server. This will enable you to run a variety of scripts on one single server and to use it to its full potential.