InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster database failure recovery compared to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of developers that run scalable web applications, due to the fact that it works much more efficiently with huge amounts of data, while it keeps the server load at a minimum. Moreover, it locks only one database row in case any info should be edited, while many other engines lock the entire table and hence need much more time to complete several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the latest releases of Joomla are two examples of famous PHP script-based applications that have switched over to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting service providers, it’s an essential part of the standard set of services that we’re offering with our hosting packages. If you wish to use an open-source script-based app that needs InnoDB in particular, in order to be activated and to function properly, you will not come across any impediments because the database storage engine is available on our custom-built cloud platform. No matter if you set up a brand new database and activate an app manually or make use of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB rather than MyISAM. Besides the amazing database crash recovery offered by InnoDB, we also store daily backups of all databases, so that we can easily recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service come with InnoDB and you’ll be able to take full advantage of all the features offered by this MySQL database storage engine with any open-source script-powered app that requires it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be selected depends on the prerequisites of the respective app. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To avoid any risk, we’ll store regular MySQL database backups, so if something goes wrong after an update or if you erase some content by accident, we will be able to get the database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

If our custom-developed Hepsia Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be installed on the server along with other essential pieces of software, so you won’t have to do anything if you choose to activate PHP-powered web apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand-new database and begin installing the app manually or through our 1-click installation tool. The system will automatically detect which engine the particular app needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the app can dump its content in that database. Thus, you can make use of apps with various requirements in regard to the MySQL engine without having to make any modifications on your VPS.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you’ll be able to choose any of the 3 hosting Control Panels offered by us – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database engine manually in order to be able to manage PHP script-powered apps that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you require to run large-size sites, it’s pretty likely that you’ll resort to InnoDB. You’ll be able to use other engines too, so in case a particular application needs MyISAM instead of InnoDB, you will not run into any impediment while running it. The engine that will be used will be recognized automatically the moment the app installation procedure commences, so you will not need to tweak any settings manually whatsoever.