InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster database failure recovery in comparison with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by numerous programmers that run scalable web apps, since it works much more efficiently with immense amounts of data, while it keeps the server load at a minimum. Furthermore, it it locks only one row in the database in case any information should be updated, whereas many other engines lock the entire database table and therefore need much more time to carry out multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid confusion or losing data. Magento and the latest releases of Joomla™ are two examples of widely used PHP script-powered software apps that have switched to InnoDB.

InnoDB in Hosting

InnoDB is offered with all our Linux hosting service by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any script-based application which requires the MySQL storage engine without any difficulty once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, no matter if you take advantage of our one-click installation tool or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will make regular backups of all your databases, so you can be sure that you won’t ever lose any data if you delete a database by accident or you overwrite some vital information – you’ll just have to alert us and we will restore the database back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our Linux semi-dedicated servers by default, so the moment you purchase a new account, you can go on and install any script-based software app that requires this particular database engine. A number of engines are installed on our cloud hosting platform, so when you set up a brand-new database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be picked depending on the concrete app’s requirements. This will allow you to install and manage InnoDB-specific apps without needing to deal with any obstacle and without needing to update any settings in your account. To take no chances, we will always keep a one-week-old backup of all your MySQL databases, so if you remove or change any content by mistake, we can easily retrieve it.

InnoDB in VPS Servers

In case our custom Hepsia Control Panel is chosen during the signup process for your new VPS servers , InnoDB will be installed on the VPS server together with other essential pieces of software, so you won’t need to do anything if you choose to use script-powered applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a brand new MySQL database and begin the app installation manually or through our 1-click installer. The system will detect the engine that the particular application needs and will set it for the specific database, so the installation will proceed impeccably and the application can insert its content into that database. Therefore, you can make use of applications with different requirements with regard to the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Servers

InnoDB is included by default with all Linux dedicated service ordered with the Hepsia Control Panel. It’s an integral part of the default software package that we install on all Hepsia-equipped dedicated servers, so once your machine is assembled, you’ll be able to sign in and to activate any type of open-source script-powered web application that requires this particular MySQL storage engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app activation wizard starts importing content into the newly created database, the engine will be picked automatically in accordance with the prerequisites of the specific app, so you can run both MyISAM and InnoDB without selecting either one explicitly at any time. Thus, you can use a vast variety of applications for your Internet sites.