InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got numerous strong sides that make it the preferred engine for many open-source script-based apps, among them Magento and Joomla, which have switched over to InnoDB for good. For example, importing huge data volumes will be faster with InnoDB, as it locks only a single row to execute a certain operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, importing new or modifying existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem shows up in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

Any PHP script-powered app that requires InnoDB will run flawlessly on our avant-garde cloud website hosting platform and the MySQL database engine is available with all our website hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to change any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We will perform regular content backups, so in case you accidentally delete a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was just several hours earlier.