InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got a number of pluses which have made it the preferred engine for lots of PHP script-powered web apps, including Magento and Joomla, which have switched over to InnoDB for good. For example, adding enormous volumes of data will be much faster with InnoDB, since it locks only a single row to execute a given task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is treated. To put it simply, appending new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain problem shows up in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it is an integral part of the standard set of services that we offer with our cloud hosting packages. If you’d like to make use of a script-powered software app that needs InnoDB in particular, in order to be installed and to function properly, you won’t experience any impediments as the InnoDB storage engine is available on our custom cloud website hosting platform. Regardless of whether you create a new database and install an application manually or take advantage of our 1-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it rather than MyISAM. In addition to the excellent crash recovery that InnoDB is offering, we also make regular database backups, so that we can quickly restore any database in your shared account.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our Linux semi-dedicated hosting packages by default, so as soon as you get a new account, you can go on and activate any script-driven software application that requires this MySQL database engine. A number of engines are installed on our cloud platform, so when you create a new database and start installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set depending on the prerequisites of the specific app. This will allow you to install and manage InnoDB-specific apps without encountering any problem and without configuring any settings in your semi-dedicated account. To take no chances, we will always have a one-week-old backup of all your MySQL databases, so if you remove or change any content unintentionally, we can swiftly recover it.
InnoDB in VPS
When you acquire a virtual private server from us, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to use any open-source script-powered application which needs InnoDB, as this database storage engine is included in the software package that will be installed on the VPS server during its creation. When you set up a brand new database via the Control Panel, you will just have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question requires it, so you will not need to do anything else in your VPS account. Equivalently, if an application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Hosting
If you obtain a new dedicated server, you’ll be able to select one of the 3 Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to install this MySQL database storage engine manually in order to be able to manage open-source script-driven applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need in order to manage very large sites, it’s very likely that you will use InnoDB. You will be able to use other engines too, so in case a certain application needs MyISAM instead of InnoDB, you will not experience any impediment while managing it. The engine that will be used will be detected automatically the moment the app installation procedure starts, so you won’t need to alter any setting manually at any time.