InnoDB is a popular database engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got numerous strengths that have made it the preferred engine for a lot of PHP script-driven web applications, among them Joomla™ and Magento, which have switched to InnoDB permanently. For example, importing immense data volumes will be faster with InnoDB, since it locks only one row to accomplish a particular operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, adding new or modifying existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a given issue appears during the process, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Web Hosting

You can make use of any PHP-based app that requires InnoDB in case you’ve got a cloud web hosting with our company, as the database engine is present on our innovative cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can run applications that use the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be selected automatically, so you will not need to edit any setting manually at any time. Furthermore, we’ll also make regular backups of all the databases that you have in the account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server plans and you start installing a PHP script-powered software application either manually or using our one-click application installer, the storage engine for the database will be set automatically depending on the prerequisites of the app in question. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any point. To avoid any chance of losing information if you update an application or if you erase a database accidentally, we will make a backup of all your MySQL databases each and every day, so if something goes wrong, we can rescue your content.

InnoDB in VPS Servers

In case our in-house built Hepsia Control Panel is chosen during the signup process for your new VPS hosting plans , InnoDB will be installed on the server together with other needed pieces of software, so you won’t have to do anything if you choose to manage PHP-based applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed too. You can create a new database and begin the app installation procedure manually or using our 1-click installer. The system will automatically detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can enter its content into that database. Thus, you can make use of applications with different prerequisites about the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can select on the server configuration page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it’s rather likely that you’ll run popular Internet sites that will draw a lot of individuals, and since InnoDB is one of the best choices 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 MySQL database in your dedicated account, there won’t be any active storage engine till you start installing a script, whether manually via your browser or using the automatic script installer that is integrated into the hosting Control Panel. The necessary engine will be automatically recognized and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without coming across any difficulty.