InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has many advantages which have made it the engine of choice for many open-source script-powered applications, such as Magento and Joomla™, which have moved to InnoDB permanently. For instance, adding enormous volumes of data will be much faster with InnoDB, due to the fact that it locks only one database row to execute a task, 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 info is treated. In simpler words, adding new or editing existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any problem appears in the meantime, which means that the content that remains in the database will not be damaged.

InnoDB in Shared Web Hosting

Every open-source script-powered software app that requires InnoDB will run flawlessly on our advanced cloud hosting platform and the database engine is offered with all our shared web hosting plans. Every time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s requirements without having to update any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will keep daily content backups, so if you unintentionally erase a database that’s important to you or you overwrite some part of it, we’ll be able to restore the database the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you can make use of all the features of this MySQL database storage engine with any open-source script-based web app that requires it. It is among the engines that are available on our cloud hosting platform, so the one that will be selected depends on the requirements of the app in question. You will not need to do anything manually to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we will maintain daily MySQL database backups, so if anything goes wrong after an upgrade or if you erase some content unintentionally, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not have to install it manually if you need to use open-source PHP scripts that need it. All it takes to run such a script is to set up a new database and to initiate the installation process – once the script installation wizard accesses the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you will not have to modify any settings on the server. This will permit you to use various scripts on one single physical server and to use it to its full potential.