InnoDB is a database storage engine for MySQL relational databases, which is used by widely used open-source script-powered web applications like Joomla v3 and Magento. It’s ideal for scalable applications, because it works very well when managing immense volumes of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same length of time. Furthermore, InnoDB offers a much faster database crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. If a given operation hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially merged with newly appended content.
InnoDB in Shared Web Hosting
You’ll be able to install any open-source script-powered software application that needs InnoDB if you’ve got a shared web hosting with us, as the database storage engine is available on our leading-edge cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can install apps that use the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you won’t need to edit any setting manually at any moment. Furthermore, we’ll also create daily backups of all the MySQL databases that you’ve got in your shared hosting account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the previous seven days.