InnoDB
What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a database engine for MySQL relational databases, which is used by widespread open-source script-based software applications such as Magento and Joomla™ 3. It is perfect for scalable apps, as it performs amazingly well when handling huge amounts of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same length of time. Furthermore, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be handled. In case a certain task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially merged with newly appended content.
InnoDB in Cloud Hosting
InnoDB is offered with all our cloud plans by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any script-based web app which requires the InnoDB database engine without encountering any obstacle once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our 1-click installation tool or create the database and set up the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll keep daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data if you delete a database unintentionally or you overwrite some essential info – you simply have to notify us and we’ll restore your content the way it was.