InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has a number of strong sides that have made it the engine of choice for lots of PHP-driven applications, such as Joomla™ and Magento, which have switched to InnoDB for good. For instance, importing large volumes of data will be faster with InnoDB, due to the fact that it locks only a single row to carry out a specific operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is handled. In simpler words, importing new or updating existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case a given issue appears in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Hosting
Any PHP script-powered application that requires InnoDB will function flawlessly on our innovative cloud web hosting platform and the database storage engine comes with all our hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected in accordance with the app’s requirements without the need to configure any setting in your hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will generate daily content backups, so if you accidentally erase a MySQL database that is important to you or you overwrite a certain part of it, we will be able to restore your database the way it was just a few hours ago.