InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of web developers that build scalable web apps, because it works more efficiently with enormous data volumes, while it keeps the server processing load low. What’s more, it locks only a single database row if any information should be modified, while many other engines lock the entire table and therefore require much more time to execute multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest Joomla™ editions are two examples of widespread script-based web apps which have moved to InnoDB.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-powered app that requires the database engine without having any problem once you open your account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation, no matter if you make use of our single-click installer or create the MySQL database and install the application manually, as long as the application requires it instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can be sure that you’ll never lose any content in case you delete a database unintentionally or you overwrite some key info – you’ll simply need to contact us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to use all the features offered by this database engine with any open-source script-powered software application that requires it. InnoDB is among the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the given application. You will not need to do anything manually to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To be on the safe side, we will generate daily MySQL database backups, so if anything goes wrong following some update or if you erase some content unintentionally, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server along with other needed pieces of software, so you will not need to do anything if you choose to use script-based software applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a brand new database and begin the app installation process manually or through our one-click installation tool. The system will automatically recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation will proceed impeccably and the app can import its content into that database. Therefore, you can make use of applications with various requirements with regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features which you can select on the order page when you purchase a dedicated server from our company. As this is the most powerful kind of hosting, it’s quite likely that you’ll run popular websites that will attract a lot of individuals, and since InnoDB is among the very best choices for such sites, we will install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. If you create a new database in your dedicated account, there won’t be any active MySQL storage engine till you begin installing an open-source script, whether manually via your Internet browser or using the automatic scripts installer tool that is available in the hosting Control Panel. The necessary engine will be detected and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having to cope with any difficulty.