Learn what a database engine is, what are the benefits of the InnoDB engine and why it is gaining so much global popularity.
InnoDB is a database engine for MySQL databases, which is used by widespread PHP script-driven software applications such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, because it works astonishingly well when handling enormous amounts of data. Instead of locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same period of time. Besides, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and updates should be treated. If a certain operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be retained intact and won’t be partially merged with new content.
InnoDB in Shared Web Hosting
InnoDB is available with all our shared web hosting plans
by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-driven web app which requires the storage engine without any impediments as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, irrespective of whether you make use of our one-click installer or create the database and set up the app manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll perform regular database backups, so you can be sure that you will never lose any content if you delete a database unintentionally or you overwrite some essential information – you’ll just have to contact us and we will restore everything back to normal.
InnoDB in Semi-dedicated Servers
You can activate an open-source script-based software app that requires InnoDB with all of our semi-dedicated server
plans, since all the accounts are set up on our leading-edge cloud web hosting platform where the MySQL database engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our single-click application installer tool. Either way, the required engine will be picked automatically the moment the activation of the application begins, so you won’t have to modify anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. On top of that, we will always be able to restore any of your databases in case you accidentally remove one, as we carry out several backups every day, each of which is kept for 1 whole week.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is chosen during the signup process for a new VPS web hosting plans
, InnoDB will be activated on the server together with other essential pieces of software, so you won’t have to do anything if you choose to use PHP script-driven software apps that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a brand new MySQL database and start the app installation process manually or using our one-click installer tool. The system will recognize the engine that the particular application requires and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the application can import its content into that database. In this way, you can install applications with different requirements with regard to the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated web hosting plans
ordered with the Hepsia Control Panel. It’s an integral part of the standard software bundle that we install on all Hepsia-equipped dedicated servers, so once your physical machine is assembled, you will be able to log in and to install any PHP script-powered web app that requires this database engine. If you create a new database via the hosting Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app setup wizard begins dumping data in the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can run both MyISAM and InnoDB without selecting either one of them explicitly at any time. In this way, you can make use of a broad range of applications for your Internet sites.