InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by a lot of developers that create scalable apps, because it works better with enormous amounts of data, while it keeps the server load low. Additionally, it locks only a single row in the database if any info should be modified, while many other engines lock the entire table and therefore need much more time to handle multiple successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla versions are two examples of widespread open-source script-based web applications which have shifted over to InnoDB.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia Control Panel is chosen during the registration process for a new Linux VPS web hosting packages , InnoDB will be installed on the server along with other necessary software, so you will not have to do anything if you decide to use PHP-driven web applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a new database and begin the app installation manually or using our single-click installation tool. The system will automatically detect which engine the application in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can import its data into that database. In this way, you can install apps with various requirements concerning the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

When you get a new dedicated server, you will be able to select any of the 3 Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to activate this database engine manually so as to be able to run open-source script-driven software apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require in order to run very large websites, it’s very possible that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a specific application requires MyISAM instead of InnoDB, you will not encounter any problem while running it. The engine that will be used will be recognized automatically once the app installation starts, so you will not need to change any setting manually at any moment.

  • Contact Us
    • Our ID: 250382