InnoDB is a database storage engine for MySQL databases, which is used by well known script-based web apps like Joomla™ 3.x and Magento. It’s ideal for scalable apps, since it excels in handling enormous amounts of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. What’s more, InnoDB offers a much faster database crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be treated. In case a specific operation has not been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it’s part of the default set of features that we offer with our shared hosting packages. In case you want to make use of a script-driven web application that requires InnoDB specifically, in order to be activated and to operate correctly, you won’t face any problems since the InnoDB storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand new database and install an application manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires InnoDB rather than MyISAM. In addition to the exceptional database failure recovery that InnoDB is offering, we also keep daily database backups, so that we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels offered by our company – Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this database engine manually in order to be able to use script-powered apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the server resources that you require to manage very large Internet sites, it is rather possible that you’ll use InnoDB. You will be able to make use of other engines too, so if a given application requires MyISAM instead of InnoDB, you won’t experience any difficulty while running it. The engine that will be used will be detected automatically when the app installation process starts, so you won’t have to tweak any setting manually at any moment.