Find what a database engine is, what are the advantages of the InnoDB engine and why it's gaining a huge amount of worldwide popularity.
InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got lots of strong sides which have made it the preferred engine for a lot of script-powered apps, among them Magento and Joomla™, which have moved to InnoDB for good. For instance, adding immense data volumes will be faster with InnoDB, due to the fact that it locks only one database row to carry out a specific operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. In simpler words, importing new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back if some problem shows up in the meantime, which is why the content that remains in the database will not be lost.
InnoDB in Cloud Web Hosting
Any PHP script-driven web application that needs InnoDB will function impeccably on our avant-garde cloud platform and the MySQL storage engine comes with all our cloud web hosting
plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected on the basis of the app’s specifications without the need to edit any setting in your account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will maintain daily content backups, so in case you unintentionally erase a database that is important to you or you overwrite some part of it, we will be able to restore your data the way it was just several hours ago.