InnoDB

InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a better overall performance and an improved database failure recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is used by many devs that create highly scalable web apps, as it works more effectively with enormous volumes of data, while it keeps the server processing load at a minimum. Moreover, it locks only a single database row if any info should be edited, while many other engines lock the entire table and hence require more time to perform several sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest Joomla™ versions are two instances of widespread PHP-based web apps that have moved to InnoDB.