What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a much better overall performance and a faster crash recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by lots of devs that run highly scalable apps, as it works more effectively with enormous amounts of data, while it keeps the server load low. What’s more, it it locks only one row in the database in case anything should be modified, while lots of other engines lock the entire database table and therefore require much more time to execute multiple sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the action is rolled back to prevent scrambling or losing data. Magento and the latest versions of Joomla™ are two instances of popular open-source script-based web apps which have moved to InnoDB.
InnoDB in Cloud Website Hosting
Every PHP script-powered software app that requires InnoDB will function impeccably on our advanced cloud web hosting platform and the MySQL storage engine comes with all our cloud website hosting
plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s prerequisites without the need to change any setting in your account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll carry out regular content backups, so in case you unintentionally remove a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore your database the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting
come with InnoDB and you can make the most of all the features of this MySQL database storage engine with any open-source script-based app that requires it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the requirements of the given app. You will not have 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 single-click application installer tool. To be on the safe side, we’ll store daily backups of all your MySQL databases, so if something goes wrong after some update or if you remove some data unintentionally, we’ll be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS
If you order a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the standard software pack that will be installed on your server before we give it to you. You will not need to activate anything manually and you will be able to install and run any PHP script-based web app that needs InnoDB when your VPS is up and running, which takes no more than one hour after the order submission itself. A number of engines are available, so every time you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be picked when the app installation process starts and our system will recognize which engine is required by the application in question. In case you need MyISAM, for example, you won’t need to do anything different than installing the chosen app, whether manually or using our application installer.
InnoDB in Dedicated Hosting
All Linux dedicated hosting
ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually if you need to run open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the setup process – once the script setup wizard receives access to the database in question and starts inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You will also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you will not need to configure any settings on the server. This will allow you to run a variety of scripts on a single physical server and to use the latter to its fullest capabilities.