InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-based software apps like Magento and Joomla 3. It is perfect for scalable applications, as it works unbelievably well when handling immense volumes of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same length of time. Also, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be handled. If a specific operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will stay intact and won’t be partially merged with newly added content.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with other web hosting providers, it is included in the standard set of features that we’re offering with our shared hosting packages. If you want to use a script-powered application that needs InnoDB in particular, in order to be activated and to function properly, you will not need to deal with any difficulties since the MySQL database engine is available on our custom cloud platform. Irrespective of whether you create a brand new database and activate an application manually or use our one-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the particular application requires InnoDB instead of MyISAM. In addition to the exceptional crash recovery offered by InnoDB, we also perform regular database backups, so that we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans support InnoDB and you will be able to take full advantage of all the options offered by this storage engine with any script-based software application that requires it. It is one of the engines that are available on our cloud hosting platform, so the one that will be used depends on the prerequisites of the particular app. You will not need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer tool. To avoid any risk, we will perform daily backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you delete some data unintentionally, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

When you purchase a VPS server from our company, you’ll be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to use any script-powered app that needs InnoDB, as the MySQL database engine is an integral part of the software package that will be pre-installed on your Virtual Private Server during its configuration. When you create a brand new database via the Control Panel, you will just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question needs it, so you won’t need to do anything else in your VPS account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

InnoDB is included as standard with all Linux dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It’s an integral part of the default software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your machine is assembled, you’ll be able to log in and to activate a various PHP script-based web app that needs this MySQL database engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app activation wizard begins inserting data into the newly created database, the engine will be chosen automatically in accordance with the particular app’s requirements, so you can run both InnoDB and MyISAM without selecting either one explicitly at any time. Thus, you can use an immense collection of apps for your sites.