What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a very popular storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has lots of strong sides which make it the engine of choice for lots of PHP script-based web applications, including Joomla™ and Magento, which have switched to InnoDB permanently. For instance, adding large data volumes will be faster with InnoDB, since it locks only one row to perform a certain operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is handled. Put simply, appending new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back if any problem appears in the meantime, therefore the content that remains in the database will not be damaged.
InnoDB in Website Hosting
Any script-based software application that needs InnoDB will run flawlessly on our advanced cloud web hosting platform and the MySQL storage engine is available with all our website hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to update any setting in your shared account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will perform daily content backups, so in case you unintentionally delete a database that is important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only a couple of hours earlier.