Learn what a database engine is, what are the pros of the InnoDB engine and why it's gaining a lot of worldwide popularity.
InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-based software apps like Magento and Joomla™ 3. It’s excellent for scalable applications, because it performs exceptionally well when processing immense data volumes. Instead of locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. Also, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and modifications should be treated. In case a particular task has not been thoroughly completed for some reason, the action will be rolled back. In this way, the database content will be kept intact and will not be partially merged with newly entered content.
InnoDB in Shared Web Hosting
Every PHP-driven web app that needs InnoDB will function flawlessly on our leading-edge cloud hosting platform and the MySQL database engine is available with all our shared web hosting plans. Each 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 on the basis of the app’s prerequisites without the need to modify 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 take advantage of its full capacity. We’ll carry out daily content backups, so if you unintentionally delete a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore the database the way it was just a couple of hours ago.