InnoDB is a database engine for MySQL relational databases, which is used by popular script-driven software applications such as Magento and Joomla™ 3.x. It is excellent for scalable applications, since it works stunningly well when processing 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 database row, so it can execute a lot more operations for the same period of time. Besides, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be treated. If a particular operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and will not be partially merged with newly imported content.
InnoDB in Hosting
InnoDB is available with all our hosting packages by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any script-powered software app which needs the database storage engine without having any difficulty once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, regardless of whether you make use of our 1-click installation tool or create the database and activate the application manually, as long as the app requires it instead of the more popular MyISAM engine. We will keep daily MySQL database backups, so you can be certain that you’ll never lose any data in case you erase a database by mistake or you overwrite some essential information – you just need to notify us and we will restore the database back to normal.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting include InnoDB and you will be able to make the most of all the features offered by this MySQL storage engine with any open-source script-powered application that needs it. It is one of the engines that are available on our cloud platform, so the one that will be used depends on the requirements of the given app. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we will create regular backups of all your MySQL databases, so if anything goes wrong following some update or if you remove some data unintentionally, we’ll be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS
All Linux VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to use any open-source script-based software app that requires this MySQL database engine without having to install anything manually. You can select Hepsia on the VPS order form and your new server will be set up within 60 minutes, so you can sign in and begin building your Internet sites right away. Once you set up a brand-new MySQL database and begin the app installation process, our system will set the engine for this MySQL database automatically. In this way, you can run various applications at the same time without editing anything on the Virtual Private Server. You can set up a WordPress-based blog that makes use of MyISAM – the default MySQL engine, and a Magento-based online shopping portal that uses the InnoDB engine, for example.
InnoDB in Dedicated Hosting
InnoDB is included as standard with all dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s included in the default software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is ready, you will be able to sign in and to activate any type of open-source script-driven app that needs this particular storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you begin installing an app. Once the app configuration wizard begins dumping content in the database, the engine will be selected automatically in accordance with the prerequisites of the respective application, so you can run both InnoDB and MyISAM without the need to select either one of them explicitly at any point. Therefore, you can use a huge collection of applications for your Internet sites.