InnoDB is a storage engine for MySQL databases, which is used by famous script-driven software applications like Magento and Joomla 3. It’s perfect for scalable apps, because it performs exceptionally well when managing huge data volumes. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same length of time. Besides, InnoDB offers a faster database crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and updates should be treated. In case a given task has not been entirely completed for some reason, the action will be rolled back. In this way, the database content will be preserved intact and will not be partially merged with newly added content.

InnoDB in Shared Hosting

Any PHP-based software app that needs InnoDB will run impeccably on our leading-edge cloud web hosting platform and the database storage engine is available with all our shared hosting plans. 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 in accordance with the app’s specifications without the need to configure any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to get the most out of its full potential. We will perform regular backups of your content, so in case you unintentionally delete a database that you need or you overwrite a specific part of it, we will be able to restore your content the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you start installing a PHP script-driven web app either manually or using our single-click app installer, the storage engine for the database will be picked automatically based on the requirements of the given application. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that requires it without any manual action required on your end at any moment. To avoid any chance of losing data if you update an app or if you delete a database by accident, we will make a backup of all your MySQL databases each day, so if something happens, we can retrieve your data.

InnoDB in VPS Web Hosting

If you order a virtual private server from our company, you’ll be able to make use of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to manage any PHP-powered web app which needs InnoDB, as this database storage engine is part of the default software bundle that will be pre-installed on your VPS server during its configuration. When you create a new MySQL database through the hosting Control Panel, you will just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the app in question needs it, so you won’t need to do anything else in your account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is one of the options that you can select on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of web hosting, it’s pretty likely that you will manage popular sites that will draw a lot of people, and since InnoDB is one of the very best options for such websites, we will install it along with all the other software apps that are offered with a Hepsia-equipped dedicated server. If you create a new MySQL database in your dedicated account, there won’t be any active storage engine till you begin installing a script, whether manually via your browser or using the automatic scripts installer tool that is available in the hosting Control Panel. The required engine will be recognized automatically and will be set for the database in question, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without the need to cope with any complication.