InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and an improved database crash recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of devs that create scalable web applications, because it works much better with enormous amounts of data, while it keeps the server processing load at a minimum. What’s more, it locks only one database row in case any info should be edited, whereas lots of other engines lock the entire database table and thus need more time to fulfill multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla versions are two instances of widespread PHP-based software platforms which have moved to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any PHP script-based software app that requires the MySQL database storage engine without the need to deal with any difficulty as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation process, regardless of whether you use our one-click installer or create the MySQL database and set up the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will perform daily MySQL database backups, so you can be certain that you won’t ever lose any data if you erase a database accidentally or you overwrite some important info – you’ll simply need to contact us and we’ll restore everything the way it was.

InnoDB in Semi-dedicated Servers

You can use an open-source script-based software application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud web hosting platform where the database engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click app installer. In either case, the required engine will be selected automatically the moment the application’s installation starts, so you won’t need to update anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to restore any of your MySQL databases in case you delete one by accident, as we generate several backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is picked during the signup process for your new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you won’t need to do anything if you decide to run PHP script-powered software applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a new database and begin installing the application manually or using our one-click installer tool. The system will automatically recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the application can insert its content into that database. In this way, you can manage applications with different requirements concerning the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can select on the server order page when you purchase a dedicated server from our company. Since this is the most powerful kind of website hosting, it’s quite likely that you will run highly popular sites that will attract many people, and since InnoDB is among the best options for such sites, we’ll enable it together with all the other software apps that are offered with a Hepsia-managed server. When you create a new database in your account, there won’t be any active database storage engine till you begin installing a PHP script, whether manually via your browser or using the automatic script installer that is integrated into the hosting Control Panel. The required engine will be recognized and will be set for the database in question, so you can use scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without experiencing any difficulty.