InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and an improved crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by many programmers that write highly scalable web applications, since it works more effectively with enormous data volumes, while it keeps the server load low. What’s more, it it locks only one row in the database if anything should be updated, while lots of other engines lock the entire database table and hence need much more time to process multiple consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ releases are two examples of widely used PHP-powered software apps which have switched over to InnoDB.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any open-source script-driven software application that needs the InnoDB database storage engine without the need to deal with any difficulty once you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, no matter if you use our one-click installer or create the MySQL database and set up the application manually, provided that the application requires it instead of the more famous MyISAM engine. We will maintain daily backups of all your MySQL databases, so you can be sure that you will never lose any content if you delete a database unintentionally or you overwrite some essential info – you will simply need to notify us and we will restore the database the way it was.

InnoDB in Semi-dedicated Hosting

You can use an open-source script-driven software application that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud web hosting platform where the database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our one-click application installer. In either case, the required engine will be selected automatically once the app’s activation starts, so you won’t have to edit anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your databases if you accidentally remove one, as we generate several backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia hosting Control Panel is chosen during the signup process for your new Linux virtual private servers , InnoDB will be installed on the server along with other essential pieces of software, so you will not need to do anything if you choose to install open-source script-driven software apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a new MySQL database and begin the app installation manually or using our 1-click installer tool. The system will detect which engine the app in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can enter its content into that database. In this way, you can use applications with different prerequisites in regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

InnoDB is included as standard with all Linux dedicated servers hosting that are ordered with the Hepsia Control Panel. It is an integral part of the software bundle that we install on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to log in and to install any kind of script-based web application that requires this particular MySQL database storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you start installing an application. As soon as the app installation wizard begins importing content into the newly created database, the engine will be selected automatically depending on the prerequisites of the particular application, so you can use both MyISAM and InnoDB without selecting either one specifically at any time. Thus, you can use a huge range of applications for your websites.