InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got a lot of upsides which have made it the preferred engine for numerous PHP script-powered web applications, such as Magento and Joomla, which have switched to InnoDB for good. For example, adding huge volumes of data will be faster with InnoDB, because it locks only one row to perform a particular operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. Simply put, importing new or editing existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case some issue shows up in the meantime, therefore the content that remains in the database will not be damaged.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-based web application that requires the InnoDB database storage engine without having any problem as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation, regardless of whether you make use of our single-click installer or create the MySQL database and set up the app manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will carry out daily MySQL database backups, so you can be certain that you’ll never lose any data if you delete a database unintentionally or you overwrite some important info – you’ll just have to touch base with us and we will restore the database the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you can use all the options offered by this storage engine with any open-source script-driven software application that needs it. It is one of the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the specific app. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To avoid any risk, we will generate daily MySQL database backups, so if anything goes wrong after some update or if you erase some content by accident, we’ll be able to restore your database the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options which you can choose on the order page when you buy a dedicated server from our company. Since this is the most powerful type of website hosting, it is rather likely that you’ll manage very popular Internet sites that will attract plenty of visitors, and since InnoDB is one of the best options for such websites, we will enable it together with all the other software apps that are available with a Hepsia-equipped dedicated server. When you set up a brand new database in your dedicated server account, there won’t be any activated MySQL storage engine till you start installing a PHP script, whether manually via your web browser or using the automatic scripts installer tool that is included in the Control Panel. The needed engine will be detected and will be set for the database in question, so you can install scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without any complications.