InnoDB is a database storage engine for MySQL relational databases, which is used by famous script-powered apps such as Magento and Joomla v3. It is perfect for scalable apps, as it performs really well when processing enormous amounts of data. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same period of time. Besides, InnoDB offers a faster database crash recovery and supports transactions and foreign keys – a set of rules that define how data imports and updates should be treated. In case a particular operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will remain undamaged and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it’s an integral part of the standard set of services offered with our cloud hosting plans. In case you wish to use a PHP-based app that needs InnoDB in particular, in order to be installed and to work correctly, you will not need to deal with any problems since the database storage engine is available on our custom cloud platform. No matter if you set up a new MySQL database and install an app manually or use our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires it rather than MyISAM. Besides the excellent crash recovery offered by InnoDB, we also make regular database backups, so we can swiftly recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can activate a script-powered app that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our leading-edge cloud web hosting platform where the MySQL database storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer tool. Either way, the needed engine will be chosen automatically the moment the application’s installation begins, so you will not need to change anything manually, no matter if the application requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to restore any of your databases if you unintentionally erase one, as we make several MySQL database backups every day, each of which is stored for one whole week.

InnoDB in VPS

In case our in-house developed Hepsia hosting Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be installed on the VPS server along with other required pieces of software, so you won’t need to do anything if you choose to manage PHP-based web apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new database and begin installing the application manually or using our single-click installer tool. The system will detect which engine the application in question requires and will set it for the specific database, so the installation will proceed flawlessly and the app can enter its content into that database. Therefore, you can manage applications with different requirements in regard to the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the options that you can select on the server configuration page when you purchase a dedicated server from our company. As this is the most powerful kind of hosting, it’s quite likely that you will run highly popular Internet sites that will attract a lot of people, and since InnoDB is one of the best choices for such websites, we will install it together with all the other software apps that are available with a Hepsia-managed server. If you create a brand-new database in your account, there won’t be any active MySQL database engine until you start installing a script, whether manually through your Internet browser or using the automatic scripts installer tool that is included in the Control Panel. The needed engine will be recognized and will be set for the database in question, so you can use scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without the need to cope with any difficulty.