InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a lot of pluses that make it the preferred engine for numerous open-source script-driven software apps, such as Joomla and Magento, which have switched to InnoDB permanently. For example, adding immense data volumes will be faster with InnoDB, because it locks only a single row to perform a particular operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. To put it simply, importing new or modifying existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a given problem shows up during the process, which is why the content that remains in the database will not be lost.

InnoDB in Cloud Website Hosting

You can activate any PHP script-based web application that requires InnoDB if you have a cloud website hosting with our company, as the MySQL database storage engine is available on our leading-edge cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is needed. You can install apps which require the MyISAM engine without encountering any impediment as well and, once again, the engine will be selected automatically, so you won’t need to update anything manually at any point. On top of that, we’ll also perform regular backups of all the MySQL databases that you have in your account, so if you delete or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server packages and you start installing a script-driven software app either manually or using our single-click application installer tool, the storage engine for the database will be picked automatically depending on the specific app’s requirements. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any application that requires it without the need for any manual intervention on your end at any moment. To prevent any chance of losing data if you update an application or if you delete a database by accident, we’ll generate a backup of all your MySQL databases each day, so if anything happens, we can retrieve your content.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be activated on the Virtual Private Server along with other required software, so you won’t have to do anything if you choose to run open-source script-driven software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new database and begin the app installation manually or using our one-click installer. The system will detect the engine that the particular app needs 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. Thus, you can manage apps with different prerequisites regarding the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options which you can select on the server order page when you buy a dedicated server from our company. As this is the most powerful kind of website hosting, it is very likely that you’ll run popular sites that will draw many people, and since InnoDB is among the best choices for such websites, we’ll enable it together with all the other software apps that come with a Hepsia-managed server. If you set up a new MySQL database in your dedicated account, there won’t be any active database storage engine till you start installing a PHP script, whether manually through your browser or using the automatic script installation tool that is included in the hosting Control Panel. The necessary engine will be recognized and will be set for that database, so you can run scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without coming across any impediment.