See what a database engine is, what are the benefits of the InnoDB engine and why it's gaining a lot of worldwide popularity.
InnoDB is a database engine for MySQL databases, which is used by popular PHP-driven software apps like Joomla™ 3.x and Magento. It is excellent for scalable applications, since it performs really well when handling large volumes of data. Rather than locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same period of time. Moreover, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – rules that specify how data inserts and modifications should be handled. If a specific operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and will not be partially mixed with new content.
InnoDB in Shared Hosting
Every script-powered software app that needs InnoDB will function impeccably on our advanced cloud website hosting platform and the storage engine is offered with all our shared hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to change any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will create regular content backups, so in case you accidentally delete a database that is important to you or you overwrite a certain part of it, we’ll be able to restore the database the way it was only a few hours earlier.