InnoDB is a database storage engine for MySQL databases, which is used by popular script-powered web apps such as Magento and Joomla™ 3.x. It’s excellent for scalable apps, because it excels in handling huge amounts of data. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same length of time. Moreover, InnoDB offers a better database crash recovery and supports transactions and foreign keys – a set of rules that determine how data imports and modifications should be treated. If a specific operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept undamaged and will not be partially mixed with newly entered content.

InnoDB in Website Hosting

InnoDB is offered with all our Linux website hosting packages by default, not as a paid upgrade or upon request, so you will be able to activate and manage any script-driven web app that requires the InnoDB database engine without having any difficulty once you open your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, regardless of whether you make use of our single-click installer or create the MySQL database and install the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll maintain daily database backups, so you can rest assured that you won’t ever lose any data in case you delete a database by mistake or you overwrite some crucial info – you’ll simply have to touch base with us and we’ll restore your content the way it was.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house developed Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not need to install it manually in case you want to activate PHP scripts that need it. All it takes to install such a script is to set up a new database and to begin the setup – as soon as the script setup wizard gains access to the database in question and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not have to change any settings on the server. This will allow you to run a variety of scripts on a single server and to use it to its maximum potential.