InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has plenty of pluses which have made it the preferred engine for a lot of PHP script-driven web apps, such as Magento and Joomla™, which have shifted over to InnoDB permanently. For example, adding enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single database row to accomplish a particular task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, appending new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case any problem shows up during the process, which is why the content that remains in the database will not be lost.
InnoDB in Website Hosting
You will be able to make use of any PHP script-driven app that needs InnoDB in case you’ve got a Linux website hosting package with us, as the database engine is present on our leading-edge cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can install applications which require the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t have to update any setting manually at any time. On top of that, we’ll also perform daily backups of all the databases that you have in your shared account, so in case you delete or overwrite something, we can swiftly restore it the way it was on any of the past seven days.