InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-powered applications like Joomla™ 3 and Magento. It’s perfect for scalable apps, because it performs remarkably well when handling immense amounts of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that indicate how data imports and modifications should be handled. In case a specific task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will remain undamaged and won’t be partially mixed with newly entered content.
InnoDB in Hosting
You can install any open-source script-driven web application that needs InnoDB if you have a hosting with our company, as the MySQL storage engine is available on our leading-edge cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate applications which need the MyISAM engine without having to deal with any problem as well and, again, the engine will be pre-selected, so you will not need to configure any setting manually at any point. Furthermore, we’ll also perform regular backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the previous seven days.