What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and a faster crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by plenty of devs that build scalable web applications, as it works much more efficiently with enormous data volumes, while it keeps the server load low. What’s more, it locks only a single row in the database in case any information should be modified, whereas many other engines lock the entire database table and thus need more time to carry out several successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest versions of Joomla™ are two examples of widely used PHP-driven web applications that have moved to InnoDB.
InnoDB in Shared Website Hosting
Any open-source script-based application that needs InnoDB will function impeccably on our cutting-edge cloud hosting platform and the MySQL storage engine comes with all our shared website hosting
packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to edit any setting in your shared account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We’ll perform regular content backups, so in case you accidentally erase a database that’s important to you or you overwrite some part of it, we’ll be able to restore everything the way it was only several hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
come with InnoDB and you’ll be able to get the most out of all the options offered by this MySQL database storage engine with any PHP-driven software app that needs it. It is among the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the respective app. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To be on the safe side, we will perform regular backups of all your databases, so if something goes wrong after some update or if you remove some data accidentally, we’ll be able to restore the database the way it was on any of the past 7 days.
InnoDB in VPS Servers
When you buy a VPS server
from our company, you will be able to take advantage of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to run any PHP-powered web application that needs InnoDB, as this particular MySQL database engine is part of the software package that will be pre-installed on your VPS server during its configuration. When you set up a new database through the hosting Control Panel, you’ll simply need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the app in question needs it, so you will not need to do anything else in your VPS account. Likewise, if an application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
All dedicated servers
that are ordered with our custom Hepsia hosting Control Panel include a software package that’s pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not have to install it manually if you would like to use open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to begin the installation – once the script setup wizard gets access to the database and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to configure any settings on the server. This will permit you to activate a variety of scripts on a single physical server and to use the latter to its maximum capabilities.