InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous strong sides that make it the preferred engine for lots of open-source script-driven software applications, including Joomla™ and Magento, which have moved to InnoDB for good. For example, adding enormous data volumes will be much faster with InnoDB, since it locks only one row to execute a certain task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, importing new or editing existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back if a given problem occurs during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

InnoDB is offered with all our Linux website hosting packages by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP script-driven software app which needs the MySQL storage engine without having to deal with any problem as soon as you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, irrespective of whether you make use of our one-click installer or create the database and install the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll carry out regular backups of all your MySQL databases, so you can be certain that you’ll never lose any content in case you delete a database by accident or you overwrite some important info – you’ll just need to notify us and we will restore the database the way it was.

InnoDB in Semi-dedicated Hosting

You can install a PHP-based web application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our avant-garde cloud web hosting platform where the storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our one-click app installer. Either way, the required engine will be chosen automatically the moment the app’s activation starts, so you will not have to edit anything manually, no matter if the application requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your databases in case you unintentionally erase one, as we perform a couple of database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS

If you obtain a virtual private server from us, you will be able to make use of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to install any open-source script-driven application which needs InnoDB, as this database storage engine is an essential part of the default software package that will be pre-installed on your server during its setup. When you create a brand-new database using the Control Panel, you’ll simply need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the application in question requires it, so you won’t have to do anything else in your account. In the same manner, if a given application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is among the options which you can pick on the server configuration page when you buy a dedicated server from us. As this is the most powerful type of web hosting, it’s rather likely that you will manage highly popular sites that will attract a lot of individuals, and since InnoDB is one of the very best options for such sites, we’ll install it together with all the other software apps that come with a Hepsia-equipped server. If you set up a brand-new MySQL database in your account, there won’t be any active database storage engine until you start installing a script, whether manually through your web browser or using the automatic script installer tool that is available in the hosting Control Panel. The necessary engine will be recognized and will be assigned to that database, so you can make use of scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having to deal with any difficulty.