InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by lots of programmers that create highly scalable apps, because it works much more efficiently with large amounts of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case any information should be updated, while many other engines lock the entire database table and hence need much more time to fulfill multiple successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla releases are two examples of famous open-source script-based web applications that have switched over to InnoDB.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting support InnoDB and you’ll be able to use all the options offered by this MySQL storage engine with any PHP-powered software application that needs it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the prerequisites of the given application. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click application installer. To avoid any risk, we’ll store regular backups of all your MySQL databases, so if something goes wrong after some update or if you erase some data unintentionally, we will be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be part of the software pack that will be installed on your VPS server before we give it to you. You will not have to configure anything manually and you will be able to enable and manage any open-source script-based web application that needs InnoDB as soon as your VPS is up and running, which takes no more than sixty minutes after the order submission procedure itself. A number of engines are available, so whenever you create a MySQL database via the Hepsia hosting Control Panel, a particular engine will be picked once the app activation commences and our system will recognize the engine that is required by the app in question. In case you need to use MyISAM, for example, you will not have to do anything different than installing the chosen application, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not need to activate it manually if you need to run open-source scripts that require it. All it takes to run such a script is to set up a new MySQL database and to start the setup – once the installer wizard gets access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You’ll also be able to run scripts that need the other very popular MySQL engine – MyISAM, so you will not have to modify any settings on the dedicated server. This will permit you to run various scripts on one single server and to use the latter to its maximum capacity.