InnoDB is a database engine for MySQL databases, which is used by well known open-source script-powered apps such as Joomla 3 and Magento. It’s perfect for scalable applications, as it performs remarkably well when managing enormous amounts of data. Rather than locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same length of time. In addition, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. If a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved undamaged and won’t be partially mixed with newly inserted content.

InnoDB in Website Hosting

Every PHP script-based application that needs InnoDB will function impeccably on our innovative cloud hosting platform and the database engine is offered with all our website hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s specifications without the need to update any setting in your account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We will make daily backups of your content, so in case you accidentally remove a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you begin installing a PHP-powered web app either manually or using our 1-click application installer, the MySQL database storage engine will be picked automatically on the basis of the prerequisites of the app in question. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without the need for any manual intervention on your end at any point. To prevent any chance of losing information if you update an application or if you delete a database accidentally, we’ll perform a backup of all your MySQL databases every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Web Hosting

When you purchase a virtual private server from us, you’ll be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to activate any open-source script-driven application which requires InnoDB, as the MySQL database storage engine is an essential part of the default software bundle that will be installed on the Virtual Private Server during its creation. When you set up a new database via the Control Panel, you just have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you won’t have to do anything else in your account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers Hosting

InnoDB is included by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s an essential part of the software bundle that will be installed on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you’ll be able to log in and to install any kind of open-source script-driven application that requires this MySQL storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app installation wizard begins dumping data in the newly created database, the engine will be set automatically in accordance with the requirements of the specific application, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any time. Thus, you can use a broad selection of apps for your sites.