InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a much better overall performance and a faster database failure recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by plenty of web developers that create highly scalable software apps, as it works much more effectively with enormous volumes of data, while it keeps the server load at a minimum. What’s more, it it locks only one row in the database in case any information should be modified, while lots of other engines lock the entire table and hence need more time to accomplish multiple successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest versions of Joomla™ are two instances of widespread script-driven web applications that have switched to InnoDB.
InnoDB in Shared Website Hosting
Every PHP-based web application that needs InnoDB will run flawlessly on our leading-edge cloud hosting platform and the MySQL storage engine comes with all our shared website hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without the need to configure any setting in your shared hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We will carry out daily backups of your content, so if you unintentionally remove a MySQL database that is important to you or you overwrite specific parts 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
If you create a brand new MySQL database from the Control Panel provided with all our semi-dedicated server plans and you start installing a PHP-powered software application either manually or using our one-click app installer, the storage engine for the MySQL database will be picked automatically on the basis of the requirements of the specific app. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that requires it without any manual action required on your end at any point. To prevent any risk of losing info if you update an app or if you delete a database unintentionally, we will carry out backups of all your databases each day, so if anything happens, we can restore your content.
InnoDB in VPS Servers
If you pick 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 server before we hand it over to you. You will not need to activate anything manually and you’ll be able to install and manage any PHP-powered software application that needs InnoDB once your Virtual Private Server is ready, which takes no more than 60 minutes after the order procedure itself. Several engines are available, so anytime you create a MySQL database through the Hepsia Control Panel, a specific engine will be selected when the app activation starts and our system will recognize the engine that is required by the application in question. If you need to use MyISAM, for example, you will not have to do anything different than installing the app of your preference, whether manually or using our app installer.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is among the features which you can select on the order page when you buy a dedicated server from our company. Since this is the most powerful kind of web hosting, it’s rather likely that you will run highly popular Internet sites that will draw a lot of visitors, and since InnoDB is among the very best choices for such websites, we’ll enable it along with all the other software apps that are available with a Hepsia-managed server. If you create a new database in your dedicated account, there won’t be any activated storage engine until you start installing an open-source PHP script, whether manually through your browser or using the automatic scripts installation tool that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without experiencing any impediment.