InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a lot of upsides that have made it the preferred engine for plenty of script-powered software apps, including Joomla and Magento, which have shifted over to InnoDB permanently. For instance, adding large volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a given task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. In simpler words, importing new or updating existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if a certain problem appears in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it is included in the default set of services that we’re offering with our cloud web hosting plans. In case you would like to use an open-source script-powered web application that requires InnoDB particularly, in order to be activated and to function correctly, you will not encounter any difficulties because the storage engine is available on our custom-developed cloud Internet hosting platform. Regardless of whether you create a brand-new database and activate an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the application requires it rather than MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also maintain regular database backups, so that we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can install a PHP script-driven software application that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud web hosting platform where the MySQL database engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our single-click app installer tool. Either way, the needed engine will be picked automatically once the application’s installation begins, so you will not have to modify anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to restore any of your MySQL databases in case you remove one by accident, as we create a few database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS

All VPS services that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to take advantage of any open-source script-driven software application that needs this storage engine without needing to install anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be set up within 1 hour, so you can log in and start building your web sites right away. When you set up a new MySQL database and start the app activation process, our system will choose the engine for this database automatically. In this way, you can manage different applications simultaneously without the need to edit anything on the server. You can create a WordPress-based online blog that uses MyISAM – the default MySQL engine, and a Magento-powered online shop that makes use of InnoDB, for example.

InnoDB in Dedicated Hosting

When you purchase a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to enable this database engine manually in order to be able to manage script-powered software apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you require to manage very large sites, it is quite possible that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain application requires MyISAM instead of InnoDB, you won’t need to deal with any difficulty while using it. The engine that will be used will be recognized automatically once the app installation begins, so you won’t have to fine-tune any setting manually at any time.