What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-powered web applications such as Joomla™ 3.x and Magento. It’s excellent for scalable apps, since it performs really well when managing enormous volumes of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same period of time. Moreover, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be treated. In case a given task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be kept undamaged and won’t be partially merged with newly inserted content.
InnoDB in Hosting
InnoDB is offered with all our hosting
by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based web application which requires the database engine without having to deal with any difficulty once you open your shared website hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and set up the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular database backups, so you can be certain that you won’t ever lose any data if you delete a database accidentally or you overwrite some crucial info – you just have to notify us and we’ll restore your data the way it was.