InnoDB is a database storage engine for MySQL relational databases, which is used by widely used open-source script-based applications like Magento and Joomla 3. It is perfect for scalable apps, because it works exceptionally well when managing enormous volumes of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same length of time. Also, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that determine how data imports and updates should be handled. In case a particular operation hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain intact and will not be partially mixed with newly entered content.
InnoDB in Shared Web Hosting
Every script-powered software app that needs InnoDB will function impeccably on our leading-edge cloud web hosting platform and the MySQL database storage engine comes with all our shared web hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s specifications without having to update any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to get the most out of its full capacity. We’ll perform regular content backups, so in case you unintentionally erase a database that’s important to you or you overwrite a specific part of it, we’ll be able to restore the database the way it was just a few hours ago.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers come with InnoDB and you’ll be able to use all the options offered by this MySQL database engine with any PHP-driven web app that requires it. InnoDB is among the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given application. You will not need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we will perform daily backups of all your databases, so if something goes wrong after an upgrade or if you erase some content by accident, we will be able to restore your database the way it was on any of the past 7 days.
InnoDB in VPS Servers
When you get a VPS server from us, you’ll be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to manage any PHP-based application that requires InnoDB, as this particular MySQL database storage engine is an integral part of the standard software package that will be pre-installed on the VPS server during its configuration. When you create a brand-new database using the Control Panel, you will simply have to start installing an app – manually or using our application installer. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t need to do anything else in your account. Analogously, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
InnoDB comes by default with all Linux dedicated service that are ordered with the Hepsia hosting Control Panel. It’s part of the software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is ready, you’ll be able to log in and to activate any type of open-source script-based web app that requires this particular database engine. If you set up a new database through the Control Panel, there won’t be any active engine until you start installing an app. As soon as the app installation wizard starts dumping data in the newly created database, the engine will be picked automatically in accordance with the particular app’s requirements, so you can run both MyISAM and InnoDB without the need to select either one specifically at any point. Therefore, you can use a wide collection of applications for your Internet sites.