InnoDB is a storage engine for MySQL databases, which is used by widely used PHP script-driven web apps like Magento and Joomla™ v3. It’s excellent for scalable apps, because it performs astonishingly well when managing enormous amounts of data. 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 carry out much more tasks for the same length of time. Also, InnoDB offers a faster database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be treated. If a specific operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the database content will remain intact and won’t be partially mixed with newly imported content.

InnoDB in Web Hosting

InnoDB is available with all our Linux web hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP-based app which needs the storage engine without any difficulty as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, no matter if you take advantage of our 1-click installer or create the database and set up the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll perform daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some crucial info – you’ll just need to alert us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-driven app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our cutting-edge cloud hosting platform where the database engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer. In either case, the needed engine will be chosen automatically once the activation of the app begins, so you will not have to configure anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Also, we’ll always be able to restore any of your databases in case you accidentally delete one, as we make several database backups every day, each of which is kept for seven days.

InnoDB in VPS Servers

If our in-house developed Hepsia hosting Control Panel is chosen during the signup process for a new VPS hosting plans , InnoDB will be installed on the server together with other essential pieces of software, so you will not need to do anything if you decide to run PHP script-based web applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new database and start the app installation procedure manually or using our one-click installation tool. The system will automatically detect the engine that the particular app needs and will set it for the specific database, so the installation will proceed flawlessly and the application can dump its content in that database. Thus, you can use apps with various requirements with regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated web hosting plans that are ordered with the Hepsia Control Panel. It’s part of the default software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so once your physical machine is assembled, you’ll be able to sign in and to install any PHP-based software application that needs this particular MySQL database engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine until you start installing an app. As soon as the app installation wizard begins dumping information in the newly created database, the engine will be chosen automatically depending on the prerequisites of the particular app, so you can run both InnoDB and MyISAM without selecting either one explicitly at any moment. Therefore, you can use a vast selection of apps for your sites.