InnoDB is a very popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of advantages that have made it the preferred engine for numerous open-source script-driven applications, such as Joomla and Magento, which have switched to InnoDB for good. For instance, adding huge amounts of data will be much faster with InnoDB, since it locks only one database row to perform a given operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. In simpler words, appending new or editing existing data will either be entirely completed, or will be annulled and the operation will be rolled back if a given problem shows up in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting service providers, it is an integral part of the standard set of services that we are offering with our cloud hosting packages. In case you wish to make use of a PHP-based web app that needs InnoDB in particular, in order to be installed and to operate properly, you won’t need to deal with any impediments as the database storage engine is available on our in-house developed cloud platform. Irrespective of whether you create a brand new MySQL database and activate an app manually or use our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app needs InnoDB instead of MyISAM. In addition to the excellent database failure recovery offered by InnoDB, we also maintain daily backups of all databases, so that we can easily restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

InnoDB is available with all our Linux semi-dedicated hosting by default, so as soon as you get a new account, you can go on and install any open-source script-based application that needs the MySQL database storage engine. Several engines are installed on our cloud website hosting platform, so when you set up a brand new database and begin installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be selected depending on the prerequisites of the given application. This will allow you to activate and run InnoDB-specific apps without coming across any impediment and without configuring any settings in your account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly restore it.

InnoDB in VPS

When you acquire a virtual private server from us, you’ll be able to take advantage of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any script-powered software app that requires InnoDB, as this database storage engine is part of the default software bundle that will be pre-installed on the server during its configuration. When you set up a brand-new MySQL database using the Control Panel, you will just need to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t need to do anything else in your VPS account. Likewise, if an app requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Hosting

When you buy a new dedicated server, you will be able to select one of the three hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to add this database engine manually in order to be able to run PHP-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you require to manage large-size Internet sites, it’s very likely that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a given application requires MyISAM instead of InnoDB, you will not come across any difficulty while using it. The engine that will be used will be detected automatically as soon as the app installation commences, so you won’t have to alter any settings manually at any time.