InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a much better overall performance and a faster database failure recovery compared to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of developers that run scalable web apps, due to the fact that it works better with enormous data volumes, while it keeps the server processing load low. Furthermore, it uses row-level locking in case anything should be edited, while lots of other engines lock the entire table and therefore require more time to handle multiple sequential tasks. Last, but not least, InnoDB adheres to 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 prevent scrambling or losing data. Magento and the newest Joomla™ versions are two examples of famous PHP script-driven web apps that have switched to InnoDB.

InnoDB in Web Hosting

Any script-driven web application that needs InnoDB will run impeccably on our advanced cloud website hosting platform and the MySQL database engine is offered with all our web hosting plans. Whenever 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 based on the app’s specifications without having to edit any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to get the most out of its full potential. We will carry out daily backups of your content, so in case you unintentionally delete a MySQL database that is important to you or you overwrite some part of it, we will be able to restore your content the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can run an open-source script-based app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click application installer tool. In either case, the required engine will be chosen automatically once the app’s installation starts, so you won’t have to configure anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to retrieve any of your databases if you unintentionally erase one, as we perform a couple of database backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

When you purchase a VPS server from us, you’ll be able to take full advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to manage any script-based web application that needs InnoDB, as the MySQL storage engine is part of the software bundle that will be pre-installed on the server during its setup. When you set up a new database using the hosting Control Panel, you simply have to start installing an application – manually or using our app installer. InnoDB will be set as the default engine if the application in question needs it, so you won’t have to do anything else in your account. Equivalently, if an application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

InnoDB is available by default with all Linux dedicated service that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the default software bundle that will be installed on all Hepsia-equipped dedicated servers, so once your machine is ready, you’ll be able to log in and to activate any type of script-driven software app that requires this MySQL database engine. When you create a new database through the Control Panel, there won’t be any activated engine until you begin installing an application. As soon as the app installation wizard starts inserting content into the database, the engine will be picked automatically on the basis of the prerequisites of the given application, so you can run both InnoDB and MyISAM without selecting either one of them specifically at any point. In this way, you can use a vast collection of applications for your websites.