What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP-powered software apps such as Magento and Joomla™ 3.x. It is excellent for scalable apps, as it works very well when processing enormous data volumes. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Furthermore, InnoDB offers a better crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. If a certain task has not been entirely completed for some reason, the action will be rolled back. In this way, the database content will be preserved intact and will not be partially merged with newly entered content.
InnoDB in Web Hosting
InnoDB is offered with all our web hosting
by default, not as a paid upgrade or upon request, so you will be able to install and run any open-source script-based software application that requires the InnoDB storage engine without having to deal with any problem once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app installation, regardless of whether you make use of our one-click installation tool or create the MySQL database and set up the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We’ll maintain regular database backups, so you can be sure that you will never lose any content in case you erase a database unintentionally or you overwrite some key info – you’ll just need to touch base with us and we will restore everything the way it was.