InnoDB is a storage engine for MySQL relational databases, which is used by widely used script-based software apps like Joomla 3.x and Magento. It’s excellent for scalable apps, since it performs astonishingly well when managing large data volumes. Rather than locking the whole table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can complete much more operations for the same period of time. Moreover, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – rules that define how data imports and updates should be handled. If a given operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will be retained intact and will not be partially merged with new content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an essential part of the default set of services that we are offering with our cloud hosting packages. In case you would like to make use of a PHP script-driven software app that requires InnoDB specifically, in order to be installed and to work properly, you won’t have any impediments since the MySQL database engine is available on our in-house built cloud platform. No matter if you set up a brand-new database and install an app manually or take advantage of our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular application needs it instead of MyISAM. Besides the outstanding crash recovery offered by InnoDB, we also maintain regular backups of all databases, so that we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated servers by default, so the moment you get a new account, you can go ahead and install any PHP-based software application that needs the MySQL storage engine. A couple of engines are installed on our cloud website hosting platform, so when you set up a brand-new database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be chosen depending on the requirements of the specific application. This will allow you to activate and run InnoDB-specific applications without having to deal with any difficulty and without changing any settings in your account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you remove or change any content accidentally, we can quickly restore it.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is chosen during the signup process for a new VPS hosting plans , InnoDB will be installed on the VPS server together with other required pieces of software, so you won’t have to do anything if you choose to install open-source script-driven web apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand new database and start installing the app manually or using our 1-click installer. The system will detect which engine the particular app requires and will set it for the specific MySQL database, so the installation process will continue flawlessly and the app can enter its content into that database. Therefore, you can make use of applications with different prerequisites about the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can select on the server configuration page when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it is rather likely that you’ll run highly popular sites that will attract a lot of individuals, and since InnoDB is among the best options for such Internet sites, we will activate it together with all the other software applications that come with a Hepsia-managed dedicated server. When you create a new MySQL database in your dedicated server account, there won’t be any activated database storage engine till you begin installing an open-source script, whether manually via your web browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The required engine will be detected and will be assigned to that database, so you can run scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without any problem.