Discover what a database engine is, what are the advantages of the InnoDB engine and why it's gaining so much worldwide popularity.
InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP-powered software apps like Joomla™ v3 and Magento. It is excellent for scalable apps, because it works unbelievably well when processing large amounts of data. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same period of time. Besides, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. In case a certain operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially merged with newly imported content.
InnoDB in Shared Hosting
Every PHP-driven web app that requires InnoDB will function impeccably on our cutting-edge cloud website hosting platform and the MySQL database engine is offered with all our shared hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to make the most of its full capacity. We’ll store daily backups of your content, so if you accidentally delete a MySQL 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 a few hours ago.