InnoDB is a database storage engine for MySQL relational databases, which is used by widely used script-powered applications such as Magento and Joomla 3. It’s perfect for scalable apps, as it performs amazingly well when managing huge amounts of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same period of time. What’s more, InnoDB offers a faster database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be treated. If a specific operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and will not be partially merged with newly imported content.

InnoDB in Shared Website Hosting

Every PHP script-powered web app that needs InnoDB will function flawlessly on our leading-edge cloud web hosting platform and the MySQL database storage engine comes with all our shared website hosting packages. Whenever you create a 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 prerequisites without having to change any setting in your account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We’ll keep daily backups of your content, so if you unintentionally remove a MySQL database that is important to you or you overwrite a certain part of it, we will be able to restore your database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the Control Panel offered with each of our semi-dedicated server accounts and you begin installing an open-source script-based web application either manually or using our one-click application installer tool, the storage engine for the MySQL database will be set automatically based on the given app’s requirements. Since InnoDB is present on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without any manual action needed on your end at any point. To avoid any chance of losing data if you update an application or if you remove a database unintentionally, we’ll make backups of all your databases each and every day, so if something goes wrong, we can restore your content.

InnoDB in VPS Servers

If our in-house built Hepsia hosting Control Panel is picked during the signup process for your new VPS web hosting plans , InnoDB will be activated on the VPS server along with other essential pieces of software, so you will not need to do anything if you decide to install script-powered apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new database and start the app installation manually or through our 1-click installer tool. The system will recognize which engine the app in question requires and will set it for the specific database, so the installation will proceed flawlessly and the app can import its content into that database. Therefore, you can run applications with various prerequisites in regard to the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s an integral part of the standard software package that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to activate a various PHP-driven app that requires this storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard begins inserting information into the database, the engine will be set automatically in accordance with the prerequisites of the specific application, so you can run both InnoDB and MyISAM without the need to select either one of them explicitly at any point. In this way, you can use a broad range of apps for your websites.