InnoDB is a database engine for MySQL databases, which is used by famous open-source script-driven apps like Joomla™ 3 and Magento. It is perfect for scalable applications, since it works incredibly well when processing 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 a lot more tasks for the same length of time. Plus, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that indicate how data imports and updates should be treated. In case a specific task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will be kept safe and sound and won’t be partially mixed with newly inserted content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it is included in the standard set of services that we are offering with our shared hosting packages. In case you wish to use a PHP-based web app that requires InnoDB specifically, in order to be installed and to perform correctly, you will not experience any impediments since the database storage engine is available on our in-house developed cloud platform. No matter if you set up a brand new MySQL database and activate an app manually or make use of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the remarkable crash recovery that InnoDB offers, we also make daily backups of all databases, so that we can easily recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can make use of a PHP-powered software app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud platform where the MySQL database storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click application installer. In either case, the needed engine will be selected automatically the moment the activation of the app begins, so you will not have to configure anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. Also, we will always be able to restore any of your MySQL databases in case you delete one by accident, as we perform a couple of MySQL database backups every day, each of which is stored for one week.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the default software package that will be pre-installed on your server before we hand it over to you. You won’t have to configure anything manually and you will be able to enable and run any open-source script-powered software application that requires InnoDB when your Virtual Private Server is set up, which takes no more than one hour after the order process itself. A few engines are available, so anytime you set up a database using the Hepsia hosting Control Panel, a particular engine will be selected when the app activation commences and our system will detect the engine that is required by the app in question. If you need to use MyISAM, for instance, you will not have to do anything different than installing the application of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
If you get a new dedicated server, you will be able to pick any of the three Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to enable this MySQL database engine manually to be able to use script-driven software applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require to run large-size websites, it’s pretty likely that you’ll resort to InnoDB. You will be able to use other engines as well, so if a given app needs MyISAM rather than InnoDB, you will not encounter any impediment while running it. The engine that will be used will be automatically detected when the app installation procedure begins, so you will not have to modify any setting manually at any moment.