InnoDB is a database engine for MySQL databases, which is used by widespread script-based applications like Joomla v3 and Magento. It is perfect for scalable applications, because it works amazingly well when handling huge data volumes. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. Plus, InnoDB offers a much better database failure recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and updates should be treated. If a certain operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will stay undamaged and won’t be partially merged with newly added content.

InnoDB in Shared Website Hosting

Every PHP script-driven application that needs InnoDB will run flawlessly on our innovative cloud web hosting platform and the storage engine comes with all our shared website hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to configure any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We’ll make regular backups of your content, so if you unintentionally erase a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore everything the way it was just several hours ago.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the Control Panel offered with all our semi-dedicated server plans and you begin installing a script-powered software app either manually or using our single-click application installer tool, the storage engine for the MySQL database will be picked automatically on the basis of the prerequisites of the app in question. As InnoDB is available on the cloud platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that needs it without any manual action needed on your end at any moment. To avoid any risk of losing information if you update an application or if you remove a database unintentionally, we’ll carry out backups of all your MySQL databases each and every day, so if something happens, we can rescue your data.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an integral part of the software package that will be pre-installed on your VPS server before we give it to you. You won’t have to configure anything manually and you’ll be able to install and run any script-powered web app that requires InnoDB when your Virtual Private Server is ready, which takes no more than 1 hour after the order process itself. Several engines are available, so anytime you create a MySQL database using the Hepsia hosting Control Panel, a specific engine will be selected when the app activation process starts and our system will automatically detect the engine that is required by the app in question. If you need MyISAM, for example, you will not need to do anything different than installing the chosen app, whether manually or using our app installer.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can select on the order form when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it is quite likely that you’ll manage popular Internet sites that will attract many people, and since InnoDB is among the best options for such sites, we will enable it together with all the other software apps that come with a Hepsia-managed server. If you set up a brand-new database in your dedicated server account, there won’t be any active MySQL database engine until you begin installing a PHP script, whether manually through your browser or using the automatic scripts installer that is included in the Control Panel. The required engine will be recognized and will be set for the database in question, so you can use scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having any impediment.