InnoDB is a database engine for MySQL relational databases, which is used by widespread script-powered software applications such as Joomla 3.x and Magento. It’s perfect for scalable applications, since it works unbelievably well when handling huge data volumes. Instead of locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. In addition, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and updates should be treated. In case a given task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be kept safe and sound and will not be partially merged with newly imported content.
InnoDB in Shared Website Hosting
Every PHP script-driven web application that requires InnoDB will function flawlessly on our advanced cloud hosting platform and the MySQL database engine comes with all our shared website hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected based on the app’s requirements without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We will create daily backups of your content, so in case you unintentionally erase a MySQL database that’s important to you or you overwrite a specific part of it, we’ll be able to restore your database the way it was only a couple of hours ago.