InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has a number of strong sides that make it the preferred engine for plenty of PHP-powered web applications, including Magento and Joomla™, which have shifted over to InnoDB permanently. For example, adding immense amounts of data will be much faster with InnoDB, due to the fact that it locks only one row to carry out an operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, importing new or modifying existent data will either be entirely completed, or will be aborted and the procedure will be rolled back if any issue occurs in the meantime, which means that the content that remains in the database will not be lost.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other hosting service providers, it’s an essential part of the default set of features that we offer with our shared hosting plans. In case you would like to use a script-based web app that needs InnoDB specifically, in order to be installed and to perform correctly, you will not have to deal with any impediments as the database engine is available on our custom cloud platform. Regardless of whether you set up a brand new database and install an application manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires it rather than MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also make daily database backups, so that we can easily restore any database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated plans include InnoDB and you can take full advantage of all the features of this MySQL storage engine with any PHP-based web application that needs it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the requirements of the specific application. You won’t need to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we’ll create daily backups of all your MySQL databases, so if something 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 that are ordered with our in-house built Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually if you’d like to run open-source PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup – once the script installation wizard gets access to the database in question and begins importing content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You’ll also be able to activate scripts that need the other widely used MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will enable you to install a variety of scripts on a single physical server and to use the latter to its full capabilities.