Find out about InnoDB and find out why it’s recently been picked out as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by popular PHP-powered software applications like Magento and Joomla™ 3.x. It’s perfect for scalable apps, as it performs astonishingly well when processing immense amounts of data. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that define how data inserts and modifications should be treated. In case a specific task hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will be retained undamaged and won’t be partially merged with newly inserted content.
InnoDB in Cloud Hosting
Any PHP-powered web application that needs InnoDB will run flawlessly on our avant-garde cloud web hosting platform and the database storage engine is offered with all our cloud hosting
plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s requirements without the need to configure any setting in your shared web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to get the most out of its full capacity. We will carry out regular content backups, so if you unintentionally delete a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore your data the way it was just several hours ago.