InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is preferred by lots of programmers that build scalable web apps, due to the fact that it works much more effectively with huge amounts of data, while it keeps the server processing load low. In addition, it locks only a single database row in case any info should be edited, while lots of other engines lock the entire table and therefore require much more time to perform multiple sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla releases are two examples of widespread open-source script-driven software apps that have switched to InnoDB.

InnoDB in Cloud Website Hosting

Any PHP-powered app that requires InnoDB will function flawlessly on our advanced cloud platform and the storage engine is offered with all our cloud website hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to change any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We’ll keep regular content backups, so if you unintentionally delete a database that’s important to you or you overwrite a certain part of it, we will be able to restore the database the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so once you purchase a new account, you can move on and activate any script-driven application that needs this storage engine. Several engines are installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected depending on the concrete app’s prerequisites. This will permit you to install and run InnoDB-specific applications without any complication and without having to change any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can easily rescue it.

InnoDB in VPS Web Hosting

In case our custom-built Hepsia Control Panel is picked during the signup process for your new Linux VPS web hosting packages , InnoDB will be installed on the server along with other necessary pieces of software, so you will not need to do anything if you choose to activate script-driven apps that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a brand new MySQL database and start the app installation manually or through our one-click installation tool. The system will automatically detect the engine that the particular app needs and will assign it to the specific database, so the installation process will continue flawlessly and the app can import its content into that database. In this way, you can make use of applications with various requirements regarding the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers Hosting

All dedicated servers hosting ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you will not have to activate it manually in case you need to activate scripts that need it. All it takes to install such a script is to create a new database and to start the setup – as soon as the script setup wizard acquires access to the database in question and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you won’t have to configure any settings on the dedicated server. This will allow you to run a variety of scripts on a single physical machine and to use it to its fullest capacity.