InnoDB is a popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got plenty of strong sides which have made it the engine of choice for lots of open-source script-driven software apps, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only one row to complete an operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is treated. Simply put, adding new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a certain issue occurs in the meantime, so the content that remains in the database won’t be damaged.
InnoDB in Hosting
You will be able to make use of any PHP-powered software app that requires InnoDB if you’ve got a hosting with our company, as the database storage engine is present on our cutting-edge cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can activate apps which need the MyISAM engine without encountering any problem as well and, once again, the engine will be selected automatically, so you will not have to edit any setting manually at any moment. Furthermore, we will also create regular backups of all the MySQL databases that you have in the account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database from the Control Panel included with each of our semi-dedicated server accounts and you start installing a PHP-based software application either manually or using our single-click application installer, the MySQL database storage engine will be picked automatically on the basis of the given app’s requirements. Since InnoDB is present on the cloud platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any moment. To prevent any risk of losing information if you update an application or if you delete a database accidentally, we will make a backup of all your MySQL databases each day, so if anything goes wrong, we can retrieve your content.