InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a better overall performance and an improved database crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by numerous programmers that build scalable apps, because it works much better with enormous volumes of data, while it keeps the server load low. Moreover, it locks only one database row if any info should be edited, while many other engines lock the entire table and hence require much more time to complete several sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the latest editions of Joomla™ are two instances of widely used PHP-driven apps that have switched to InnoDB.

InnoDB in Cloud Hosting

You can use any PHP-powered app that needs InnoDB if you have a Linux cloud hosting with our company, as the MySQL database engine is present on our leading-edge cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can run applications which require the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you won’t have to edit any setting manually at any moment. On top of that, we’ll also create regular backups of all the databases that you’ve got in the shared account, so if you delete or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our Linux semi-dedicated hosting plans by default, so once you create a new account, you can move on and activate any script-based app that requires the MySQL database storage engine. A number of engines are installed on our cloud website hosting platform, so when you set up a brand-new MySQL database and begin installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set depending on the requirements of the given application. This will permit you to install and manage InnoDB-specific applications without encountering any complication and without needing to edit any settings in your semi-dedicated account. To be on the safe side, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or edit any content by accident, we can easily rescue it.

InnoDB in VPS Servers

In case our custom Hepsia Control Panel is picked during the signup process for a new VPS plans , InnoDB will be activated on the VPS server together with other needed pieces of software, so you won’t have to do anything if you decide to activate script-driven apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be installed as well. You can create a brand-new database and begin the app installation process manually or using our 1-click installer tool. The system will detect which engine the app in question needs and will set it for the specific database, so the installation will proceed impeccably and the app can import its data into that database. Therefore, you can activate apps with different requirements with regard to the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features which you can select on the order form when you purchase a dedicated server from us. Since this is the most powerful kind of website hosting, it is quite likely that you’ll manage very popular websites that will attract many people, and since InnoDB is among the very best choices for such Internet sites, we will enable it along with all the other software apps that come with a Hepsia-managed server. When you set up a brand new database in your dedicated account, there won’t be any active database storage engine till you start installing a script, whether manually through your browser or using the automatic scripts installer that is available in the Control Panel. The required engine will be recognized automatically and will be set for that database, so you can run scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without the need to cope with any problem.