InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it offers a much better overall performance and a faster crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by many developers that write highly scalable apps, due to the fact that it works more effectively with enormous data volumes, while it keeps the server processing load low. Also, it locks only a single database row if any info should be modified, whereas lots of other engines lock the entire table and thus need more time to handle multiple sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest versions of Joomla are two instances of famous script-powered apps that have shifted over to InnoDB.

InnoDB in Shared Website Hosting

Any open-source script-based software app that requires InnoDB will run impeccably on our leading-edge cloud platform and the storage engine comes with all our shared website hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected in accordance with the app’s requirements without the need to configure any setting in your account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We will carry out regular backups of your content, so if you accidentally erase a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore the database the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing an open-source script-powered web app either manually or using our 1-click app installer tool, the MySQL database storage engine will be selected automatically depending on the prerequisites of the particular application. Since InnoDB is present on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that requires it without any manual action required on your end at any time. To avoid any chance of losing info if you update an app or if you delete a database accidentally, we’ll make backups of all your MySQL databases each and every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to use any PHP-driven application that needs this storage engine without the need to configure anything manually. You can pick Hepsia on the VPS order form and your brand new VPS server will be ready within sixty minutes, so you can log in and start building your web sites right away. Once you set up a new MySQL database and start the app activation process, our system will set the engine for this database automatically. Thus, you can use various apps simultaneously without configuring anything on the VPS server. You can create a WordPress-based personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-shop that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you will not have to add it manually in case you wish to activate open-source PHP scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the installation – once the installer wizard gets access to the database and begins dumping content in 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’ll also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you will not have to update any settings on the server. This will allow you to install various scripts on a single physical machine and to use it to its maximum potential.