InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster database crash recovery in comparison with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is preferred by numerous programmers that create highly scalable apps, due to the fact that it works more effectively with immense amounts of data, while it keeps the server load low. Additionally, it locks only a single row in the database if any information should be modified, whereas lots of other engines lock the entire table and thus need much more time to accomplish several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest Joomla releases are two instances of widely used open-source script-based software apps that have switched to InnoDB.

InnoDB in Hosting

Any PHP script-driven web app that requires InnoDB will run impeccably on our advanced cloud website hosting platform and the MySQL database engine is offered with all our hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s requirements without having to modify any setting in your shared account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We will store daily backups of your content, so if you accidentally remove a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore your database the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our Linux semi-dedicated servers by default, so once you obtain a new account, you can go ahead and activate any PHP script-based web application that needs this particular database engine. A few engines are installed on our cloud website hosting platform, so when you create a brand-new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be set in accordance with the requirements of the specific app. This will allow you to activate and manage InnoDB-specific applications without having to deal with any difficulty and without editing any settings in your semi-dedicated account. To avoid any risk, we’ll always have a seven-day-old backup of all your MySQL databases, so if you erase or alter any content by mistake, we can quickly retrieve it.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to take advantage of any script-powered app that requires this database storage engine without installing anything manually. You can pick Hepsia on the VPS order page and your new VPS server will be ready within one hour, so you can log in and begin creating your sites straight away. Once you set up a brand-new MySQL database and start the app installation process, our system will set the engine for that database automatically. In this way, you can use various applications simultaneously without updating anything on the VPS server. You can have a WordPress-based online blog that uses the default MySQL engine – MyISAM, and a Magento-driven e-store that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our in-house developed Hepsia Control Panel include a software package that’s pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not need to add it manually in case you would like to run open-source PHP scripts that need it. All it takes to use such a script is to create a new database and to start the installation process – once the installation wizard gets access to the database and begins entering data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will allow you to install a variety of scripts on one single machine and to use the latter to its fullest capabilities.