InnoDB is a database engine for MySQL databases, which is used by widespread PHP script-powered web applications such as Joomla™ 3.x and Magento. It’s perfect for scalable apps, as it works astonishingly well when handling enormous amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same length of time. In addition, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. If a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and won’t be partially merged with newly imported content.