InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has a lot of strengths that have made it the engine of choice for many PHP-driven apps, among them Magento and Joomla™, which have moved to InnoDB for good. For instance, importing immense volumes of data will be much faster with InnoDB, as it locks only a single database row to accomplish an operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, importing new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if some problem appears in the meantime, thus the content that remains in the database will not be damaged.
InnoDB in Cloud Hosting
You can use any PHP script-based web application that needs InnoDB if you’ve got a Linux cloud package with us, as the MySQL database storage engine is present on our avant-garde cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate apps which need the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you won’t need to modify any setting manually at any time. Furthermore, we will also make daily backups of all the MySQL databases that you’ve got in your account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the previous 7 days.