InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has many strong sides which make it the engine of choice for numerous PHP-based apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, adding immense volumes of data will be faster with InnoDB, since it locks only one row to perform a specific operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is tackled. In simpler words, importing new or editing existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a certain issue appears during the process, thus the content that remains in the database won’t be lost.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting service providers, it’s an essential part of the standard set of services that we offer with our shared website hosting plans. In case you’d like to use a PHP-based web app that requires InnoDB in particular, in order to be installed and to work properly, you will not experience any difficulties since the storage engine is available on our custom cloud platform. No matter if you set up a new database and activate an app manually or make use of our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular application requires it instead of MyISAM. Besides the remarkable database failure recovery that InnoDB is offering, we also maintain daily database backups, so that we can swiftly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages support InnoDB and you will be able to take advantage of all the options offered by this MySQL database storage engine with any open-source script-based software app that requires it. InnoDB is among the engines that we have on our cloud hosting platform, so the one that will be picked depends on the requirements of the app in question. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we will perform regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you erase some data unintentionally, we will be able to restore the database the way it was on any of the previous 7 days.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages that are ordered with our custom-developed 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 have to activate it manually if you’d like to run scripts that need it. All it takes to use such a script is to set up a new database and to start the setup – as soon as the setup wizard gains access to the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You’ll also be able to install scripts that need MyISAM, the other widely used MySQL engine, so you won’t have to update any settings on the dedicated server. This will permit you to activate a variety of scripts on one single machine and to use it to its fullest capacity.