InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP script-powered web applications like Joomla 3.x and Magento. It’s excellent for scalable applications, since it works astonishingly well when managing enormous amounts of data. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same period of time. Plus, InnoDB offers a faster database crash recovery and supports database transactions and foreign keys – rules that indicate how data imports and modifications should be treated. In case a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will remain safe and sound and won’t be partially merged with newly appended content.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s an essential part of the default set of features that we’re offering with our shared hosting plans. In case you wish to use an open-source script-based software app that needs InnoDB in particular, in order to be installed and to perform properly, you won’t have to deal with any difficulties because the InnoDB database storage engine is available on our in-house built cloud Internet hosting platform. No matter if you set up a new database and install an app manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the specific app requires InnoDB rather than MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also make daily database backups, so we can swiftly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated servers by default, so as soon as you purchase a new account, you can go ahead and install any PHP-based application that needs the database engine. A number of engines are installed on our cloud web hosting platform, so when you create a new MySQL database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set depending on the requirements of the specific app. This will permit you to activate and manage InnoDB-specific applications without running into any predicament and without the need to update any settings in your semi-dedicated account. To be on the safe side, we will always have a 7-day-old backup of all your MySQL databases, so if you delete or alter any content unintentionally, we can easily recover it.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB database engine will be included in the software package that will be pre-installed on your server before we give it to you. You won’t need to activate anything manually and you’ll be able to enable and manage any open-source script-powered software application that needs InnoDB once your VPS server is set up, which takes no more than 60 minutes after the order process itself. A number of engines are available, so every time you set up a MySQL database via the Hepsia Control Panel, a specific engine will be picked when the app installation process commences and our system will detect the engine that is required by the application in question. If you have to use MyISAM, for instance, you will not have to do anything different from installing the desired app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our in-house developed Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not need to install it manually in case you need to run PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the setup process – once the installation wizard gains access to the database and starts dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that need MyISAM, the other popular MySQL engine, so you will not have to configure any settings on the server. This will allow you to use different scripts on one single server and to use it to its full capabilities.