InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got lots of strengths that have made it the engine of choice for plenty of open-source script-based applications, including Magento and Joomla, which have switched over to InnoDB for good. For instance, importing enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a particular operation, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. Simply put, importing new or modifying existing data will either be entirely completed, or will be annulled and the operation will be rolled back if a certain issue shows up during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Cloud Website Hosting

Any open-source script-based application that needs InnoDB will run flawlessly on our cutting-edge cloud hosting platform and the MySQL database engine is offered with all our cloud website hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to get the most out of its full potential. We will generate regular content backups, so if you unintentionally remove a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so as soon as you order a new account, you can move on and install any PHP-driven software application that requires this particular database engine. A couple of engines are installed on our cloud hosting platform, so when you set up a new database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be set depending on the specific app’s requirements. This will permit you to activate and run InnoDB-specific applications without having to deal with any problem and without changing any settings in your semi-dedicated account. To avoid any risk, we will always keep a 1-week-old backup of all your databases, so if you delete or edit any content accidentally, we can quickly restore it.

InnoDB in VPS Servers

If you purchase a VPS server from our company, you will be able to make use of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to manage any PHP script-driven application which requires InnoDB, as the database storage engine is an integral part of the software bundle that will be pre-installed on your Virtual Private Server during its setup. When you set up a brand-new MySQL database via the hosting Control Panel, you just have to begin installing an application – manually or using our app 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 account. Likewise, if a given app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually in case you wish to use open-source PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to start the setup process – once the script installation wizard acquires access to the database and begins entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to configure any settings on the server. This will enable you to install different scripts on a single physical machine and to use it to its maximum capabilities.