Find out about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by widely used open-source script-based web apps like Joomla™ v3 and Magento. It is perfect for scalable apps, because it works unbelievably well when handling immense data volumes. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same period of time. Also, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – rules that specify how data inserts and modifications should be treated. In case a particular task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially mixed with new content.
InnoDB in Cloud Website Hosting
Every PHP-driven software application that requires InnoDB will function impeccably on our cutting-edge cloud platform and the database engine is available with all our cloud website hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We’ll maintain regular backups of your content, so in case you accidentally erase a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore everything the way it was just several hours ago.