InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-based apps like Magento and Joomla 3. It’s perfect for scalable apps, as it works exceptionally well when processing large volumes of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Besides, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and modifications should be handled. If a particular operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will remain undamaged and will not be partially merged with new content.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-powered web application which requires the MySQL database engine without having any problem once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, irrespective of whether you use our 1-click installer or create the MySQL database and activate the application manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll carry out daily MySQL database backups, so you can rest assured that you’ll never lose any data in case you delete a database by mistake or you overwrite some vital information – you will simply need to notify us and we will restore your data back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel included with all our semi-dedicated server accounts and you start installing an open-source script-based web app either manually or using our 1-click app installer, the storage engine for the database will be picked automatically depending on the prerequisites of the particular app. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any point. To prevent any chance of losing info if you update an app or if you delete a database by accident, we’ll generate a backup of all your databases every day, so if anything goes wrong, we can restore your data.

InnoDB in VPS Servers

If you get a VPS server from our company, you’ll be able to use our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to activate any open-source script-powered software app that requires InnoDB, as this particular database storage engine is included in the default software package that will be pre-installed on your server during its creation. When you create a brand-new MySQL database through the hosting Control Panel, you simply need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t need to do anything else in your VPS account. Similarly, if an app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can choose 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’s quite likely that you’ll manage highly popular websites that will draw plenty of individuals, and since InnoDB is one of the best options for such websites, we will enable it together with all the other software apps that come with a Hepsia-equipped dedicated server. When you set up a brand new database in your account, there won’t be any activated database storage engine till you begin installing an open-source PHP script, whether manually through your web browser or using the automatic scripts installation tool that is available in the Control Panel. The needed engine will be recognized automatically and will be set for the database in question, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without the need to deal with any complication.