InnoDB is a database engine for MySQL databases, which is used by well known open-source script-driven software applications like Magento and Joomla v3. It’s excellent for scalable apps, since it performs astonishingly well when managing large volumes of data. Rather than locking the entire table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that define how data inserts and modifications should be handled. In case a specific task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and will not be partially mixed with newly appended content.

InnoDB in Shared Web Hosting

Every PHP script-based software application that requires InnoDB will run flawlessly on our innovative cloud website hosting platform and the MySQL database storage engine is available with all our shared web hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s prerequisites without having to edit any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We will perform regular backups of your content, so in case you unintentionally erase a database that you need or you overwrite a specific part of it, we’ll be able to restore everything the way it was only several hours earlier.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to use any PHP script-driven web application that needs this MySQL storage engine without having to activate anything manually. You can pick Hepsia on the VPS order page and your new server will be ready within sixty minutes, so you can sign in and start setting up your sites straight away. When you set up a brand new MySQL database and begin the app installation process, our system will choose the engine for this MySQL database automatically. Thus, you can make use of various apps simultaneously without the need to update anything on the VPS server. You can set up a WordPress-powered online blog that makes use of the default MySQL engine – MyISAM, and a Magento-based online shopping portal that uses InnoDB, for example.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-built Hepsia hosting Control Panel include a software package that’s pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually if you wish to run open-source PHP scripts that need it. All it takes to install such a script is to create a new database and to begin the installation – once the setup wizard accesses the database and starts importing content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You’ll also be able to run scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to update any settings on the dedicated server. This will permit you to activate various scripts on one single server and to use the latter to its maximum capabilities.