InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got plenty of advantages that make it the preferred engine for plenty of script-powered apps, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, adding huge amounts of data will be faster with InnoDB, since it locks only one row to complete a particular task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is handled. Put simply, appending new or modifying existent data will either be fully completed, or will be annulled and the operation will be rolled back if any problem shows up during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP-powered software app that requires the storage engine without any difficulty once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, regardless of whether you take advantage of our single-click installer or create the MySQL database and set up the application manually, as long as the app requires it instead of the more popular MyISAM engine. We will keep regular backups of all your databases, so you can be certain that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some crucial information – you’ll just have to inform us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-based web application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud web hosting platform where the storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click app installer tool. Either way, the required engine will be picked automatically once the application’s installation starts, so you will not need to edit anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you accidentally remove one, as we generate a couple of backups every day, each of which is kept for 7 days.

InnoDB in VPS Servers

If you purchase a VPS server from us, you’ll be able to take full advantage of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to manage any script-based application which requires InnoDB, as this particular MySQL storage engine is an integral part of the software bundle that will be installed on your server during its configuration. When you set up a brand new MySQL database through the Control Panel, you’ll just need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question requires it, so you won’t have to do anything else in your VPS account. Similarly, if a certain app 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 choose on the order form when you purchase a dedicated server from us. As this is the most powerful kind of hosting, it’s quite likely that you will manage popular Internet sites that will attract many people, and since InnoDB is among the very best choices for such sites, we will enable it along with all the other software applications that come with a Hepsia-equipped dedicated server. If you set up a brand new MySQL database in your dedicated server 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 script installation tool that is integrated into the Control Panel. The needed engine will be recognized automatically and will be assigned to that database, so you can run scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without any impediments.