InnoDB is a database engine for MySQL relational databases, which is used by well known open-source script-powered applications such as Magento and Joomla v3. It’s excellent for scalable applications, because it works very well when managing immense data volumes. Rather than locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same length of time. Moreover, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. If a given operation hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be retained intact and won’t be partially merged with new content.
InnoDB in Shared Website Hosting
Any script-powered web app that requires InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the database engine is offered with all our shared website hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s specifications without the need to configure any setting in your shared account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll keep daily backups of your content, so in case you unintentionally delete a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your data the way it was only several hours earlier.