InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has plenty of strengths which have made it the preferred engine for lots of open-source script-driven web applications, including Joomla and Magento, which have shifted over to InnoDB permanently. For instance, importing enormous data volumes will be much faster with InnoDB, since it locks only a single row to accomplish an operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. Simply put, appending new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case a certain issue occurs during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server plans and you begin installing a script-based web application either manually or using our single-click app installer tool, the MySQL database storage engine will be set automatically depending on the prerequisites of the app in question. As InnoDB is present on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any point. To avoid any risk of losing info if you update an application or if you erase a database accidentally, we’ll carry out backups of all your databases each and every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Servers

When you obtain a VPS server from our company, you will be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to install any PHP-based software app which needs InnoDB, as this particular storage engine is an essential part of the default software package that will be pre-installed on the VPS server during its creation. When you set up a new database using the hosting Control Panel, you will simply need to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you won’t have to do anything else in your VPS account. Equivalently, if an app requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you will not have to add it manually in case you would like to use open-source scripts that need it. All it takes to use such a script is to create a new database and to begin the setup process – as soon as the installation wizard obtains access to the database and begins importing content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will allow you to run a variety of scripts on a single physical machine and to use it to its full potential.