InnoDB is a storage engine for MySQL databases, which is used by well known PHP script-based web apps such as Joomla 3 and Magento. It’s excellent for scalable apps, because it performs very well when handling enormous volumes of data. Rather than locking the whole 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. In addition, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be treated. If a certain operation has not been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will be preserved intact and won’t be partially mixed with newly appended content.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-based web application that needs the MySQL database engine without the need to deal with any problem once you order your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, regardless of whether you take advantage of our single-click installation tool or create the MySQL database and install the app manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll store daily backups of all your databases, so you can rest assured that you will never lose any content in case you erase a database unintentionally or you overwrite some essential information – you simply need to touch base with us and we will restore your content the way it was.