InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got numerous advantages that make it the engine of choice for plenty of PHP script-based applications, including Magento and Joomla, which have switched over to InnoDB for good. For example, importing huge volumes of data will be much faster with InnoDB, as it locks only one row to carry out a particular operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is handled. Simply put, importing new or modifying existent data will either be entirely completed, or will be annulled and the operation will be rolled back if any problem occurs in the meantime, which means that the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any open-source script-based software app which needs the InnoDB storage engine without the need to deal with any problem as soon as you open your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation process, regardless of whether you make use of our 1-click installer or create the database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll store daily backups of all your databases, so you can be certain that you will never lose any content in case you erase a database unintentionally or you overwrite some essential info – you’ll just have to alert us and we will restore your data the way it was.

InnoDB in Semi-dedicated Servers

You can activate a script-based web app that needs InnoDB with all of our semi-dedicated server plans, because all the accounts are set up on our innovative cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our 1-click application installer tool. Either way, the required engine will be selected automatically as soon as the activation of the app begins, so you will not need to change anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to restore any of your MySQL databases if you remove one by mistake, as we perform several database backups every day, each of which is kept for one week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to run any PHP script-driven app that needs the MySQL storage engine without having to install anything manually. You can choose Hepsia on the VPS order form and your brand-new server will be up and running within one hour, so you can log in and begin creating your sites right away. When you set up a brand-new MySQL database and begin the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can make use of various applications at the same time without modifying anything on the server. You can set up a WordPress personal journal that makes use of MyISAM – the default MySQL engine, and a Magento shopping portal that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t need to activate it manually in case you would like to run open-source scripts that require it. All it takes to install such a script is to create a new database and to start the installation – as soon as the script configuration wizard receives access to the database in question and begins dumping data in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you won’t need to change any settings on the server. This will allow you to install a variety of scripts on one single server and to use it to its maximum capabilities.