InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has lots of pluses that make it the preferred engine for plenty of PHP-based apps, among them Magento and Joomla, which have moved to InnoDB for good. For instance, importing huge amounts of data will be faster with InnoDB, due to the fact that it locks only a single database row to accomplish a task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is tackled. Simply put, appending new or modifying existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a given problem shows up during the process, which is why the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with other hosting service providers, it’s part of the default set of services that we are offering with our cloud hosting packages. If you wish to use a script-powered software app that requires InnoDB in particular, in order to be installed and to work correctly, you won’t have any obstacles because the MySQL database engine is available on our custom-developed cloud website hosting platform. Irrespective of whether you set up a brand-new MySQL database and activate an application manually or use our 1-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB rather than MyISAM. Besides the incredible database failure recovery that InnoDB is offering, we also perform regular backups of all databases, so that we can swiftly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can use a script-powered web app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our innovative cloud platform where the storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click application installer. Either way, the required engine will be selected automatically the moment the installation of the application begins, so you won’t need to edit anything manually, irrespective of whether the application requires InnoDB or the more commonly used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases if you delete one by accident, as we carry out several backups every day, each of which is kept for 1 week.

InnoDB in VPS Hosting

In case our custom-built Hepsia Control Panel is chosen during the registration process for your new Linux virtual private servers , InnoDB will be activated on the VPS server together with other needed software, so you won’t need to do anything if you choose to manage PHP script-driven software apps that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand new MySQL database and start the app installation procedure manually or using our one-click installation tool. The system will detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation will proceed flawlessly and the application can dump its data in that database. In this way, you can run apps with various prerequisites regarding the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is one of the options which you can pick on the server order page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s rather likely that you’ll manage highly popular websites that will draw lots of people, and since InnoDB is among the best options for such websites, we’ll enable it along with all the other software apps that come with a Hepsia-managed server. When you set up a new MySQL database in your dedicated server account, there won’t be any active storage engine till you begin installing a PHP script, whether manually through your browser or using the automatic script installer that is available in the hosting Control Panel. The necessary engine will be detected automatically and will be set for the database in question, so you can use scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without any problem.