InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-powered applications such as Magento and Joomla 3.x. It is excellent for scalable applications, because it performs stunningly well when handling huge amounts of data. Rather than locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and modifications should be treated. In case a specific task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will stay intact and will not be partially merged with newly added content.

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 install and run any PHP script-driven web app that needs the MySQL database storage engine without having any problem as soon as you activate your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, irrespective of whether you take advantage of our 1-click installation tool or create the MySQL database and set up the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will perform regular backups of all your databases, so you can be certain that you won’t ever lose any content if you erase a database unintentionally or you overwrite some key info – you will just have to alert us and we will restore your content back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our Linux semi-dedicated servers by default, so as soon as you purchase a new account, you can go ahead and install any PHP script-driven application that needs this particular database storage engine. A number of engines are pre-installed on our cloud platform, so when you create a new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be chosen based on the requirements of the particular app. This will allow you to activate and run InnoDB-specific apps without needing to deal with any complication and without needing to change any settings in your account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you erase or edit any content accidentally, we can easily rescue it.

InnoDB in VPS Servers

When you purchase a VPS server from our company, you’ll be able to make use of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to install any script-driven web application that needs InnoDB, as this MySQL storage engine is included in the standard software package that will be pre-installed on the VPS server during its creation. When you create a brand new MySQL database via the hosting Control Panel, you just have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your account. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features that you can select on the order form when you buy a dedicated server from us. As this is the most powerful kind of hosting, it is pretty likely that you’ll manage popular sites that will attract lots of people, and since InnoDB is one of the very best choices for such websites, we’ll install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. When you create a brand-new MySQL database in your account, there won’t be any active database storage engine till you start installing an open-source script, whether manually through your Internet browser or using the automatic script installation tool that is available in the hosting Control Panel. The needed engine will be detected and will be set for the database in question, so you can make use of scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without needing to cope with any impediment.