InnoDB is a popular database engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got a number of advantages which have made it the preferred engine for a lot of script-powered apps, among them Joomla and Magento, which have moved to InnoDB for good. For example, importing enormous volumes of data will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a particular operation, not the entire database 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 info is handled. Simply put, importing new or editing existing data will either be entirely completed, or will be annulled and the operation will be rolled back in case any problem shows up in the meantime, so the content that remains in the database will not be damaged.
InnoDB in Hosting
Every PHP-based web app that needs InnoDB will run flawlessly on our innovative cloud web hosting platform and the database engine comes with all our hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected on the basis of the app’s prerequisites without having to update any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to take advantage of its full capacity. We will keep regular content backups, so if you unintentionally remove a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your data the way it was only a few hours earlier.