InnoDB is a database storage engine for MySQL databases, which is used by popular PHP-based applications like Magento and Joomla 3. It is ideal for scalable apps, because it performs incredibly well when managing huge data volumes. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same period of time. In addition, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and updates should be handled. In case a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially mixed with newly added content.

InnoDB in Cloud Hosting

Every PHP script-based application that requires InnoDB will function impeccably on our cutting-edge cloud platform and the MySQL storage engine is offered with all our cloud hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to update any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full potential. We’ll maintain regular backups of your content, so in case you accidentally remove a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore your content the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

You can use an open-source script-driven web application that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are created on our innovative cloud hosting platform where the storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our one-click application installer. In either case, the needed engine will be chosen automatically once the activation of the app begins, so you won’t need to configure anything manually, no matter if the application needs InnoDB or the more widely used MyISAM. Also, we will always be able to restore any of your databases in case you unintentionally remove one, as we carry out a couple of backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

If our in-house developed Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be installed on the server along with other needed pieces of software, so you won’t have to do anything if you choose to make use of PHP-driven web apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new database and begin installing the app manually or using our 1-click installer. The system will automatically recognize which engine the particular application needs and will assign it to the specific database, so the installation will continue flawlessly and the app can dump its data in that database. Therefore, you can use apps with various requirements in regard to the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can pick on the order page when you buy a dedicated server from our company. Since this is the most powerful type of website hosting, it is rather likely that you’ll manage highly popular Internet sites that will attract a lot of visitors, and since InnoDB is one of the best options for such sites, we will install it together with all the other software apps that are offered with a Hepsia-managed server. If you set up a new MySQL database in your dedicated account, there won’t be any active MySQL database engine till you begin installing a script, whether manually through your web browser or using the automatic script installer tool that is available in the Control Panel. The required engine will be automatically recognized and will be set for that database, so you can use scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having to deal with any impediment.