InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by lots of devs that write highly scalable apps, due to the fact that it works much better with huge volumes of data, while it keeps the server processing load at a minimum. Additionally, it it locks only one row in the database in case anything should be updated, while many other engines lock the entire table and therefore require much more time to complete multiple successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid confusion or data loss. Magento and the newest Joomla releases are two examples of widespread PHP script-powered software apps that have shifted over to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosts, it is included in the standard set of services that we are offering with our website hosting plans. If you’d like to use an open-source script-based software app that requires InnoDB in particular, in order to be activated and to work correctly, you won’t come across any impediments as the InnoDB database storage engine is available on our custom-developed cloud website hosting platform. No matter if you create a new database and activate an app manually or use our one-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the particular app needs it rather than MyISAM. Besides the amazing database failure recovery that InnoDB offers, we also generate daily backups of all databases, so we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

You can run a script-driven web application that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our leading-edge cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our 1-click application installer tool. In either case, the needed engine will be selected automatically the moment the activation of the app starts, so you won’t have to change anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases in case you remove one by accident, as we make a few backups every day, each of which is stored for 1 whole week.

InnoDB in VPS

All Linux VPS packages that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to run any PHP-based software app that requires the MySQL storage engine without having to activate anything manually. You can select Hepsia on the VPS order form and your new Virtual Private Server will be ready within one hour, so you can sign in and start creating your sites straight away. Once you create a brand-new MySQL database and begin the app installation process, our system will set the engine for this database automatically. In this way, you can activate various apps at the same time without the need to update anything on the Virtual Private Server. You can set up a WordPress personal journal that makes use of the default MySQL engine – MyISAM, and a Magento-powered Internet shop that makes use of InnoDB, for instance.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually if you need to run scripts that require it. All it takes to use such a script is to create a new database and to initiate the setup process – once the script setup wizard obtains access to the database in question and begins dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to use scripts that require the other popular MySQL engine, MyISAM, so you won’t have to modify any settings on the server. This will permit you to activate various scripts on one single machine and to use the latter to its full potential.