InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by plenty of programmers that write scalable web apps, since it works much more effectively with enormous volumes of data, while it keeps the server processing load low. Additionally, it it locks only one row in the database in case anything should be modified, whereas many other engines lock the entire table and therefore require more time to complete multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest editions of Joomla are two instances of famous open-source script-driven applications that have switched to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s included in the standard set of services that we offer with our shared website hosting packages. If you’d like to use a PHP-powered application that requires InnoDB in particular, in order to be activated and to operate correctly, you will not have any obstacles as the InnoDB database storage engine is available on our custom-developed cloud web hosting platform. Regardless of whether you create a brand new database and activate an app manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular application needs it rather than MyISAM. In addition to the excellent crash recovery offered by InnoDB, we also keep regular database backups, so we can swiftly recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is offered with each of our Linux semi-dedicated servers by default, so once you obtain a new account, you can go ahead and activate any PHP script-driven app that requires the storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be chosen in accordance with the requirements of the respective app. This will permit you to install and manage InnoDB-specific apps without the need to cope with any impediment and without needing to configure any settings in your account. To take no chances, we will always have a one-week-old backup of all your MySQL databases, so if you remove or alter any content by accident, we can swiftly recover it.
InnoDB in VPS Servers
If our custom-built Hepsia hosting Control Panel is picked during the signup process for a new VPS web hosting plans , InnoDB will be installed on the server along with other essential pieces of software, so you won’t have to do anything if you decide to install script-driven apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed too. You can set up a new MySQL database and begin the app installation procedure manually or through our 1-click installation tool. The system will detect the engine that the particular application requires and will assign it to the specific database, so the installation will proceed impeccably and the app can dump its data in that database. Thus, you can use applications with different prerequisites in regard to the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s included in the software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is assembled, you’ll be able to sign in and to install any PHP-powered application that needs this MySQL storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app configuration wizard begins dumping information in the newly created database, the engine will be set automatically on the basis of the prerequisites of the given application, so you can run both InnoDB and MyISAM without having to select either one of them explicitly at any point. Thus, you can make use of a large collection of apps for your websites.