InnoDB is a database engine for MySQL databases, which is used by widespread PHP-based apps such as Joomla 3.x and Magento. It is ideal for scalable apps, because it performs exceptionally well when processing huge amounts of data. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can process much more operations for the same period of time. Plus, InnoDB offers a faster database crash recovery and supports database transactions and foreign keys – rules that prescribe how data inserts and updates should be handled. If a particular task has not been fully completed for some reason, the action will be rolled back. In this way, the database content will stay safe and sound and will not be partially mixed with new content.

InnoDB in Cloud Hosting

Any open-source script-driven application that requires InnoDB will function impeccably on our innovative cloud web hosting platform and the MySQL database engine is offered with all our cloud hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected based on the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We’ll perform daily content backups, so in case you unintentionally delete a database that is important to you or you overwrite some part of it, we will be able to restore your data the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-driven software application that needs InnoDB with any of our semi-dedicated server plans, since all the accounts are set up on our innovative cloud platform where the database engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our one-click application installer tool. Either way, the required engine will be picked automatically as soon as the activation of the application begins, so you will not have to modify anything manually, irrespective of whether the app needs InnoDB or the more regularly used MyISAM. Also, we’ll always be able to retrieve any of your databases if you unintentionally remove one, as we create a few database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to run any open-source script-powered app that needs this particular database storage engine without installing anything manually. You can select Hepsia on the VPS order page and your brand-new Virtual Private Server will be set up within 60 minutes, so you can log in and begin building your Internet sites straight away. When you set up a brand new database and start the app activation process, our system will select the engine for this database automatically. Thus, you can activate different apps at the same time without the need to configure anything on the VPS server. You can set up a WordPress-driven personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-commerce site that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

InnoDB comes by default with all Linux dedicated servers ordered with the Hepsia Control Panel. It is included in the software package that will be installed on all Hepsia-managed servers, so once your physical machine is up and running, you will be able to log in and to activate any PHP script-based app that needs this storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you start installing an application. Once the app installation wizard starts inserting data into the newly created database, the engine will be chosen automatically in accordance with the requirements of the particular app, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any moment. Thus, you can make use of a broad collection of applications for your Internet sites.