InnoDB is a database engine for MySQL databases, which is used by famous script-driven apps like Magento and Joomla 3.x. It’s perfect for scalable apps, as it works very well when handling large volumes of data. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Furthermore, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. In case a specific task hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will stay undamaged and will not be partially merged with new content.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you can activate and manage any PHP-powered application that requires the InnoDB storage engine without encountering any obstacle once you order your shared account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation process, no matter if you use our one-click installer or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular database backups, so you can be sure that you won’t ever lose any data if you delete a database unintentionally or you overwrite some essential info – you’ll just have to alert us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our semi-dedicated hosting by default, so the moment you obtain a new semi-dedicated account, you can go on and install any script-driven software application that requires this database engine. A few engines are pre-installed on our cloud hosting platform, so when you set up a new MySQL database and begin 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 selected in accordance with the requirements of the specific app. This will allow you to install and run InnoDB-specific applications without coming across any problem and without updating any settings in your account. To take no chances, we will always keep a 7-day-old backup of all your MySQL databases, so if you erase or change any content unintentionally, we can quickly recover it.

InnoDB in VPS

In case our in-house built Hepsia hosting Control Panel is picked during the signup process for a new Linux VPS packages , InnoDB will be activated on the server along with other needed pieces of software, so you will not have to do anything if you choose to activate PHP script-based web apps that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a new database and start the app installation process manually or using our 1-click installation tool. The system will detect the engine that the app in question requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the application can import its content into that database. Therefore, you can make use of apps with different prerequisites regarding the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Hosting

InnoDB comes as standard with all dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It’s included in the standard software package that we install on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to install any type of script-powered software app that requires this MySQL database storage engine. When you set up a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. Once the app activation wizard begins dumping content in the database, the engine will be set automatically in accordance with the requirements of the application in question, so you can use both MyISAM and InnoDB without having to select either one explicitly at any moment. Thus, you can use an extensive collection of apps for your Internet sites.