InnoDB is a storage engine for MySQL relational databases, which is used by widely used script-driven web apps such as Magento and Joomla 3. It is ideal for scalable apps, since it works remarkably well when processing immense amounts of data. Rather than locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same period of time. Furthermore, InnoDB offers an improved crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be treated. If a given operation hasn’t been fully completed for some reason, the action will be rolled back. Thus, the content in the database will be retained safe and sound and won’t be partially merged with newly appended content.

InnoDB in Cloud Website Hosting

You’ll be able to activate any PHP-driven app that requires InnoDB in case you’ve got a cloud website hosting package with us, as the database engine is available on our avant-garde cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can run apps that require the MyISAM engine without encountering any impediment as well and, once again, the engine will be pre-selected, so you will not have to update any setting manually at any moment. Furthermore, we will also make daily backups of all the databases that you’ve got in the shared hosting account, so if you erase or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server packages and you begin installing a script-driven web app either manually or using our single-click app installer, the storage engine for the database will be set automatically depending on the prerequisites of the given application. Since InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that requires it without the need for any manual action on your end at any time. To prevent any chance of losing data if you update an app or if you delete a database by accident, we’ll make a backup of all your MySQL databases each and every day, so if something goes wrong, we can restore your content.

InnoDB in VPS Hosting

If you acquire 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 script-powered application which needs InnoDB, as this particular MySQL database engine is part of the software bundle that will be pre-installed on your server during its setup. When you set up a brand new MySQL database via the Control Panel, you’ll simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the app in question requires it, so you won’t need to do anything else in your VPS account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is among the features that you can select on the server order page when you purchase a dedicated server from our company. Since this is the most powerful type of website hosting, it’s quite likely that you will run popular sites that will draw lots of people, and since InnoDB is one of the very best options for such sites, we’ll install it together with all the other software apps that come with a Hepsia-managed dedicated server. When you create a brand new database in your dedicated server account, there won’t be any activated MySQL storage engine till you start installing a script, whether manually via your web browser or using the automatic script installation tool that is included in the hosting Control Panel. The required engine will be automatically detected and will be assigned to that database, so you can make use of scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without needing to deal with any impediment.