Find out more on InnoDB and see why it’s been picked out as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-driven apps such as Magento and Joomla™ v3. It is ideal for scalable applications, because it performs unbelievably well when managing large volumes of data. Instead of locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same length of time. Plus, InnoDB offers a faster crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be handled. In case a given operation hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will be kept intact and will not be partially mixed with newly entered content.
InnoDB in Shared Web Hosting
Every script-powered web application that requires InnoDB will run flawlessly on our cutting-edge cloud hosting platform and the MySQL storage engine comes with all our shared web hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected on the basis of the app’s requirements without the need to modify any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll keep daily content backups, so in case you unintentionally delete a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore your content the way it was only several hours ago.