InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by numerous programmers that write scalable software apps, due to the fact that it works much more efficiently with immense amounts of data, while it keeps the server load low. In addition, it uses row-level locking if any information should be updated, while many other engines lock the entire database table and therefore require much more time to process several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest releases of Joomla are two examples of widespread PHP script-powered web apps that have shifted over to InnoDB.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it’s an essential part of the standard set of services offered with our shared web hosting plans. In case you want to use an open-source script-based application that needs InnoDB particularly, in order to be installed and to work correctly, you won’t have to deal with any problems as the MySQL storage engine is available on our custom-developed cloud hosting platform. No matter if you create a brand-new MySQL database and activate an app manually or use our single-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app needs InnoDB rather than MyISAM. In addition to the incredible database crash recovery that InnoDB offers, we also carry out daily backups of all databases, so we can swiftly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel provided with each of our semi-dedicated server accounts and you start installing an open-source script-powered web application either manually or using our one-click app installer, the storage engine for the database will be set automatically on the basis of the specific app’s requirements. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any time. To prevent any chance of losing info if you update an app or if you erase a database by mistake, we’ll perform backups of all your MySQL databases every day, so if something happens, we can rescue your data.

InnoDB in VPS Hosting

If our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be installed on the server together with other necessary software, so you won’t have to do anything if you choose to manage PHP script-based software applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a brand-new database and begin the app installation process manually or using our single-click installer. The system will detect the engine that the particular app needs and will assign it to the specific MySQL database, so the installation will proceed impeccably and the app can insert its data into that database. Therefore, you can make use of applications with various prerequisites with regard to the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

All dedicated web hosting that are ordered with our custom-built Hepsia Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you wish to activate open-source scripts that need it. All it takes to run such a script is to set up a new database and to start the setup – as soon as the script installation wizard accesses the database and begins entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that require MyISAM, the other widely used MySQL engine, so you will not have to modify any settings on the dedicated server. This will allow you to install different scripts on a single physical machine and to use it to its full potential.