Read more about InnoDB and find out why it’s recently been selected as the default MySQL database engine.
InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has a lot of strong sides that make it the preferred engine for a lot of open-source script-driven software applications, among them Magento and Joomla™, which have shifted over to InnoDB for good. For example, adding enormous amounts of data will be faster with InnoDB, as it locks only one row to perform a certain operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. Simply put, importing new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a certain issue shows up during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
You can activate any script-powered web application that requires InnoDB if you have a cloud hosting plan with us, as the database engine is present on our cutting-edge cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can install applications which need the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you won’t have to change any setting manually at any time. On top of that, we will also generate daily backups of all the databases that you’ve got in your shared hosting account, so if you delete or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.