InnoDB is a popular database engine for MySQL. It’s an alternative to the default MyISAM engine and it has many upsides which have made it the engine of choice for many open-source script-powered web applications, including Magento and Joomla, which have switched to InnoDB permanently. For instance, adding immense data volumes will be much faster with InnoDB, as it locks only one row to complete a specific task, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. In simpler words, importing new or updating existing data will either be fully completed, or will be annulled and the operation will be rolled back in case a certain issue shows up during the process, therefore the content that remains in the database won’t be damaged.

InnoDB in Shared Web Hosting

Every script-driven web app that requires InnoDB will function flawlessly on our leading-edge cloud website hosting platform and the MySQL database engine comes with all our shared web hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to change any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to take advantage of its full potential. We will make regular content backups, so if you unintentionally erase a MySQL database that you need or you overwrite specific parts of it, we’ll be able to restore your data the way it was just several hours ago.

InnoDB in Semi-dedicated Hosting

You can run a PHP-powered application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our leading-edge cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our one-click app installer tool. Either way, the required engine will be picked automatically the moment the activation of the app begins, so you won’t have to update anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to recover any of your databases in case you remove one by accident, as we create several database backups every day, each of which is preserved for seven days.

InnoDB in VPS Hosting

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be part of the software pack that will be installed on your VPS server before we hand it over to you. You will not need to activate anything manually and you will be able to enable and run any open-source script-powered web app that requires InnoDB once your VPS is ready, which takes no more than 60 minutes after the order submission procedure itself. A few engines are offered, so whenever you create a database using the Hepsia hosting Control Panel, a particular engine will be selected when the app installation starts and our system will automatically recognize which engine is required by the app in question. In case you need MyISAM, for example, you won’t have to do anything different than installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Web Hosting

All dedicated servers hosting packages ordered with our in-house developed Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database engine, so you will not have to activate it manually in case you wish to run open-source 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 – once the script installation wizard acquires access to the database in question and begins inserting data 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 install scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to edit any settings on the dedicated server. This will allow you to install a variety of scripts on one single physical machine and to use it to its fullest capacity.