InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP script-based web applications like Magento and Joomla 3.x. It’s ideal for scalable apps, since it works very well when handling huge volumes of data. Instead of locking the entire database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Also, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be treated. If a particular task has not been fully completed for any reason, the action will be rolled back. Thus, the content in the database will be retained safe and sound and won’t be partially mixed with newly added content.

InnoDB in Shared Website Hosting

You’ll be able to run any script-driven app that requires InnoDB if you’ve got a shared website hosting plan with us, as the storage engine is present on our leading-edge cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can activate applications that require the MyISAM engine without having any problem as well and, once again, the engine will be selected automatically, so you won’t have to change any setting manually at any time. What’s more, we will also make daily backups of all the MySQL databases that you’ve got in the shared account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the hosting Control Panel included with each of our semi-dedicated server packages and you start installing a PHP-powered web application either manually or using our one-click application installer tool, the storage engine for the database will be selected automatically based on the prerequisites of the specific application. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any time. To avoid any chance of losing data if you update an application or if you erase a database by mistake, we will carry out a backup of all your MySQL databases each and every day, so if something goes wrong, we can retrieve your data.

InnoDB in VPS Servers

When you order a VPS server from us, you’ll be able to take advantage of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP-driven app that needs InnoDB, as this particular MySQL storage engine is included in the default software package that will be pre-installed on the VPS server during its configuration. When you create a new database using the Control Panel, you’ll simply need to start installing an app – manually or using our application installer. InnoDB will be set as the default engine in case the application in question requires it, so you won’t have to do anything else in your VPS account. Likewise, if a given app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features which you can pick on the order page when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it’s quite likely that you will run very popular websites that will draw a lot of individuals, and since InnoDB is one of the best choices for such websites, we’ll install it along with all the other software apps that come with a Hepsia-equipped server. When you create a brand new database in your account, there won’t be any active database engine until you begin installing an open-source script, whether manually through your web browser or using the automatic scripts installer that is available in the Control Panel. The required engine will be recognized and will be assigned to the database in question, so you can make use of scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without encountering any impediment.