InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-driven apps such as Magento and Joomla 3.x. It’s perfect for scalable apps, because it performs astonishingly well when handling enormous amounts of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same period of time. Also, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. If a given task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially mixed with newly entered content.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it is part of the standard set of services that we are offering with our shared hosting plans. If you would like to use an open-source script-powered application that needs InnoDB specifically, in order to be activated and to perform properly, you won’t face any impediments as the MySQL database engine is available on our in-house built cloud website hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. In addition to the excellent database failure recovery offered by InnoDB, we also make daily database backups, so that we can easily recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can use an open-source script-powered software application that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our cutting-edge cloud platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our one-click application installer tool. Either way, the needed engine will be selected automatically the moment the installation of the application begins, so you won’t need to update anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. On top of that, we’ll always be able to retrieve any of your MySQL databases if you delete one by mistake, as we carry out a couple of backups every day, each of which is preserved for one week.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an indivisible part of the default software package that will be installed on your server before we hand it over to you. You will not have to configure anything manually and you’ll be able to install and manage any PHP-powered web app that needs InnoDB once your Virtual Private Server is up and running, which takes no more than 60 minutes after the order submission process itself. A number of engines are available, so every time you set up a database through the Hepsia Control Panel, a particular engine will be selected when the app installation process begins and our system will automatically detect which engine is required by the app in question. If you have 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.

InnoDB in Dedicated Servers

If you order a new dedicated server, you’ll be able to select one of the 3 Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this database storage engine manually to be able to manage PHP script-driven web applications that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the system resources that you need in order to manage large-scale websites, it is pretty likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a particular app needs MyISAM instead of InnoDB, you will not come across any complication while running it. The engine that will be used will be detected automatically once the app installation begins, so you will not need to edit any settings manually whatsoever.