InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by many programmers that create scalable web apps, due to the fact that it works more effectively with large data volumes, while it keeps the server load at a minimum. Also, it it locks only one row in the database if any information should be modified, while lots of other engines lock the entire table and therefore require much more time to carry out several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for any reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the newest editions of Joomla are two examples of popular script-powered software applications that have switched to InnoDB.

InnoDB in Hosting

Every PHP-based web application that requires InnoDB will run impeccably on our leading-edge cloud platform and the storage engine comes with all our hosting packages. 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 will use will be selected on the basis of the app’s prerequisites without having to edit any setting in your account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will carry out daily content backups, so if you accidentally delete a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your content the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

All our semi-dedicated service come with InnoDB and you can take full advantage of all the features offered by this MySQL storage engine with any open-source script-based software app that needs it. InnoDB is one of the engines that are available on our cloud hosting platform, so the one that will be selected depends on the prerequisites of the given application. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our 1-click application installer tool. To avoid any risk, we’ll make regular database backups, so if something goes wrong after some update or if you erase some content accidentally, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server along with other needed software, so you will not need to do anything if you choose to make use of PHP-based software apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand-new database and begin installing the app manually or through our single-click installer tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the application can dump its data in that database. Thus, you can use apps with various requirements concerning the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to pick any of the three hosting Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL database engine manually in order to be able to use open-source script-driven web applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage very large sites, it is very likely that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a certain application requires MyISAM rather than InnoDB, you won’t have any complication while managing it. The engine that will be used will be automatically recognized when the app installation procedure starts, so you won’t have to fine-tune any settings manually at any point.