InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous developers that build highly scalable software apps, since it works much better with immense volumes of data, while it keeps the server load at a minimum. Moreover, it locks only one database row in case anything should be updated, while many other engines lock the entire table and therefore need much more time to execute several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for whatever reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest versions of Joomla™ are two examples of popular PHP script-powered software apps which have shifted over to InnoDB.

InnoDB in Hosting

InnoDB is available with all our Linux hosting services by default, not upon request or as a paid upgrade, so you will be able to activate and manage any open-source script-powered software application that needs the InnoDB database storage engine without having any problem once you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, no matter if you make use of our one-click installer or create the MySQL database and install the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will maintain daily backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you delete a database by accident or you overwrite some essential info – you simply have to touch base with us and we will restore your database back to normal.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server plans and you start installing an open-source script-based app either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the given application. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any time. To avoid any risk of losing info if you update an application or if you delete a database accidentally, we will make backups of all your MySQL databases every day, so if anything happens, we can retrieve your content.

InnoDB in VPS Web Hosting

All Linux VPS web hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to run any PHP script-based software app that needs this MySQL storage engine without needing to activate anything manually. You can select Hepsia on the VPS configuration page and your new server will be up and running within sixty minutes, so you can log in and start creating your web sites straight away. Once you set up a new database and begin the app activation process, our system will pick the engine for that database automatically. In this way, you can use different applications simultaneously without changing anything on the Virtual Private Server. You can set up a WordPress-driven online blog that uses the default MySQL engine – MyISAM, and a Magento-driven e-commerce site that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers Hosting

When you acquire a new dedicated server, you will be able to pick one of the 3 Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to install this storage engine manually to be able to manage PHP-powered software apps that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you need in order to run large-scale sites, it is very likely that you will resort to InnoDB. You will be able to use other engines too, so in case a specific application needs MyISAM rather than InnoDB, you won’t come across any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation process begins, so you will not need to modify any settings manually at any point.