InnoDB is a database engine for MySQL relational databases, which is used by widespread open-source script-powered web apps like Magento and Joomla™ 3.x. It’s excellent for scalable applications, as it works amazingly well when processing large volumes of data. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same length of time. Additionally, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. If a particular task has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be retained intact and won’t be partially merged with newly imported content.

InnoDB in Hosting

InnoDB is available with all our Linux hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any PHP-based software application that needs the MySQL storage engine without the need to deal with any problem once you open your account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, regardless of whether you use our 1-click installation tool 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 maintain daily backups of all your databases, so you can be certain that you won’t ever lose any content in case you erase a database unintentionally or you overwrite some vital info – you will just need to alert us and we will restore your content the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our semi-dedicated hosting by default, so as soon as you get a new account, you can move on and activate any script-powered web app that requires this MySQL storage engine. A few engines are installed on our cloud website hosting platform, so when you set up a brand-new MySQL database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be set depending on the prerequisites of the specific application. This will allow you to install and manage InnoDB-specific apps without needing to cope with any obstacle and without needing to change any settings in your account. To be on the safe side, we will always have a seven-day-old backup of all your databases, so if you delete or alter any content by accident, we can swiftly recover it.

InnoDB in VPS

If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the default software bundle that will be installed on your VPS server before we hand it over to you. You won’t need to activate anything manually and you’ll be able to enable and use any PHP script-powered web app that requires InnoDB when your VPS is set up, which takes no more than one hour after the order procedure itself. A couple of engines are offered, so anytime you create a database using the Hepsia hosting Control Panel, a specific engine will be picked once the app activation process commences and our system will automatically detect which engine is required by the application in question. If you need MyISAM, for example, you will not have to do anything different from installing the chosen app, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

Our Hepsia hosting Control Panel is among the options which you can choose on the server order page when you purchase a dedicated server from us. Since this is the most powerful kind of hosting, it’s quite likely that you will manage very popular sites that will attract many visitors, and since InnoDB is one of the very best choices for such websites, we’ll enable it along with all the other software applications that come with a Hepsia-managed server. If you create a brand-new MySQL database in your account, there won’t be any active MySQL database storage engine until you begin installing an open-source PHP script, whether manually via your Internet browser or using the automatic scripts installer that is available in the Control Panel. The needed engine will be automatically detected and will be assigned to that database, so you can run scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to deal with any problem.