InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has got a lot of advantages which make it the preferred engine for lots of open-source script-driven applications, such as Magento and Joomla, which have switched over to InnoDB for good. For instance, importing enormous data volumes will be faster with InnoDB, since it locks only one row to execute a particular task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. Simply put, adding new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case any problem shows up during the process, therefore the content that remains in the database won’t be damaged.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many other website hosting service providers, it’s an integral part of the standard set of services that we are offering with our web hosting packages. In case you would like to use a PHP-driven application that needs InnoDB in particular, in order to be activated and to perform properly, you won’t need to deal with any difficulties since the MySQL database storage engine is available on our custom-built cloud Internet hosting platform. Regardless of whether you set up a new MySQL database and install an application manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the particular app needs it instead of MyISAM. In addition to the excellent database crash recovery that InnoDB offers, we also maintain daily backups of all databases, so we can swiftly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

You can make use of an open-source script-powered software application that needs InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our leading-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our one-click application installer tool. Either way, the needed engine will be selected automatically the moment the app’s activation starts, so you will not have to edit anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to restore any of your databases if you erase one by mistake, as we make a few MySQL database backups every day, each of which is stored for 1 week.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is picked during the registration process for a new VPS web hosting plans , InnoDB will be activated on the VPS server together with other required pieces of software, so you won’t need to do anything if you choose to install PHP script-based apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin installing the application manually or using our single-click installation tool. The system will detect which engine the app in question needs and will assign it to the specific database, so the installation will continue impeccably and the application can insert its data into that database. Thus, you can make use of apps with various requirements about the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you’ll be able to pick any of the three Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to enable this database storage engine manually in order to be able to manage script-powered apps that need it. InnoDB is used by scalable applications and since a dedicated server will give you all the server resources that you need to run very large Internet sites, it’s very possible that you will resort to InnoDB. You will be able to make use of other engines as well, so if a specific application requires MyISAM instead of InnoDB, you won’t come across any complication while managing it. The engine that will be used will be automatically recognized when the app installation begins, so you won’t need to fine-tune any settings manually at any point.