InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got a number of pluses that have made it the engine of choice for numerous PHP-powered web apps, including Magento and Joomla™, which have shifted over to InnoDB permanently. For example, importing enormous amounts of data will be much faster with InnoDB, because it locks only a single row to complete a particular operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is handled. In simpler words, appending new or updating existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a given problem shows up during the process, which means that the content that remains in the database won’t be damaged.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting packages by default, not upon request or as a paid upgrade, so you can activate and manage any script-powered web app which requires the database engine without any problems once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation process, regardless of whether you use our single-click installation tool or create the database and set up the application manually, on the condition that the application requires it instead of the more popular MyISAM engine. We’ll create regular backups of all your databases, so you can rest assured that you’ll never lose any content if you erase a database unintentionally or you overwrite some essential info – you simply need to inform us and we’ll restore your data back to normal.