What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by a lot of devs that run highly scalable software apps, because it works better with immense volumes of data, while it keeps the server processing load at a minimum. What’s more, it it locks only one row in the database if any information should be edited, whereas lots of other engines lock the entire database table and therefore need more time to accomplish several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the action is rolled back to avoid confusion or data loss. Magento and the newest releases of Joomla™ are two instances of widespread open-source script-driven apps that have switched to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it’s an essential part of the standard set of services that we’re offering with our shared hosting
packages. In case you would like to make use of an open-source script-driven software application that requires InnoDB specifically, in order to be installed and to function correctly, you won’t face any obstacles as the InnoDB storage engine is available on our custom cloud website hosting platform. Irrespective of whether you set up a brand-new database and install an app manually or take advantage of our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs InnoDB instead of MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also store daily backups of all databases, so that we can quickly recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database through the hosting Control Panel included with each of our semi-dedicated server
packages and you start installing a script-powered software app either manually or using our single-click app installer tool, the database storage engine will be picked automatically depending on the given app’s prerequisites. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any app that needs it without any manual intervention needed on your end at any moment. To prevent any risk of losing information if you update an application or if you remove a database by accident, we will make a backup of all your databases each and every day, so if something happens, we can retrieve your content.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the features that you can select on the order page when you purchase a dedicated server
from our company. Since this is the most powerful kind of website hosting, it is pretty likely that you will manage very popular Internet sites that will draw a lot of individuals, and since InnoDB is among the best choices for such websites, we will enable it along with all the other software applications that are available with a Hepsia-managed server. When you set up a new database in your account, there won’t be any activated database storage engine till you start installing an open-source script, whether manually through your Internet browser or using the automatic scripts installer that is available in the hosting Control Panel. The needed engine will be automatically recognized and will be set for that database, so you can install scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to deal with any problem.