InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-powered apps such as Joomla 3 and Magento. It is ideal for scalable applications, since it works astonishingly well when handling large data volumes. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same period of time. What’s more, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and modifications should be handled. If a specific task has not been entirely completed for some reason, the action will be rolled back. In this way, the database content will remain undamaged and will not be partially mixed with newly imported content.
InnoDB in Web Hosting
InnoDB is offered with all our web hosting service by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-driven web application that needs the InnoDB database engine without having to deal with any impediment once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation, regardless of whether you make use of our one-click installation tool or create the MySQL database and set up the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will create regular MySQL database backups, so you can be certain that you won’t ever lose any data in case you delete a database accidentally or you overwrite some crucial info – you will simply have to alert us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our Linux semi-dedicated servers by default, so as soon as you purchase a new semi-dedicated account, you can go on and activate any PHP script-based software application that requires this MySQL database storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you create a new MySQL database and begin installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be selected based on the prerequisites of the particular application. This will allow you to install and manage InnoDB-specific applications without the need to cope with any problem and without needing to change any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your MySQL databases, so if you erase or edit any content by mistake, we can quickly restore it.
InnoDB in VPS Servers
In case our custom Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server along with other necessary pieces of software, so you won’t need to do anything if you choose to manage script-powered applications that require this MySQL storage engine. The default MySQL engine, MyISAM, will be installed as well. You can create a new MySQL database and begin installing the application manually or through our 1-click installer tool. The system will automatically detect the engine that the particular application needs and will assign it to the specific database, so the installation process will proceed flawlessly and the app can insert its data into that database. Therefore, you can install applications with various prerequisites with regard to the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Servers
All Linux dedicated servers ordered with our custom Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not need to activate it manually in case you would like to run scripts that require it. All it takes to run such a script is to create a new database and to initiate the installation – as soon as the setup wizard receives access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to use scripts that require MyISAM – the other widely used MySQL engine, so you will not need to modify any settings on the dedicated server. This will enable you to activate a variety of scripts on one single physical machine and to use it to its fullest capacity.