InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-powered web apps such as Joomla™ 3 and Magento. It is excellent for scalable apps, since it works astonishingly well when processing huge amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more operations for the same period of time. Besides, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be handled. If a specific task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be kept safe and sound and will not be partially merged with newly appended content.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other hosting providers, it’s an essential part of the default set of services that we’re offering with our shared hosting plans. In case you want to use a PHP script-based app that requires InnoDB specifically, in order to be installed and to function properly, you won’t have to deal with any obstacles as the InnoDB database storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or make use of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective application needs InnoDB instead of MyISAM. In addition to the incredible database crash recovery that InnoDB offers, we also carry out daily database backups, so we can easily recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our semi-dedicated plans by default, so once you order a new account, you can move on and activate any script-based software app that requires the MySQL database storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you create a brand new MySQL database and start installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set based on the prerequisites of the application in question. This will allow you to install and manage InnoDB-specific apps without needing to cope with any complication and without having to modify any settings in your semi-dedicated account. To be on the safe side, we will always keep a 1-week-old backup of all your databases, so if you remove or alter any content by accident, we can quickly recover it.
InnoDB in VPS Servers
All VPS web hosting plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you’ll be able to run any PHP script-based web application that needs this database storage engine without the need to install anything manually. You can select Hepsia on the VPS configuration page and your brand new VPS server will be set up within sixty minutes, so you can log in and start building your sites straight away. Once you create a brand new MySQL database and start the app installation process, our system will choose the engine for that MySQL database automatically. In this way, you can manage different applications at the same time without updating anything on the Virtual Private Server. You can have a WordPress-driven personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-commerce website that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
When you get a new dedicated server, you’ll be able to pick one of the three hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to add this storage engine manually to be able to manage script-powered applications that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the server resources that you need in order to run large-scale sites, it’s rather likely that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a specific application needs MyISAM instead of InnoDB, you will not need to deal with any problem while managing it. The engine that will be used will be automatically recognized when the app installation process begins, so you won’t have to update any setting manually at any point.