InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many web developers that create highly scalable web applications, since it works much better with enormous volumes of data, while it keeps the server load at a minimum. In addition, it it locks only one row in the database if any info should be edited, while lots of other engines lock the entire database table and therefore require more time to handle multiple consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla™ releases are two examples of popular open-source script-driven web apps which have moved to InnoDB.

InnoDB in Shared Website Hosting

Every PHP-based web application that needs InnoDB will function impeccably on our advanced cloud web hosting platform and the database engine is available with all our shared website hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to update any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll perform regular content backups, so in case you accidentally remove a database that’s important to you or you overwrite some part of it, we’ll be able to restore your database the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated hosting plans by default, so once you obtain a new account, you can move on and install any PHP-driven software app that needs the database storage engine. A number of engines are installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected in accordance with the prerequisites of the application in question. This will allow you to activate and run InnoDB-specific applications without experiencing any problem and without editing any settings in your account. To be on the safe side, we’ll always keep a seven-day-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly retrieve it.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is selected during the signup process for your new VPS hosting plans , InnoDB will be activated on the Virtual Private Server along with other required software, so you will not have to do anything if you choose to install PHP-powered software applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a brand-new MySQL database and begin installing the application manually or through our single-click installation tool. The system will recognize which engine the application in question requires and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can import its content into that database. Thus, you can install applications with various prerequisites regarding the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so once your physical machine is ready, you will be able to sign in and to activate any PHP script-driven web app that requires this particular storage engine. When you create a new database via the Control Panel, there won’t be any activated engine until you start installing an application. Once the app setup wizard starts dumping information in the newly created database, the engine will be selected automatically depending on the requirements of the particular application, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any point. Thus, you can use a wide range of applications for your Internet sites.