InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-powered applications like Joomla v3 and Magento. It’s excellent for scalable applications, since it performs remarkably well when handling huge amounts of data. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute much more tasks for the same length of time. Plus, InnoDB offers a much faster database crash recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and updates should be treated. If a specific task has not been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will stay intact and won’t be partially mixed with newly added content.
InnoDB in Shared Website Hosting
You can activate any open-source script-based web application that needs InnoDB if you have a shared website hosting plan with us, as the database engine is present on our leading-edge cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is needed. You can run applications which require the MyISAM engine without any problem as well and, once again, the engine will be pre-selected, so you will not need to change anything manually at any moment. What’s more, we’ll also create daily backups of all the databases that you’ve got in your shared account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated hosting plans by default, so the moment you obtain a new account, you can go ahead and install any PHP script-driven web app that needs this MySQL storage engine. Several engines are pre-installed on our cloud web hosting platform, so when you set up a brand-new MySQL database and start installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be picked based on the respective app’s prerequisites. This will permit you to activate and run InnoDB-specific applications without the need to deal with any difficulty and without changing any settings in your account. To be on the safe side, we’ll always have a 1-week-old backup of all your MySQL databases, so if you remove or change any content by mistake, we can easily retrieve it.
InnoDB in VPS Servers
If our in-house built Hepsia Control Panel is selected during the registration process for a new VPS plans , InnoDB will be installed on the server along with other required software, so you will not need to do anything if you decide to install PHP script-based software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand-new database and start installing the application manually or using our one-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 proceed impeccably and the application can import its content into that database. Therefore, you can manage applications with different requirements regarding the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options which you can choose on the server order page when you buy a dedicated server from us. As this is the most powerful type of website hosting, it is pretty likely that you will run very popular websites that will draw plenty of people, and since InnoDB is among the very best choices for such Internet sites, we will enable it together with all the other software applications that come with a Hepsia-managed server. When you create a brand new MySQL database in your account, there won’t be any active MySQL database engine till you start installing a PHP script, whether manually via your web browser or using the automatic script installer that is integrated into the Control Panel. The necessary engine will be detected automatically and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without needing to cope with any difficulty.