InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a much better overall performance and an improved crash recovery compared with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is endorsed by lots of programmers that run scalable web applications, due to the fact that it works better with enormous amounts of data, while it keeps the server processing load low. In addition, it it locks only one row in the database if anything should be updated, while many other engines lock the entire database table and hence require much more time to handle multiple successive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for some reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest editions of Joomla™ are two instances of popular script-powered software apps that have shifted over to InnoDB.

InnoDB in Web Hosting

You will be able to use any script-driven software application that needs InnoDB if you’ve got a web hosting with our company, as the MySQL database storage engine is available on our advanced cloud website hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can activate applications which need the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be selected automatically, so you will not have to update anything manually at any moment. In addition, we will also create regular backups of all the MySQL databases that you’ve got in the account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated servers by default, so as soon as you buy a new account, you can go ahead and activate any script-powered software app that requires this particular storage engine. A couple of engines are pre-installed on our cloud platform, so when you set up a new MySQL database and begin installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be picked depending on the prerequisites of the given app. This will permit you to activate and manage InnoDB-specific applications without running into any problem and without needing to modify any settings in your semi-dedicated account. To take no chances, we will always have a 7-day-old backup of all your MySQL databases, so if you remove or alter any content by mistake, we can swiftly restore it.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be installed on the VPS server together with other needed software, so you will not have to do anything if you choose to run open-source script-driven software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a new database and begin the app installation process manually or using our 1-click installation tool. The system will recognize the engine that the app in question needs and will set it for the specific database, so the installation process will continue flawlessly and the application can insert its data into that database. Therefore, you can activate apps with different requirements in regard to the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-built Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t need to activate it manually in case you need to use open-source PHP scripts that need it. All it takes to run such a script is to set up a new database and to initiate the installation – as soon as the script setup wizard receives access to the database in question and begins inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that require MyISAM – the other widely used MySQL engine, so you will not need to change any settings on the dedicated server. This will enable you to install different scripts on a single physical server and to use it to its maximum capabilities.