InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has lots of strong sides which make it the engine of choice for lots of PHP-powered applications, including Joomla and Magento, which have shifted over to InnoDB permanently. For example, importing large volumes of data will be faster with InnoDB, since it locks only a single database row to complete a given operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, appending new or editing existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case some problem shows up during the process, hence the content that remains in the database will not be damaged.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any PHP script-driven software app which needs the database engine without any problems as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, no matter if you make use of our single-click installation tool or create the database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some key info – you will just need to inform us and we will restore the database the way it was.