See what a database engine is, what exactly are the merits of the InnoDB engine and why it is gaining so much popularity.
InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got lots of advantages which have made it the preferred engine for numerous script-powered apps, among them Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing enormous amounts of data will be much faster with InnoDB, because it locks only one row to execute a specific task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. To put it simply, importing new or editing existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back if a certain problem shows up in the meantime, thus the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
Every open-source script-based software application that requires InnoDB will function impeccably on our avant-garde cloud hosting platform and the database storage engine is available with all our shared hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected on the basis of the app’s prerequisites without having to modify any setting in your account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We will maintain daily backups of your content, so if you unintentionally remove a MySQL database that you need or you overwrite a certain part of it, we will be able to restore everything the way it was only several hours ago.