InnoDB is a database engine for MySQL databases, which is used by widespread PHP script-driven software applications like Magento and Joomla v3. It’s perfect for scalable applications, because it performs very well when handling huge volumes of data. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. Also, InnoDB offers a faster database crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and updates should be handled. If a specific operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will be kept undamaged and won’t be partially mixed with newly appended content.

InnoDB in Web Hosting

You can install any open-source script-powered web app that needs InnoDB in case you have a web hosting package with us, as the database engine is present on our advanced cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can run applications which use the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to modify any setting manually at any point. On top of that, we’ll also perform regular backups of all the databases that you’ve got in your shared account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated hosting by default, so the moment you create a new semi-dedicated account, you can go ahead and install any PHP-based software app that needs this particular storage engine. A couple of engines are pre-installed on our cloud platform, so when you set up a new MySQL database and start installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be picked depending on the requirements of the given app. This will permit you to install and manage InnoDB-specific applications without experiencing any impediment and without updating any settings in your account. To be on the safe side, we’ll always keep a 1-week-old backup of all your databases, so if you remove or edit any content accidentally, we can swiftly restore it.

InnoDB in VPS

All VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to use any PHP-based software app that needs this particular database engine without configuring anything manually. You can pick Hepsia on the VPS configuration page and your brand-new server will be set up within sixty minutes, so you can log in and begin creating your sites straight away. Once you set up a brand new MySQL database and start the app installation process, our system will choose the engine for this database automatically. Thus, you can activate different applications at the same time without the need to update anything on the VPS server. You can create a WordPress-based personal weblog that uses MyISAM – the default MySQL engine, and a Magento-powered online shopping portal that uses InnoDB, for instance.

InnoDB in Dedicated Hosting

InnoDB is available as standard with all Linux dedicated servers hosting packages ordered with the Hepsia Control Panel. It’s part of the standard software bundle that we install on all Hepsia-equipped servers, so once your machine is assembled, you’ll be able to log in and to install any type of PHP script-based web application that needs this MySQL storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any active engine till you begin installing an app. Once the app installation wizard starts importing information into the newly created database, the engine will be chosen automatically based on the specific app’s requirements, so you can run both MyISAM and InnoDB without having to select either of them specifically at any point. In this way, you can make use of an immense variety of applications for your websites.