InnoDB is a storage engine for MySQL relational databases, which is used by popular open-source script-driven web applications such as Joomla v3 and Magento. It’s excellent for scalable applications, as it performs incredibly well when handling huge data volumes. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same period of time. What’s more, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and updates should be treated. In case a certain task has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved undamaged and won’t be partially mixed with newly added content.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so once you create a new semi-dedicated account, you can move on and install any open-source script-powered app that requires this MySQL storage engine. Several engines are pre-installed on our cloud web hosting platform, so when you set up a new MySQL database and begin installing an app manually, or decide to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the respective app’s prerequisites. This will permit you to activate and run InnoDB-specific apps without having to deal with any difficulty and without editing any settings in your account. To be on the safe side, we’ll always have a seven-day-old backup of all your databases, so if you remove or edit any content by mistake, we can swiftly recover it.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually if you need to use open-source scripts that need it. All it takes to run such a script is to set up a new database and to initiate the setup process – as soon as the setup wizard gains access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided 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 will not have to change any settings on the server. This will permit you to use a variety of scripts on a single machine and to use the latter to its fullest potential.