InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of programmers that build highly scalable web applications, because it works more effectively with large amounts of data, while it keeps the server processing load low. Furthermore, it locks only a single row in the database in case any info should be edited, whereas many other engines lock the entire table and thus require much more time to process several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla editions are two instances of widely used open-source script-based software platforms that have switched to InnoDB.

InnoDB in Hosting

InnoDB is available with all our Linux hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any PHP-based web application which requires the database storage engine without having to deal with any problem once you order your account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, no matter if you use our one-click installer or create the database and set up the app manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will make daily backups of all your databases, so you can rest assured that you won’t ever lose any content in case you delete a database by mistake or you overwrite some vital info – you just need to inform us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated servers by default, so as soon as you purchase a new semi-dedicated account, you can go on and install any PHP-powered web application that needs the MySQL storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a new database and start installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected depending on the prerequisites of the particular app. This will permit you to install and run InnoDB-specific apps without any obstacle and without having to update any settings in your account. To be on the safe side, we’ll always have a seven-day-old backup of all your databases, so if you erase or change any content accidentally, we can swiftly recover it.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the server together with other needed pieces of software, so you won’t need to do anything if you choose to run PHP-based applications that need this MySQL storage engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a new database and start installing the app manually or using our one-click installation tool. The system will detect which engine the particular app needs and will set it for the specific database, so the installation process will proceed flawlessly and the application can insert its data into that database. In this way, you can manage applications with various requirements concerning the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB comes as standard with all Linux dedicated service ordered with the Hepsia hosting Control Panel. It is an essential part of the default software bundle that will be pre-installed on all Hepsia-equipped servers, so once your machine is set up, you will be able to log in and to install a various PHP script-powered web app that needs this MySQL database engine. If you create a new database through the Control Panel, there won’t be any activated engine till you begin installing an application. As soon as the app setup wizard starts importing content into the newly created database, the engine will be picked automatically on the basis of the requirements of the particular application, so you can run both MyISAM and InnoDB without having to select either one explicitly at any moment. Therefore, you can use an extensive range of apps for your websites.