InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by many programmers that create highly scalable apps, due to the fact that it works more effectively with immense data volumes, while it keeps the server processing load at a minimum. What’s more, it it locks only one row in the database in case any information should be edited, whereas many other engines lock the entire table and hence require much more time to process several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ editions are two examples of widely used script-based software platforms that have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is available with all our web hosting service by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-driven app which requires the database engine without encountering any obstacle as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation process, regardless of whether you use our one-click installation tool or create the MySQL database and activate the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will perform regular backups of all your databases, so you can rest assured that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some vital information – you simply need to get in touch with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-driven software app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the database engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our single-click application installer. Either way, the required engine will be picked automatically once the application’s activation begins, so you will not have to change anything manually, no matter if the application requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to recover any of your databases in case you accidentally remove one, as we carry out a few backups every day, each of which is stored for 7 days.

InnoDB in VPS Servers

When you obtain a VPS server from our company, you will be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to run any script-based application that requires InnoDB, as this particular MySQL storage engine is part of the default software bundle that will be installed on the VPS server during its configuration. When you set up a new database through the Control Panel, you will just have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine if the application in question requires it, so you will not have to do anything else in your VPS account. Identically, if a given application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated service that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the default software package that will be pre-installed on all Hepsia-managed servers, so once your machine is set up, you will be able to sign in and to install a various PHP-powered app that needs this particular MySQL storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine until you begin installing an application. As soon as the app configuration wizard starts entering content into the database, the engine will be chosen automatically depending on the prerequisites of the particular app, so you can run both MyISAM and InnoDB without having to select either one of them explicitly at any time. In this way, you can make use of a broad collection of applications for your Internet sites.