InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got a lot of advantages which make it the preferred engine for lots of script-powered applications, including Joomla and Magento, which have switched to InnoDB for good. For example, importing enormous volumes of data will be much faster with InnoDB, because it locks only a single row to perform a specific operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is handled. Simply put, adding new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back if some issue shows up during the process, thus the content that remains in the database will not be damaged.

InnoDB in Shared Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting companies, it is an integral part of the default set of features offered with our shared web hosting plans. In case you would like to use a PHP-driven software application that needs InnoDB particularly, in order to be activated and to work properly, you will not come across any difficulties as the database storage engine is available on our in-house developed cloud hosting platform. No matter if you create a new database and install an app manually or use our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective application needs it rather than MyISAM. Besides the remarkable database crash recovery that InnoDB is offering, we also generate daily backups of all databases, so that we can easily restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can use a PHP script-based software app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our one-click application installer tool. In either case, the needed engine will be picked automatically once the application’s activation begins, so you will not have to edit anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to restore any of your MySQL databases if you unintentionally remove one, as we perform a couple of MySQL database backups every day, each of which is kept for one whole week.

InnoDB in VPS

When you get a virtual private server from our company, you will be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will permit you to use any PHP-powered software application that requires InnoDB, as this particular storage engine is an essential part of the standard software package that will be installed on your Virtual Private Server during its creation. When you create a brand-new MySQL database through the hosting Control Panel, you’ll simply need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the app in question requires it, so you won’t have to do anything else in your VPS account. Correspondingly, if a given app requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Hosting

When you acquire a new dedicated server, you will be able to choose any of the three hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this database storage engine manually so as to be able to run PHP-powered applications that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need to run large-size sites, it is pretty likely that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a specific app requires MyISAM rather than InnoDB, you won’t come across any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation begins, so you will not have to alter any setting manually at any time.