InnoDB is a popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got a lot of upsides which make it the engine of choice for many open-source script-based web applications, among them Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing large data volumes will be faster with InnoDB, as it locks only a single database row to perform a specific operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. In simpler words, importing new or modifying existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a certain problem occurs during the process, hence the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

InnoDB is available with all our Linux cloud hosting service by default, not upon request or as a paid upgrade, so you will be able to activate and run any script-driven software app which requires the database storage engine without the need to deal with any complication once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, no matter if you make use of our one-click installer or create the MySQL database and install the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll store daily database backups, so you can rest assured that you will never lose any data if you delete a database unintentionally or you overwrite some crucial info – you simply have to touch base with us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated service come with InnoDB and you will be able to make the most of all the options offered by this MySQL database storage engine with any PHP-driven software app that requires it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the requirements of the app in question. You will not have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we will create daily backups of all your databases, so if something goes wrong after some update or if you remove some data by accident, we’ll be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you purchase a VPS server from our company, you’ll be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to manage any open-source script-driven web app which needs InnoDB, as this database storage engine is included in the default software package that will be installed on the VPS server during its configuration. When you set up a brand new MySQL database using the Control Panel, you’ll just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine as long as the application in question needs it, so you won’t have to do anything else in your account. Likewise, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you’ll be able to pick one of the three hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to add this MySQL database storage engine manually in order to be able to run script-based software applications that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you need in order to run very large Internet sites, it is rather possible that you will resort to InnoDB. You will be able to make use of other engines too, so in case a certain app requires MyISAM instead of InnoDB, you will not run into any problem while managing it. The engine that will be used will be recognized automatically the moment the app installation starts, so you won’t need to alter any settings manually at any time.