InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-based web applications such as Magento and Joomla™ 3. It is ideal for scalable apps, as it works stunningly well when handling huge amounts of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Plus, InnoDB offers a faster database failure recovery and supports transactions and foreign keys – rules that specify how data inserts and modifications should be treated. In case a particular task has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and will not be partially merged with new content.

InnoDB in Web Hosting

Any open-source script-based software application that needs InnoDB will run impeccably on our advanced cloud website hosting platform and the MySQL database storage engine is offered with all our web hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without having to update any setting in your shared account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We’ll carry out regular content backups, so if you unintentionally delete a MySQL database that you need or you overwrite certain parts of it, we’ll be able to restore your database the way it was just a few hours ago.

InnoDB in Semi-dedicated Hosting

You can make use of a script-driven web application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our innovative cloud hosting platform where the storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our one-click app installer. In either case, the required engine will be picked automatically once the app’s installation starts, so you will not need to edit anything manually, irrespective of whether the app requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you unintentionally delete one, as we create several database backups every day, each of which is kept for 1 week.

InnoDB in VPS Hosting

In case our custom-built Hepsia Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be activated on the server together with other needed software, so you will not have to do anything if you decide to run PHP script-based software apps that need this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a new MySQL database and begin the app installation manually or through our one-click installer tool. The system will automatically detect the engine that the application in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can dump its content in that database. Thus, you can activate applications with different prerequisites regarding the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our custom-built Hepsia hosting Control Panel include a software package that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually in case you need to run scripts that need it. All it takes to activate such a script is to create a new MySQL database and to begin the setup – once the script configuration wizard gets access to the database and begins entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to update any settings on the server. This will enable you to use a variety of scripts on one single physical server and to use it to its maximum capabilities.