InnoDB is a database engine for MySQL relational databases, which is used by widespread open-source script-driven web apps like Magento and Joomla™ 3.x. It is perfect for scalable apps, because it performs amazingly well when handling enormous amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same period of time. What’s more, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be handled. In case a given task has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be kept safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Cloud Web Hosting

InnoDB is available with all our Linux cloud web hosting services by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any script-based web 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, regardless of whether you make use of our 1-click installer or create the database and activate the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be certain that you’ll never lose any data if you erase a database by accident or you overwrite some key info – you’ll simply need to get in touch with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Hosting

You can run a PHP script-based software app that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud platform where the database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer. In either case, the required engine will be selected automatically once the installation of the application begins, so you won’t have to edit anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to retrieve any of your databases if you unintentionally erase one, as we carry out a few database backups every day, each of which is saved for one week.

InnoDB in VPS Web Hosting

If you select a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the default software package that will be pre-installed on your Virtual Private Server before we give it to you. You will not have to activate anything manually and you’ll be able to enable and manage any open-source script-powered web app that requires InnoDB when your VPS server is set up, which takes no more than 1 hour after the order process itself. A couple of engines are available, so whenever you create a database through the Hepsia Control Panel, a specific engine will be picked when the app installation commences and our system will automatically recognize which engine is required by the app in question. If you need to use MyISAM, for instance, you won’t have to do anything different than installing the application of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers Hosting

If you purchase a new dedicated server, you will be able to choose one of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to activate this MySQL database engine manually in order to be able to run open-source script-based software applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage very large sites, it’s pretty possible that you will use InnoDB. You’ll be able to make use of other engines too, so if a given app requires MyISAM rather than InnoDB, you will not have any problem while running it. The engine that will be used will be recognized automatically once the app installation procedure begins, so you won’t need to alter any settings manually at any time.