InnoDB is a very popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got lots of pluses which have made it the preferred engine for lots of open-source script-driven apps, such as Magento and Joomla™, which have switched over to InnoDB permanently. For example, adding immense volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a specific operation, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. Simply put, adding new or editing existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case a certain problem occurs in the meantime, therefore the content that remains in the database won’t be lost.

InnoDB in Hosting

Any PHP-powered software application that requires InnoDB will run impeccably on our innovative cloud web hosting platform and the MySQL database storage engine is offered with all our hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected in accordance with the app’s specifications without having to modify any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We will carry out daily content backups, so in case you accidentally delete a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore your content the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the hosting Control Panel offered with all our semi-dedicated server packages and you start installing an open-source script-powered application either manually or using our one-click application installer tool, the storage engine for the database will be selected automatically on the basis of the specific app’s requirements. As InnoDB is available on the cloud platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any application that needs it without any manual action needed on your end at any point. To prevent any risk of losing data if you update an app or if you erase a database unintentionally, we’ll carry out backups of all your MySQL databases each and every day, so if anything happens, we can rescue your data.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t need to install it manually in case you wish to run open-source scripts that need it. All it takes to install such a script is to set up a new database and to start the setup process – once the installation wizard receives access to the database in question and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to install scripts that need MyISAM, the other widely used MySQL engine, so you won’t have to edit any settings on the server. This will allow you to install a variety of scripts on one single physical server and to use the latter to its full capabilities.