InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got many advantages which make it the preferred engine for many open-source script-based software apps, among them Joomla™ and Magento, which have switched to InnoDB for good. For example, adding large amounts of data will be much faster with InnoDB, since it locks only a single database row to complete a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. Put simply, appending new or modifying existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain issue appears during the process, hence the content that remains in the database will not be damaged.
InnoDB in Cloud Website Hosting
InnoDB is available with all our cloud website hosting plans
by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP script-based web application which needs the InnoDB database engine without any difficulty as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation, regardless of whether you make use of our single-click installation tool or create the MySQL database and set up the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll store regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you delete a database accidentally or you overwrite some key information – you will just have to notify us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated servers
support InnoDB and you will be able to make the most of all the features of this MySQL storage engine with any PHP-powered web application that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the particular app. You won’t need to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To be on the safe side, we will create regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some content accidentally, we’ll be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Servers
When you purchase a VPS server
from us, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to manage any PHP script-powered software app that needs InnoDB, as the storage engine is part of the software package that will be installed on your Virtual Private Server during its configuration. When you set up a brand-new database using the Control Panel, you just need to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you won’t have to do anything else in your VPS account. Identically, if a given application needs MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
If you obtain a new dedicated server
, you will be able to choose one of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to add this storage engine manually so as to be able to manage PHP script-driven applications that need it. InnoDB is used by scalable applications and since a dedicated server will give you all the resources that you require in order to run large-scale Internet sites, it is pretty possible that you’ll resort to InnoDB. You will be able to use other engines too, so if a certain application requires MyISAM rather than InnoDB, you won’t experience any problem while managing it. The engine that will be used will be detected automatically once the app installation procedure begins, so you will not need to change any setting manually whatsoever.