InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has plenty of pluses which have made it the engine of choice for plenty of PHP-driven applications, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, importing huge volumes of data will be much faster with InnoDB, since it locks only one database row to perform a given task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is tackled. In simpler words, adding new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if a certain problem occurs during the process, hence the content that remains in the database won’t be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting providers, it is part of the default set of services offered with our cloud web hosting packages. If you would like to use a PHP-powered web application that needs InnoDB particularly, in order to be activated and to function correctly, you won’t have to deal with any problems because the database engine is available on our custom-developed cloud website hosting platform. Regardless of whether you set up a brand new database and install an app manually or make use of our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the app needs it rather than MyISAM. Besides the exceptional crash recovery that InnoDB is offering, we also generate daily database backups, so we can easily recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the hosting Control Panel included with each of our semi-dedicated server plans and you begin installing a script-powered application either manually or using our single-click app installer, the database storage engine will be set automatically depending on the particular app’s requirements. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any moment. To prevent any risk of losing data if you update an application or if you erase a database by mistake, we will perform a backup of all your databases every day, so if something happens, we can restore your data.

InnoDB in Dedicated Web Hosting

If you order a new dedicated server, you’ll be able to select any of the three hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to add this database engine manually in order to be able to manage PHP script-powered apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you require to manage very large Internet sites, it’s quite likely that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain app needs MyISAM rather than InnoDB, you won’t run into any problem while running it. The engine that will be used will be automatically detected when the app installation process begins, so you won’t have to configure any settings manually at any time.