InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-powered software applications like Magento and Joomla 3.x. It’s perfect for scalable applications, since it performs astonishingly well when processing huge amounts of data. Instead of locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. In addition, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that prescribe how data imports and updates should be treated. If a specific operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be preserved undamaged and will not be partially mixed with newly inserted content.

InnoDB in Shared Hosting

InnoDB is available with all our shared service by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-based app which requires the InnoDB storage engine without encountering any impediment once you order your shared account. InnoDB will be pre-selected as the default engine for a certain database during the app activation process, irrespective of whether you use our single-click installation tool or create the MySQL database and install the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you’ll never lose any data in case you delete a database by accident or you overwrite some crucial information – you’ll simply have to alert us and we will restore your data the way it was.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server plans and you start installing an open-source script-powered web app either manually or using our 1-click app installer, the MySQL database storage engine will be set automatically on the basis of the prerequisites of the particular app. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each app that requires it without the need for any manual action on your end at any point. To prevent any chance of losing information if you update an app or if you delete a database accidentally, we’ll perform backups of all your MySQL databases each day, so if something happens, we can retrieve your data.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the standard software bundle that will be installed on your server before we give it to you. You will not have to set up anything manually and you will be able to install and manage any script-powered app that needs InnoDB once your VPS is up and running, which takes no more than 60 minutes after the order submission procedure itself. A few engines are offered, so whenever you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be activated when the app installation begins and our system will automatically detect which engine is required by the application in question. In case you need to use MyISAM, for example, you will not have to do anything different than installing the desired app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options that you can choose on the server configuration page when you purchase a dedicated server from our company. As this is the most powerful type of website hosting, it is very likely that you’ll run highly popular Internet sites that will attract many people, and since InnoDB is one of the very best choices for such Internet sites, we’ll install it along with all the other software apps that are available with a Hepsia-managed dedicated server. When you set up a brand new database in your dedicated account, there won’t be any activated MySQL database storage engine till you begin installing a PHP script, whether manually via your browser or using the automatic scripts installer tool that is available in the Control Panel. The necessary engine will be recognized automatically and will be set for that database, so you can make use of scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without the need to cope with any difficulty.