What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-powered web apps such as Magento and Joomla™ 3. It’s ideal for scalable applications, as it works unbelievably well when managing enormous data volumes. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same period of time. Besides, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – rules that indicate how data imports and modifications should be handled. In case a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will remain safe and sound and will not be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
Every PHP script-powered software app that requires InnoDB will run flawlessly on our innovative cloud website hosting platform and the database storage engine is offered with all our shared web hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected in accordance with the app’s specifications without the need to edit any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll perform daily content backups, so if you unintentionally remove a MySQL database that is important to you or you overwrite a certain part of it, we’ll be able to restore your data the way it was just several hours earlier.