See what a database engine is, what are the advantages of the InnoDB engine and why it's gaining so much popularity.
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by many programmers that write scalable applications, due to the fact that it works more effectively with enormous data volumes, while it keeps the server load at a minimum. Moreover, it locks only a single row in the database if any information should be modified, whereas lots of other engines lock the entire table and therefore require more time to carry out several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the newest Joomla™ versions are two examples of widely used open-source script-powered apps which have switched to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-driven software application which needs the InnoDB database engine without having to deal with any obstacle once you order your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, irrespective of whether you use our 1-click installer or create the database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll carry out regular MySQL database backups, so you can be sure that you’ll never lose any data if you delete a database unintentionally or you overwrite some crucial information – you will just need to contact us and we will restore your database back to normal.