InnoDB is a very popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has a number of upsides that have made it the preferred engine for many PHP script-driven web applications, including Joomla and Magento, which have switched to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, as it locks only a single row to perform a certain task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is handled. Simply put, importing new or updating existent data will either be fully completed, or will be aborted and the procedure will be rolled back if a given problem shows up during the process, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with other website hosting service providers, it’s part of the standard set of services that we’re offering with our cloud website hosting plans. If you wish to use an open-source script-driven web application that needs InnoDB particularly, in order to be installed and to operate correctly, you won’t encounter any problems because the MySQL database engine is available on our in-house developed cloud platform. Regardless of whether you set up a brand-new database and install an app manually or take advantage of our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it rather than MyISAM. Besides the excellent database crash recovery offered by InnoDB, we also keep regular backups of all databases, so that we can swiftly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel provided with all our semi-dedicated server packages and you begin installing an open-source script-based web app either manually or using our one-click application installer tool, the database storage engine will be set automatically on the basis of the prerequisites of the specific application. Since InnoDB is available 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 app that requires it without any manual intervention needed on your end at any time. To prevent any chance of losing data if you update an application or if you remove a database accidentally, we’ll make a backup of all your databases every day, so if something happens, we can retrieve your data.

InnoDB in VPS Servers

When you acquire a VPS server from us, you’ll be able to take advantage of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to activate any PHP-based application which requires InnoDB, as the database storage engine is part of the default software package that will be installed on your server during its creation. When you set up a brand new MySQL database using the hosting Control Panel, you will simply have to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine if the app in question requires it, so you won’t need to do anything else in your account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options which you can select on the order page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it is pretty likely that you’ll manage highly popular websites that will attract a lot of people, and since InnoDB is one of the best choices for such Internet sites, we will install it together with all the other software apps that are offered with a Hepsia-equipped dedicated server. If you set up a new database in your dedicated account, there won’t be any activated database storage engine till you start installing a script, whether manually via your Internet browser or using the automatic scripts installer that is included in the hosting Control Panel. The needed engine will be recognized and will be assigned to the database in question, so you can install scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without any obstacles.