InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a better overall performance and an improved database crash recovery compared with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of programmers that build highly scalable web applications, as it works more efficiently with immense data volumes, while it keeps the server processing load low. Additionally, it locks only one database row if any information should be modified, while many other engines lock the entire database table and therefore need more time to execute multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest versions of Joomla™ are two instances of widespread script-based software apps that have shifted over to InnoDB.

InnoDB in Website Hosting

Any open-source script-driven application that requires InnoDB will function impeccably on our avant-garde cloud website hosting platform and the MySQL storage engine is available with all our website hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s prerequisites without having to change any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will carry out daily backups of your content, so in case you accidentally delete a database that’s important to you or you overwrite specific parts of it, we will be able to restore your database the way it was just a few hours ago.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting come with InnoDB and you’ll be able to take advantage of all the features offered by this MySQL storage engine with any PHP script-powered software app that needs it. InnoDB is one of the engines that are available on our cloud platform, so the one that will be picked depends on the particular app’s requirements. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our 1-click application installer tool. To avoid any risk, we will make regular backups of all your MySQL databases, so if something goes wrong after an upgrade or if you erase some data by mistake, we will be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS

If our in-house developed Hepsia Control Panel is selected during the signup process for your new Linux virtual private servers , InnoDB will be installed on the VPS server together with other necessary pieces of software, so you will not need to do anything if you decide to install PHP-powered apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin installing the app manually or using our 1-click installer tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will continue flawlessly and the application can insert its data into that database. Therefore, you can install applications with different prerequisites concerning the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t need to install it manually in case you need to run open-source scripts that require it. All it takes to activate such a script is to set up a new database and to start the installation – as soon as the installer wizard receives access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You’ll also be able to install scripts that need the other popular MySQL engine – MyISAM, so you will not need to update any settings on the server. This will permit you to activate various scripts on one single machine and to use the latter to its fullest potential.