InnoDB is a database engine for MySQL databases, which is used by well known open-source script-powered software applications like Joomla v3 and Magento. It’s perfect for scalable applications, because it works incredibly well when processing immense volumes of data. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. In addition, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that determine how data imports and modifications should be handled. In case a given operation has not been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will remain safe and sound and will not be partially mixed with newly imported content.

InnoDB in Hosting

Any script-driven web app that requires InnoDB will function flawlessly on our leading-edge cloud platform and the MySQL database storage engine is offered with all our hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without having to edit any setting in your web hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full potential. We will carry out daily content backups, so if you accidentally erase a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your data the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Hosting

You can run a PHP-based web app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud hosting platform where the database engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer tool. In either case, the required engine will be picked automatically the moment the installation of the application starts, so you won’t need to update anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you erase one by mistake, as we generate a few database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Hosting

In case our custom-developed Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be installed on the server together with other essential software, so you won’t need to do anything if you decide to activate PHP-based apps that require this MySQL database engine. The default MySQL engine, MyISAM, will be installed too. You can set up a brand-new database and begin installing the app manually or through our 1-click installation tool. The system will automatically recognize the engine that the particular application requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can import its data into that database. Therefore, you can make use of applications with various prerequisites about the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Web Hosting

All Linux dedicated hosting services that are ordered with our in-house developed Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB database engine, so you will not need to install it manually if you wish to run scripts that require it. All it takes to install such a script is to set up a new database and to begin the installation process – as soon as the script setup wizard receives access to the database in question 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 required by the particular script. You will also be able to use scripts that require the other widely used MySQL engine, MyISAM, so you will not have to update any settings on the dedicated server. This will enable you to run different scripts on a single machine and to use the latter to its fullest capacity.