InnoDB is a popular storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has many strong sides that make it the preferred engine for numerous PHP script-based web apps, including Magento and Joomla, which have shifted over to InnoDB permanently. For instance, importing enormous volumes of data will be much faster with InnoDB, due to the fact that it locks only a single row to execute a given operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is handled. In simpler words, importing new or modifying existent data will either be fully completed, or will be aborted and the operation will be rolled back in case some problem shows up during the process, therefore the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

Every script-based web application that needs InnoDB will function flawlessly on our leading-edge cloud hosting platform and the MySQL database storage engine is available with all our shared hosting packages. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected on the basis of the app’s specifications without having to configure any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to get the most out of its full potential. We’ll carry out daily content backups, so in case you unintentionally delete a database that you need or you overwrite a specific part of it, we will be able to restore everything the way it was only a few hours ago.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP-driven app either manually or using our 1-click app installer tool, the storage engine for the database will be set automatically depending on the requirements of the specific application. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without any manual intervention needed on your end at any point. To avoid any risk of losing info if you update an app or if you remove a database by accident, we’ll perform a backup of all your databases every day, so if anything goes wrong, we can restore your data.