InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous strengths that have made it the engine of choice for a lot of open-source script-based web apps, such as Joomla and Magento, which have moved to InnoDB for good. For instance, adding enormous volumes of data will be much faster with InnoDB, as it locks only a single database row to carry out an operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is tackled. Put simply, adding new or editing existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case some issue appears in the meantime, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP-driven app which requires the database storage engine without encountering any obstacle once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation, regardless of whether you use our 1-click installer or create the MySQL database and set up the application manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll perform daily MySQL database backups, so you can be sure that you’ll never lose any content if you erase a database accidentally or you overwrite some vital information – you’ll just need to contact us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can install a PHP script-powered software app that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click app installer. Either way, the required engine will be chosen automatically the moment the application’s activation starts, so you will not have to modify anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases in case you unintentionally delete one, as we create several database backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

When you purchase a VPS server from us, you’ll be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to manage any open-source script-based app that requires InnoDB, as this particular MySQL storage engine is an integral part of the default software bundle that will be installed on the server during its setup. When you create a brand new database through the Control Panel, you’ll simply have to start installing an app – manually or using our app installer. InnoDB will be set as the default engine as long as the app in question needs it, so you won’t have to do anything else in your VPS account. Likewise, if a given application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All dedicated service that are ordered with our in-house built Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t need to add it manually in case you need to use open-source PHP scripts that require it. All it takes to install such a script is to create a new database and to start the installation process – as soon as the installer wizard acquires access to the database in question and begins inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you will not have to update any settings on the dedicated server. This will enable you to use various scripts on one single machine and to use the latter to its full capacity.