InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database failure recovery compared with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by plenty of programmers that write scalable web apps, as it works much more efficiently with enormous amounts of data, while it keeps the server processing load low. Also, it uses row-level locking if anything should be edited, while lots of other engines lock the entire table and thus need more time to accomplish several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the latest releases of Joomla are two examples of famous PHP-driven applications that have shifted over to InnoDB.

InnoDB in Cloud Web Hosting

InnoDB is available with all our Linux cloud web hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-based software app that requires the MySQL storage engine without the need to deal with any problem as soon as you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation process, no matter if 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 InnoDB instead of the more popular MyISAM engine. We’ll store daily database backups, so you can rest assured that you won’t ever lose any content if you delete a database by mistake or you overwrite some key info – you’ll just need to alert us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

You can install a PHP-based web app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click application installer tool. Either way, the required engine will be picked automatically once the installation of the application begins, so you won’t have to edit anything manually, regardless of whether the app requires InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to retrieve any of your databases in case you accidentally remove one, as we create a couple of database backups every day, each of which is preserved for 1 week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an essential part of the software bundle that will be installed on your server before we give it to you. You will not have to configure anything manually and you will be able to enable and use any PHP script-driven web app that requires InnoDB once your Virtual Private Server is set up, which takes no more than 60 minutes after the order process itself. A few engines are available, so whenever you set up a database through the Hepsia Control Panel, a specific engine will be picked once the app installation begins and our system will detect the engine that is required by the app in question. In case you have to use MyISAM, for instance, you will not have to do anything different from installing the preferred app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you’d like to run scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the installation – once the script setup wizard gets access to the database in question and begins entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you will not need to update any settings on the dedicated server. This will allow you to run various scripts on a single machine and to use it to its fullest capacity.