InnoDB is a database storage engine for MySQL databases, which is used by famous PHP-based web apps like Joomla™ v3 and Magento. It’s ideal for scalable apps, since it works amazingly well when handling enormous amounts of data. Instead of 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 handle a lot more operations for the same period of time. Also, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be handled. If a specific task has not been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and will not be partially merged with newly entered content.
InnoDB in Shared Hosting
Every script-powered web app that requires InnoDB will function impeccably on our leading-edge cloud website hosting platform and the MySQL database storage engine comes with all our shared hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without having to modify any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We will make daily content backups, so if you unintentionally erase a database that is important to you or you overwrite specific parts of it, we’ll be able to restore the database the way it was only several hours earlier.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our Linux semi-dedicated hosting plans by default, so the moment you order a new account, you can go ahead and install any PHP-powered software app that requires this MySQL database engine. A number of engines are installed on our cloud platform, so when you create a brand new MySQL database and begin installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected depending on the requirements of the app in question. This will permit you to activate and run InnoDB-specific apps without having any difficulty and without having to modify any settings in your semi-dedicated account. To avoid any risk, we’ll always have a seven-day-old backup of all your MySQL databases, so if you erase or edit any content accidentally, we can swiftly restore it.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is selected during the signup process for a new VPS plans , InnoDB will be installed on the Virtual Private Server along with other essential software, so you will not have to do anything if you decide to make use of open-source script-powered software apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can set up a new MySQL database and begin the app installation process manually or using our 1-click installer tool. The system will automatically recognize which engine the particular application requires and will set it for the specific database, so the installation will continue impeccably and the application can enter its content into that database. Thus, you can use applications with various prerequisites with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
If you buy a new dedicated server, you’ll be able to select any of the three Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to activate this MySQL database engine manually in order to be able to run open-source script-driven software apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you require in order to manage large-scale Internet sites, it is very possible that you’ll use InnoDB. You’ll be able to use other engines too, so in case a given app needs MyISAM rather than InnoDB, you won’t need to deal with any impediment while managing it. The engine that will be used will be detected automatically as soon as the app installation commences, so you won’t need to fine-tune any setting manually at any point.