InnoDB is a database storage engine for MySQL databases, which is used by widespread script-powered applications such as Magento and Joomla™ v3. It’s ideal for scalable apps, since it performs unbelievably well when handling large data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same length of time. Additionally, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and modifications should be handled. If a specific task has not been fully completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and will not be partially mixed with newly inserted content.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any PHP script-driven software application which needs the database storage engine without any problems as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, irrespective of whether you use our 1-click installer or create the database and activate the application manually, as long as the app requires it instead of the more popular MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be certain that you will never lose any data in case you erase a database by mistake or you overwrite some vital info – you will just have to alert us and we’ll restore everything the way it was.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated packages support InnoDB and you will be able to take full advantage of all the features of this MySQL database engine with any open-source script-driven web application that needs it. It is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the requirements of the app in question. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer. To avoid any risk, we will generate daily backups of all your MySQL databases, so if something goes wrong following some update or if you remove some data by mistake, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Web Hosting

In case our in-house developed Hepsia hosting Control Panel is chosen during the registration process for your new Linux VPS web hosting packages , InnoDB will be installed on the server along with other needed software, so you will not need to do anything if you decide to activate PHP-powered web apps that need this MySQL storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand-new database and begin installing the application manually or using our one-click installer tool. The system will automatically detect the engine that the application in question needs and will assign it to the specific database, so the installation will proceed flawlessly and the app can import its data into that database. In this way, you can make use of apps with various prerequisites concerning the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

If you order a new dedicated server, you’ll be able to select any of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to install this MySQL database engine manually in order to be able to use PHP script-driven applications that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the server resources that you require in order to run very large Internet sites, it’s pretty likely that you will resort to InnoDB. You will be able to use other engines too, so in case a specific app requires MyISAM rather than InnoDB, you won’t encounter any problem while using it. The engine that will be used will be automatically recognized when the app installation commences, so you will not need to tweak any settings manually at any point.