InnoDB
Find what a database engine is, what are the pros of the InnoDB engine and why it's gaining a huge amount of popularity.
InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-based software applications like Joomla™ 3.x and Magento. It is perfect for scalable apps, since it performs stunningly well when processing enormous data volumes. Rather than locking the entire database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same period of time. Besides, InnoDB offers a much better crash recovery and supports database transactions and foreign key constraints – rules that define how data imports and updates should be handled. If a specific operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will remain undamaged and won’t be partially mixed with newly entered content.
-
InnoDB in Website Hosting
InnoDB is available with all our
Linux website hosting by default, not upon request or as a paid upgrade, so you can activate and run any open-source script-powered application that requires the MySQL database engine without any impediments as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you use our single-click installation tool or create the database and activate the app manually, provided that the application 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 content if you erase a database by accident or you overwrite some vital information – you will just need to get in touch with us and we’ll restore your content the way it was.
-
InnoDB in Semi-dedicated Servers
All our
Linux semi-dedicated service support InnoDB and you will be able to get the most out of all the features offered by this storage engine with any script-driven software application that requires it. It’s among the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the application in question. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer. To avoid any risk, we’ll keep daily backups of all your MySQL databases, so if something goes wrong after some update or if you remove some content by accident, we will be able to restore your database the way it was on any of the past 7 days.
-
InnoDB in VPS Servers
If you choose a
VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an indivisible part of the software package that will be installed on your server before we hand it over to you. You won’t have to set up anything manually and you will be able to enable and use any script-powered software application that needs InnoDB as soon as your VPS is ready, which takes no more than 1 hour after the order submission process itself. A number of engines are offered, so every time you set up a database through the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process commences and our system will automatically detect the engine that is required by the application in question. In case you need MyISAM, for instance, you will not need to do anything different than installing the chosen application, whether manually or using our application installer.
-
InnoDB in Dedicated Servers
When you obtain a new
dedicated server, you’ll be able to select any of the 3 Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to activate this database engine manually to be able to run PHP script-powered web apps that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the server resources that you need to manage very large Internet sites, it’s very possible that you’ll resort to InnoDB. You will be able to use other engines too, so if a certain application requires MyISAM instead of InnoDB, you won’t encounter any difficulty while running it. The engine that will be used will be recognized automatically as soon as the app installation procedure commences, so you will not have to tweak any settings manually at any point.