InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP-powered software apps like Joomla™ v3 and Magento. It is excellent for scalable apps, because it works unbelievably well when processing large amounts of data. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same period of time. Besides, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. In case a certain operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially merged with newly imported content.

InnoDB in Shared Hosting

Every PHP-driven web app that requires InnoDB will function impeccably on our cutting-edge cloud website hosting platform and the MySQL database engine is offered with all our shared hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to make the most of its full capacity. We’ll store daily backups of your content, so if you accidentally delete a MySQL database that is important to you or you overwrite some part of it, we will be able to restore your data the way it was just a few hours ago.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you would like to run open-source scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup – as soon as the script configuration wizard gets access to the database and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to activate scripts that require the other very popular MySQL engine – MyISAM, so you will not have to update any settings on the server. This will permit you to install various scripts on one single machine and to use the latter to its fullest capabilities.