InnoDB is a database engine for MySQL relational databases, which is used by widely used script-based web apps such as Magento and Joomla 3. It’s ideal for scalable applications, because it works unbelievably well when handling enormous amounts of data. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Besides, InnoDB offers a better crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be treated. If a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and won’t be partially merged with newly imported content.

InnoDB in Cloud Hosting

InnoDB is offered with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you can activate and manage any PHP script-driven application that needs the InnoDB database engine without the need to deal with any complication as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, irrespective of whether you make use of our one-click installer or create the database and set up the app manually, provided that the app requires it instead of the more famous MyISAM engine. We’ll store regular MySQL database backups, so you can be sure that you’ll never lose any data in case you erase a database by mistake or you overwrite some key info – you simply need to touch base with us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated packages support InnoDB and you can get the most out of all the options offered by this MySQL storage engine with any PHP script-powered application that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be picked depends on the requirements of the given app. You will not need to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will maintain regular backups of all your databases, so if anything goes wrong following some update or if you erase some data by mistake, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Hosting

When you acquire a virtual private server from us, you’ll be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to manage any open-source script-based application which needs InnoDB, as this MySQL storage engine is an essential part of the software package that will be installed on the VPS server during its setup. When you create a brand-new database using the hosting Control Panel, you just have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine as long as the application in question requires it, so you won’t have to do anything else in your account. Equivalently, if a given app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to activate it manually if you need to run PHP scripts that need it. All it takes to use such a script is to set up a new database and to begin the setup – once the script installation wizard gets access to the database and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to run scripts that require MyISAM – the other widely used MySQL engine, so you will not have to configure any settings on the dedicated server. This will permit you to install various scripts on a single physical server and to use it to its fullest potential.