What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a popular database storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got lots of advantages that have made it the preferred engine for numerous PHP-powered web apps, such as Magento and Joomla™, which have switched over to InnoDB for good. For example, adding huge volumes of data will be faster with InnoDB, because it locks only a single row to complete a particular operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is treated. Put simply, adding new or modifying existent data will either be fully completed, or will be canceled and the operation will be rolled back in case any problem appears during the process, therefore the content that remains in the database will not be damaged.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-powered app that needs the MySQL database engine without having to deal with any impediment as soon as you activate your account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation process, regardless of whether you use our single-click installer or create the MySQL database and set up the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll make regular backups of all your MySQL databases, so you can be sure that you will never lose any data if you erase a database accidentally or you overwrite some vital information – you simply need to get in touch with us and we’ll restore your content the way it was.