InnoDB is a very popular storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has plenty of strong sides that have made it the preferred engine for plenty of PHP script-based apps, including Magento and Joomla, which have switched over to InnoDB for good. For instance, importing large amounts of data will be faster with InnoDB, because it locks only one row to complete an operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is handled. To put it simply, importing new or updating existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case a given issue shows up in the meantime, therefore the content that remains in the database won’t be lost.
InnoDB in Web Hosting
You’ll be able to install any PHP-driven software application that needs InnoDB if you’ve got a web hosting with us, as the MySQL database storage engine is available on our leading-edge cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can install apps that use the MyISAM engine without any obstacles as well and, once again, the engine will be pre-selected, so you won’t need to update anything manually at any time. What’s more, we’ll also create regular backups of all the databases that you’ve got in the shared web hosting account, so in case you delete or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.
InnoDB in Dedicated Servers
If you order a new dedicated server, you’ll be able to pick one of the 3 Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this storage engine manually so as to be able to manage PHP-driven web applications that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you need in order to manage large-size websites, it’s pretty possible that you will use InnoDB. You will be able to use other engines as well, so in case a given app needs MyISAM instead of InnoDB, you won’t experience any complication while managing it. The engine that will be used will be automatically detected as soon as the app installation process begins, so you will not need to modify any setting manually whatsoever.