Find out about InnoDB and find out why it’s recently been selected as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by famous script-driven applications like Magento and Joomla™ v3. It is ideal for scalable apps, as it performs unbelievably well when managing large data volumes. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same length of time. Additionally, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. If a specific operation hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the database content will be preserved intact and won’t be partially merged with newly appended content.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-driven web app which needs the MySQL database engine without the need to deal with any obstacle once you activate your account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and activate the application manually, as long as the app requires it instead of the more popular MyISAM engine. We will maintain daily backups of all your MySQL databases, so you can rest assured that you will never lose any content if you erase a database accidentally or you overwrite some crucial info – you simply have to get in touch with us and we will restore your content the way it was.