InnoDB is a very popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has many advantages that have made it the engine of choice for lots of PHP-powered applications, such as Magento and Joomla™, which have moved to InnoDB for good. For example, adding huge volumes of data will be faster with InnoDB, due to the fact that it locks only a single row to accomplish a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. In simpler words, appending new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back if any problem appears in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Web Hosting

Any script-driven software app that needs InnoDB will run impeccably on our leading-edge cloud web hosting platform and the MySQL database storage engine comes with all our web hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to modify any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to take advantage of its full potential. We will make regular content backups, so in case you unintentionally remove a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your data the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server packages and you begin installing an open-source script-powered app either manually or using our 1-click app installer, the database storage engine will be picked automatically based on the specific app’s requirements. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any moment. To prevent any risk of losing data if you update an application or if you delete a database accidentally, we’ll perform a backup of all your databases every day, so if something goes wrong, we can restore your content.

InnoDB in VPS

If you purchase a virtual private server from our company, you will be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to activate any PHP-based application that requires InnoDB, as this database storage engine is an integral part of the default software package that will be installed on the VPS server during its configuration. When you set up a new MySQL database through the hosting Control Panel, you will just have to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine if the application in question needs it, so you will not need to do anything else in your account. In the same manner, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the options which you can choose on the order form when you purchase a dedicated server from us. As this is the most powerful kind of hosting, it is quite likely that you will manage popular Internet sites that will draw lots of people, and since InnoDB is among the best options for such websites, we’ll enable it together with all the other software applications that come with a Hepsia-equipped server. When you set up a new database in your dedicated server account, there won’t be any active MySQL storage engine until you begin installing a PHP script, whether manually via your Internet browser or using the automatic scripts installer tool that is available in the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to the database in question, so you can use scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without any problem.