InnoDB is a database storage engine for MySQL databases, which is used by popular PHP-driven web apps such as Magento and Joomla 3. It’s excellent for scalable applications, because it works remarkably well when processing large data volumes. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. In addition, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. In case a given operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and will not be partially mixed with newly entered content.

InnoDB in Web Hosting

Every script-powered web app that needs InnoDB will function flawlessly on our innovative cloud platform and the MySQL storage engine comes with all our web hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected on the basis of the app’s specifications without the need to update any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to get the most out of its full potential. We’ll store regular content backups, so if you accidentally delete a MySQL database that is important to you or you overwrite some part of it, we will be able to restore your database the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP-powered application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our advanced cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our 1-click app installer tool. Either way, the required engine will be selected automatically once the installation of the app starts, so you will not have to configure anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. Also, we’ll always be able to restore any of your databases in case you accidentally erase one, as we carry out a couple of MySQL database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS

In case our in-house built Hepsia hosting Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be activated on the server along with other necessary pieces of software, so you won’t have to do anything if you choose to use script-powered web apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand-new MySQL database and begin installing the application manually or using our 1-click installation tool. The system will automatically detect the engine that the particular application needs and will set it for the specific database, so the installation process will continue flawlessly and the application can enter its content into that database. Therefore, you can manage applications with various prerequisites with regard to the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom Hepsia Control Panel include a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to install it manually if you would like to run open-source scripts that need it. All it takes to activate such a script is to create a new database and to initiate the installation process – as soon as the installation wizard gains access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to run scripts that need the other popular MySQL engine, MyISAM, so you won’t need to update any settings on the dedicated server. This will allow you to use a variety of scripts on one single machine and to use it to its maximum capacity.