InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and a faster crash recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by lots of devs that run highly scalable web applications, as it works more efficiently with immense amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single row in the database if any info should be updated, whereas many other engines lock the entire table and hence require much more time to carry out 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 some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest editions of Joomla are two examples of widespread PHP-driven web applications which have shifted over to InnoDB.

InnoDB in Shared Website Hosting

You can make use of any open-source script-driven web application that requires InnoDB if you have a shared website hosting plan with us, as the MySQL database storage engine is present on our innovative cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate apps which need the MyISAM engine without any problems as well and, once again, the engine will be selected automatically, so you won’t have to edit anything manually at any moment. In addition, we’ll also make daily backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated hosting plans by default, so the moment you obtain a new semi-dedicated account, you can move on and activate any PHP-powered app that requires this particular database storage engine. A few engines are pre-installed on our cloud website hosting platform, so when you set up a brand-new database and start installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the requirements of the application in question. This will permit you to activate and manage InnoDB-specific applications without the need to deal with any impediment and without needing to update any settings in your account. To take no chances, we will always keep a seven-day-old backup of all your MySQL databases, so if you erase or change any content unintentionally, we can quickly recover it.

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 default software bundle that will be installed on your VPS server before we hand it over to you. You will not have to activate anything manually and you will be able to enable and run any script-driven application that needs InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission procedure itself. A number of engines are offered, so every time you set up a MySQL database through the Hepsia Control Panel, a particular engine will be activated when the app activation commences and our system will automatically recognize which engine is required by the application in question. If you have to use MyISAM, for instance, you will not need to do anything different than installing the application of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options that you can choose on the server order page when you buy a dedicated server from us. Since this is the most powerful type of website hosting, it is quite likely that you’ll run highly popular websites that will attract many visitors, and since InnoDB is one of the very best choices for such sites, we’ll enable it together with all the other software applications that come with a Hepsia-managed dedicated server. When you create a brand-new database in your dedicated server account, there won’t be any active MySQL database storage engine till you start installing an open-source PHP script, whether manually through your web browser or using the automatic scripts installation tool that is integrated into the hosting Control Panel. The necessary engine will be recognized automatically and will be set for the database in question, so you can activate scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without experiencing any difficulty.