InnoDB is a popular database storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got plenty of advantages which make it the engine of choice for lots of PHP-powered apps, such as Magento and Joomla™, which have moved to InnoDB permanently. For instance, importing huge data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to accomplish a particular task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, appending new or modifying existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case a given problem appears during the process, so the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

Every open-source script-powered software application that needs InnoDB will function impeccably on our leading-edge cloud platform and the MySQL database engine is offered with all our cloud web hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without the need to change any setting in your account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will make daily backups of your content, so if you accidentally delete a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore everything the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of a PHP script-based software app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our avant-garde cloud web hosting platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our single-click app installer. Either way, the needed engine will be picked automatically the moment the app’s installation begins, so you won’t have to update anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your databases in case you remove one by accident, as we perform a few database backups every day, each of which is saved for one whole week.

InnoDB in VPS Servers

If you obtain a VPS server from us, you’ll be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to run any script-driven app that needs InnoDB, as the MySQL database engine is an essential part of the software package that will be installed on the VPS server during its configuration. When you set up a brand new MySQL database using the hosting Control Panel, you will simply need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question needs it, so you won’t have to do anything else in your VPS account. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you’ll be able to pick one of the three hosting Control Panels that we offer – Hepsia and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to enable this MySQL database engine manually so as to be able to use PHP-driven software apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you require in order to manage very large websites, it’s pretty possible that you will resort to InnoDB. You will be able to use other engines as well, so if a specific application requires MyISAM instead of InnoDB, you will not encounter any complication while running it. The engine that will be used will be automatically detected as soon as the app installation procedure starts, so you won’t have to fine-tune any setting manually at any time.