InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a much better overall performance and a faster database failure recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by lots of developers that run highly scalable applications, due to the fact that it works more effectively with large amounts of data, while it keeps the server processing load at a minimum. Also, it locks only a single database row if any information should be updated, whereas many other engines lock the entire table and hence need more time to carry out several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest Joomla releases are two instances of popular PHP-powered software applications which have shifted over to InnoDB.

InnoDB in Cloud Web Hosting

InnoDB is offered with all our cloud web hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-powered web application that needs the MySQL database storage engine without any obstacles once you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, regardless of whether you take advantage of our single-click installation tool or create the database and set up the application manually, as long as the app requires it instead of the more famous MyISAM engine. We will keep daily database backups, so you can rest assured that you’ll never lose any data if you delete a database by accident or you overwrite some vital info – you simply have to touch base with us and we’ll restore everything the way it was.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-powered software application that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our innovative cloud hosting platform where the database engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click app installer. In either case, the needed engine will be chosen automatically the moment the installation of the application starts, so you won’t need to update anything manually, regardless of whether the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to restore any of your MySQL databases in case you remove one by accident, as we make a few MySQL database backups every day, each of which is saved for one week.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is selected during the signup process for a new VPS servers , InnoDB will be installed on the server along with other required software, so you won’t need to do anything if you decide to use open-source script-powered apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a new database and start the app installation process manually or using our 1-click installer. The system will automatically detect which engine the app in question needs and will assign it to the specific database, so the installation process will proceed flawlessly and the application can insert its content into that database. In this way, you can use apps with various prerequisites in regard to the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not have to activate it manually in case you’d like to use open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – as soon as the setup wizard acquires access to the database and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you will not have to edit any settings on the dedicated server. This will allow you to install different scripts on a single physical server and to use the latter to its fullest capabilities.