InnoDB is a database storage engine for MySQL databases, which is used by widely used open-source script-driven software apps such as Magento and Joomla 3.x. It is ideal for scalable applications, as it performs very well when handling huge data volumes. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. Plus, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – rules that determine how data inserts and updates should be treated. In case a particular operation has not been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay intact and will not be partially merged with newly appended content.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it’s an integral part of the default set of services offered with our website hosting packages. If you wish to use a PHP-based application that needs InnoDB particularly, in order to be activated and to work properly, you won’t face any obstacles because the database engine is available on our custom cloud web hosting platform. Regardless of whether you create a brand new database and activate an application manually or make use of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs it rather than MyISAM. Besides the remarkable database crash recovery that InnoDB is offering, we also perform regular database backups, so that we can quickly recover any database in your shared account.

InnoDB in Semi-dedicated Servers

You can install a PHP script-powered software app that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our advanced cloud hosting platform where the MySQL storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our 1-click application installer tool. In either case, the needed engine will be picked automatically the moment the activation of the app starts, so you won’t need to modify anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. On top of that, we will always be able to restore any of your databases if you accidentally remove one, as we create a couple of database backups every day, each of which is stored for seven days.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options that you can pick on the order form when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it is rather likely that you will run popular sites that will draw many visitors, and since InnoDB is among the very best choices for such sites, we will activate it together with all the other software applications that are available with a Hepsia-managed server. When you create a new database in your dedicated account, there won’t be any activated storage engine until you start installing a script, whether manually via your browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The necessary engine will be detected automatically and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to cope with any impediment.