InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has many advantages that make it the preferred engine for numerous PHP-based apps, including Magento and Joomla, which have switched to InnoDB for good. For instance, adding large volumes of data will be faster with InnoDB, because it locks only one database row to accomplish a certain task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. Simply put, appending new or modifying existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case a certain issue occurs during the process, thus 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 plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP script-driven software app which requires the InnoDB database storage engine without any impediments as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation, no matter if you make use of our one-click installer or create the database and activate the app manually, provided that the app requires it instead of the more popular MyISAM engine. We will carry out daily MySQL database backups, so you can rest assured that you will never lose any content in case you erase a database by mistake or you overwrite some vital info – you will simply have to contact us and we’ll restore everything the way it was.