InnoDB
Become aware of what a database engine is, what are the advantages of the InnoDB engine and why it is gaining that much worldwide popularity.
InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has a lot of pluses that make it the engine of choice for a lot of open-source script-driven applications, among them Joomla™ and Magento, which have switched to InnoDB for good. For instance, adding large volumes of data will be much faster with InnoDB, due to the fact that it locks only one row to carry out a particular operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is handled. Put simply, adding new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if a given problem occurs in the meantime, so the content that remains in the database won’t be lost.
InnoDB in Cloud Web Hosting
You’ll be able to make use of any PHP script-based web application that needs InnoDB if you have a cloud web hosting with us, as the storage engine is present on our innovative cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is required. You can install applications that require the MyISAM engine without having to deal with any problem as well and, once again, the engine will be pre-selected, so you will not have to modify anything manually at any point. What’s more, we’ll also generate regular backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.