InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got many upsides that have made it the engine of choice for numerous open-source script-powered web applications, including Magento and Joomla™, which have switched to InnoDB permanently. For instance, importing large volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a given operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem occurs during the process, which means that the content that remains in the database won’t be lost.