Learn more about InnoDB and see why it’s been picked out as the default MySQL database engine.
InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven web applications like Magento and Joomla™ v3. It’s ideal for scalable applications, because it performs exceptionally well when processing large data volumes. Rather than locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same length of time. In addition, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – rules that specify how data imports and updates should be treated. In case a particular task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will be kept safe and sound and won’t be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
You’ll be able to use any PHP-powered software application that needs InnoDB if you’ve got a shared web hosting plan
with our company, as the MySQL storage engine is available on our cutting-edge cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can run applications which require the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you will not need to modify anything manually at any moment. In addition, we will also carry out regular backups of all the databases that you have in your account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.
InnoDB in VPS Servers
In case our custom Hepsia hosting Control Panel is picked during the registration process for a new VPS hosting plans
, InnoDB will be installed on the server along with other necessary pieces of software, so you will not have to do anything if you choose to make use of open-source script-based web applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand new database and start the app installation process manually or through our single-click installation tool. The system will detect the engine that the app in question needs and will set it for the specific database, so the installation will proceed flawlessly and the application can enter its data into that database. Thus, you can activate apps with various prerequisites with regard to the MySQL engine without having to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you will get the InnoDB database engine, so you will not need to add it manually if you would like to run PHP scripts that need it. All it takes to run such a script is to set up a new database and to initiate the setup process – as soon as the setup wizard gains access to the database and begins entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to install scripts that require the other popular MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will permit you to run a variety of scripts on one single physical server and to use it to its full capabilities.