InnoDB is a database engine for MySQL databases, which is used by widespread PHP script-powered web applications such as Joomla 3.x and Magento. It’s perfect for scalable apps, as it works astonishingly well when handling enormous amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same length of time. In addition, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. If a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and won’t be partially merged with newly imported content.
InnoDB in Shared Web Hosting
You’ll be able to use any PHP script-powered app that requires InnoDB in case you’ve got a Linux shared web hosting package with our company, as the storage engine is available on our advanced cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can install applications which require the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you will not have to change any setting manually at any point. Furthermore, we will also make regular backups of all the databases that you’ve got in the shared hosting account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the previous seven days.