InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has numerous advantages which have made it the engine of choice for lots of script-based software apps, including Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing large volumes of data will be much faster with InnoDB, due to the fact that it locks only one row to accomplish a particular task, 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 manner in which the information is handled. To put it simply, importing new or editing existent data will either be fully completed, or will be annulled and the operation will be rolled back if some problem occurs in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any open-source script-powered software application which requires the MySQL storage engine without having to deal with any impediment once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation, no matter if you make use of our single-click installer or create the MySQL database and install the app manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll store daily backups of all your databases, so you can be sure that you will never lose any content if you delete a database accidentally or you overwrite some key information – you’ll just have to inform us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-based web application that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our avant-garde cloud platform where the database engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our 1-click app installer. In either case, the required engine will be chosen automatically the moment the app’s installation starts, so you won’t need to change anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Also, we will always be able to restore any of your MySQL databases if you delete one by accident, as we make a couple of backups every day, each of which is saved for seven days.

InnoDB in VPS Hosting

When you obtain a virtual private server from our company, you’ll be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to run any PHP script-driven software app that needs InnoDB, as the storage engine is part of the standard 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 begin installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not have to do anything else in your VPS account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Web Hosting

All dedicated web hosting that are ordered with our custom-built Hepsia Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t need to activate it manually if you wish to activate PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup – once the installer wizard accesses the database and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to use scripts that require MyISAM, the other widely used MySQL engine, so you will not have to edit any settings on the dedicated server. This will permit you to run various scripts on a single physical server and to use the latter to its fullest potential.