InnoDB is a database engine for MySQL databases, which is used by famous PHP-based web applications such as Joomla 3 and Magento. It’s ideal for scalable apps, because it performs exceptionally well when handling huge amounts of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. Also, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be handled. If a specific task has not been fully completed for any reason, the action will be rolled back. Thus, the content in the database will stay safe and sound and will not be partially merged with newly added content.
InnoDB in Website Hosting
You’ll be able to install any open-source script-driven software app that needs InnoDB if you’ve got a website hosting with us, as the MySQL storage engine is present on our advanced cloud hosting platform by default. Throughout 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 run apps that require the MyISAM engine without any problem as well and, once again, the engine will be selected automatically, so you won’t have to configure any setting manually at any moment. What’s more, we will also make regular backups of all the databases that you have in the account, so if you delete or overwrite something, we can easily restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
InnoDB is offered with each of our semi-dedicated servers by default, so the moment you create a new semi-dedicated account, you can move on and activate any script-powered web application that requires this MySQL database storage engine. A few engines are installed on our cloud website hosting platform, so when you create a new database and begin installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the requirements of the given application. This will permit you to install and run InnoDB-specific applications without needing to cope with any obstacle and without having to update any settings in your semi-dedicated account. To take no chances, we will always have a 1-week-old backup of all your databases, so if you remove or edit any content by mistake, we can easily rescue it.
InnoDB in VPS Servers
In case our custom Hepsia Control Panel is picked during the signup process for a new VPS servers , InnoDB will be installed on the VPS server together with other needed software, so you won’t have to do anything if you choose to install PHP script-based applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand new database and begin installing the application manually or through our 1-click installer. The system will recognize the engine that the particular application needs and will set it for the specific database, so the installation process will proceed flawlessly and the app can enter its content into that database. Thus, you can make use of apps with different prerequisites in regard to the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually in case you wish to activate scripts that require it. All it takes to run such a script is to create a new database and to start the setup process – as soon as the installer wizard receives access to the database in question and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to run scripts that need MyISAM – the other very popular MySQL engine, so you will not need to update any settings on the dedicated server. This will allow you to use various scripts on a single physical machine and to use it to its fullest capacity.