InnoDB is a very popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has a number of upsides which have made it the preferred engine for lots of script-based software apps, such as Magento and Joomla™, which have switched to InnoDB for good. For example, importing large data volumes will be much faster with InnoDB, because it locks only one row to complete a given operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. Put simply, adding new or updating existent data will either be entirely completed, or will be annulled and the operation will be rolled back in case some problem shows up in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting providers, it’s an integral part of the standard set of features that we are offering with our hosting plans. In case you’d like to make use of an open-source script-based application that requires InnoDB in particular, in order to be activated and to operate correctly, you will not face any difficulties as the storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you set up a new MySQL database and activate an application manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. Besides the outstanding database crash recovery that InnoDB offers, we also make regular backups of all databases, so that we can swiftly recover any MySQL database in your shared 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 set up on our leading-edge cloud web hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our one-click application installer tool. In either case, the needed engine will be picked automatically the moment the installation of the app begins, so you won’t need to configure anything manually, no matter if the application requires InnoDB or the more widely used MyISAM. Also, we’ll always be able to retrieve any of your databases if you unintentionally remove one, as we generate a couple of backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the software pack that will be installed on your server before we give it to you. You will not have to configure anything manually and you will be able to install and use any PHP-based software app that needs InnoDB once your VPS is ready, which takes no more than one hour after the order submission process itself. Several engines are available, so every time you create a MySQL database using the Hepsia hosting Control Panel, a particular engine will be selected once the app installation commences and our system will automatically recognize which engine is required by the app in question. In case you have to use MyISAM, for instance, you will not have to do anything different than installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated servers that are ordered with the Hepsia Control Panel. It is included in the standard software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is ready, you will be able to sign in and to activate any type of PHP-based app that needs this MySQL storage engine. When you set up a new database through the Control Panel, there won’t be any active engine till you start installing an application. As soon as the app installation wizard begins entering content into the database, the engine will be picked automatically in accordance with the specific app’s requirements, so you can run both InnoDB and MyISAM without selecting either of them explicitly at any point. Therefore, you can make use of a wide collection of applications for your websites.