InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by lots of developers that run scalable apps, because it works more effectively with enormous amounts of data, while it keeps the server load low. Furthermore, it uses row-level locking in case anything should be updated, while many other engines lock the entire table and thus need more time to accomplish several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ versions are two examples of widespread PHP-powered software platforms that have shifted over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many hosting providers, it is an essential part of the standard set of services that we are offering with our shared hosting packages. In case you’d like to make use of a PHP script-powered application that requires InnoDB specifically, in order to be installed and to work properly, you will not need to deal with any impediments as the storage engine is available on our custom-developed cloud web hosting platform. Irrespective of whether you set up a new database and install an app manually or make use of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires it rather than MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also carry out daily database backups, so we can easily restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-driven app that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. Either way, the required engine will be selected automatically the moment the activation of the application starts, so you will not have to edit anything manually, no matter if the application requires InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to retrieve any of your MySQL databases if you delete one by accident, as we carry out a few database backups every day, each of which is kept for one week.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to make use of any script-based software application that needs this database engine without needing to activate 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 begin building your Internet sites straight away. Once you create a brand new database and start the app installation process, our system will select the engine for that MySQL database automatically. Thus, you can use different apps simultaneously without the need to update anything on the Virtual Private Server. You can create a WordPress-based weblog that makes use of the default MySQL engine – MyISAM, and a Magento-driven e-commerce site that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you’ll be able to pick any of the three Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database storage engine manually to be able to manage script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you require in order to manage large-scale Internet sites, it is very possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a specific application needs MyISAM rather than InnoDB, you won’t have to deal with any obstacle while running it. The engine that will be used will be automatically recognized once the app installation process begins, so you will not need to alter any settings manually whatsoever.