InnoDB is a storage engine for MySQL relational databases, which is used by popular open-source script-based applications like Joomla v3 and Magento. It is excellent for scalable applications, because it performs exceptionally well when handling large amounts of data. Rather than locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. Besides, InnoDB offers a much better crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and modifications should be handled. If a particular task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved intact and won’t be partially merged with newly added content.

InnoDB in Cloud Hosting

You’ll be able to activate any PHP script-based web app that requires InnoDB if you’ve got a Linux cloud hosting with our company, as the storage engine is available on our avant-garde cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can install apps which require the MyISAM engine without any obstacles as well and, again, the engine will be selected automatically, so you won’t have to edit any setting manually at any moment. In addition, we’ll also generate daily backups of all the MySQL databases that you’ve got in the account, so if you delete or overwrite something, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to make use of all the features offered by this MySQL database engine with any open-source script-based software application that needs it. It’s one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the particular app’s prerequisites. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we will maintain daily MySQL database backups, so if anything goes wrong following an update or if you delete some content by accident, we will be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you will not have to do anything if you choose to use script-powered applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a brand new database and start the app installation procedure manually or through our single-click installation tool. The system will recognize the engine that the particular application requires and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can insert its data into that database. Therefore, you can use apps with various requirements in regard to the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the features which you can pick on the 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 highly popular sites that will draw many people, and since InnoDB is among the very best choices for such sites, we’ll install it along with all the other software applications that are available with a Hepsia-equipped server. When you set up a brand new database in your dedicated server account, there won’t be any active database storage engine until you begin installing an open-source script, whether manually via your web browser or using the automatic script installer tool that is included in the hosting Control Panel. The required engine will be recognized and will be assigned to that database, so you can use scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having any problem.