InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP-based web applications such as Joomla 3 and Magento. It is ideal for scalable apps, as it works incredibly well when processing enormous amounts of data. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. Plus, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a particular task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be kept undamaged and will not be partially mixed with newly added content.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-based software application that needs the InnoDB storage engine without any impediments as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, irrespective of whether you take advantage of our single-click installation tool or create the MySQL database and activate the app manually, provided that the app requires it instead of the more famous MyISAM engine. We will keep regular backups of all your MySQL databases, so you can be sure that you will never lose any data if you erase a database unintentionally or you overwrite some important info – you simply need to inform us and we will restore your data the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so once you obtain a new semi-dedicated account, you can move on and install any PHP-driven web app that needs this particular database storage engine. Several engines are pre-installed on our cloud hosting platform, so when you set up a brand new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked depending on the prerequisites of the respective app. This will allow you to install and run InnoDB-specific apps without any impediment and without having to update any settings in your semi-dedicated account. To take no chances, we’ll always keep a 7-day-old backup of all your databases, so if you erase or change any content accidentally, we can swiftly recover it.

InnoDB in VPS Web Hosting

When you buy a virtual private server from our company, you’ll be able to take advantage of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will allow you to activate any script-based web application that requires InnoDB, as this particular MySQL database engine is an essential part of the software package that will be installed on your server during its creation. When you create a brand-new MySQL database through the Control Panel, you will simply need to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine as long as the application in question requires it, so you will not need to do anything else in your account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers Hosting

When you purchase a new dedicated server, you will be able to select any of the three Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to activate this MySQL database engine manually to be able to run open-source script-powered software applications that require it. InnoDB is used by scalable applications and since a dedicated server will give you all the resources that you require in order to manage large-size sites, it is pretty likely that you will resort to InnoDB. You’ll be able to use other engines too, so in case a given app needs MyISAM instead of InnoDB, you won’t have any impediment while using it. The engine that will be used will be detected automatically once the app installation commences, so you won’t need to modify any setting manually at any moment.