What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by well known PHP-powered web apps such as Joomla™ 3.x and Magento. It is excellent for scalable applications, because it works remarkably well when processing large amounts of data. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Additionally, InnoDB offers a better crash recovery and supports database transactions and foreign keys – a set of rules that specify how data imports and updates should be treated. If a particular operation hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will be preserved intact and won’t be partially mixed with newly entered content.
InnoDB in Website Hosting
InnoDB is available with all our website hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-based web application that requires the MySQL database storage engine without any impediments once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation process, no matter if you make use of our 1-click installer or create the database and activate the app manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We’ll generate regular backups of all your databases, so you can be certain that you’ll never lose any content if you erase a database accidentally or you overwrite some crucial information – you just need to inform us and we’ll restore your content back to normal.