What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has numerous strengths that make it the engine of choice for numerous PHP script-powered apps, including Magento and Joomla™, which have moved to InnoDB permanently. For instance, adding enormous amounts of data will be faster with InnoDB, because it locks only one row to carry out a given task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is treated. In simpler words, appending new or modifying existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case a given issue appears in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Cloud Hosting
Every PHP-driven app that requires InnoDB will run flawlessly on our avant-garde cloud platform and the MySQL database engine is available with all our cloud hosting
packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected based on the app’s requirements without having to configure any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will keep regular backups of your content, so in case you accidentally erase a MySQL database that is important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was just a few hours ago.