InnoDB is a database engine for MySQL relational databases, which is used by famous script-based web applications like Magento and Joomla 3.x. It’s excellent for scalable applications, because it excels in handling immense data volumes. Instead of locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. Moreover, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that define how data imports and modifications should be treated. If a particular operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept safe and sound and will not be partially mixed with new content.

InnoDB in Website Hosting

Every PHP-powered web application that needs InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the MySQL database storage engine is offered with all our website hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s specifications without having to edit any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will generate regular content backups, so in case you accidentally delete a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore your data the way it was only several hours earlier.

InnoDB in Semi-dedicated Hosting

You can activate a PHP-powered software application that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our advanced cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our single-click app installer. In either case, the needed engine will be chosen automatically as soon as the application’s activation begins, so you will not have to modify anything manually, no matter if the application needs InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to recover any of your MySQL databases in case you unintentionally delete one, as we carry out a couple of database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Hosting

In case our custom-built Hepsia hosting Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the VPS server along with other needed pieces of software, so you will not need to do anything if you decide to install PHP-based software applications that require this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a brand-new database and begin the app installation procedure manually or through our 1-click installer tool. The system will recognize the engine that the particular application requires and will set it for the specific MySQL database, so the installation will continue impeccably and the app can dump its data in that database. In this way, you can run apps with various requirements with regard to the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Web Hosting

All dedicated web hosting that are ordered with our custom-built Hepsia hosting 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 activate it manually if you’d like to use open-source PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to initiate the setup process – as soon as the installation wizard obtains access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to install scripts that need MyISAM, the other popular MySQL engine, so you won’t have to configure any settings on the server. This will permit you to use a variety of scripts on one single machine and to use the latter to its maximum potential.