InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and an improved crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by plenty of programmers that write scalable web applications, because it works much more effectively with large volumes of data, while it keeps the server processing load at a minimum. What’s more, it locks only a single database row in case any information should be updated, while many other engines lock the entire table and hence need much more time to process multiple sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest releases of Joomla are two examples of widely used script-driven software applications which have shifted over to InnoDB.

InnoDB in Cloud Hosting

Any PHP script-powered web app that requires InnoDB will function flawlessly on our advanced cloud website hosting platform and the storage engine comes with all our cloud hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected based on the app’s prerequisites without having to update any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will perform regular content backups, so in case you unintentionally delete a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Hosting

You can activate a script-driven application that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud web hosting platform where the storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our one-click app installer. In either case, the needed engine will be chosen automatically once the app’s installation begins, so you won’t have to update anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to retrieve any of your databases if you delete one by accident, as we generate several MySQL database backups every day, each of which is saved for 1 whole week.

InnoDB in VPS Hosting

If you get a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the software pack that will be installed on your server before we hand it over to you. You won’t need to set up anything manually and you will be able to install and run any script-powered software application that needs InnoDB once your Virtual Private Server is up and running, which takes no more than sixty minutes after the order submission itself. A couple of engines are offered, so anytime you create a MySQL database using the Hepsia Control Panel, a specific engine will be selected once the app activation commences and our system will automatically recognize the engine that is required by the application in question. In case you need MyISAM, for example, you will not need to do anything different than installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the features that you can select on the server configuration page when you buy a dedicated server from us. Since this is the most powerful kind of web hosting, it is pretty likely that you’ll manage very popular Internet sites that will attract plenty of visitors, and since InnoDB is among the best choices for such websites, we’ll install it along with all the other software applications that are available with a Hepsia-managed server. When you create a new database in your dedicated account, there won’t be any activated MySQL database engine until you begin installing a PHP script, whether manually via your web browser or using the automatic script installer that is included in the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to the database in question, so you can install scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without experiencing any obstacle.