InnoDB is a database engine for MySQL databases, which is used by widespread script-based software apps such as Joomla™ 3 and Magento. It’s ideal for scalable apps, because it works amazingly well when handling enormous amounts of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same period of time. Plus, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – rules that indicate how data imports and updates should be treated. In case a given task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be kept safe and sound and won’t be partially merged with newly added content.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP-driven app which needs the InnoDB storage engine without having any difficulty as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, irrespective of whether you take advantage of our 1-click installer or create the database and set up the app manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll maintain regular MySQL database backups, so you can be sure that you’ll never lose any content in case you delete a database by accident or you overwrite some vital info – you just need to touch base with us and we will restore everything the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated hosting by default, so once you buy a new account, you can go on and activate any PHP-based web app that needs this database engine. Several engines are installed on our cloud website hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked based on the given app’s requirements. This will allow you to activate and manage InnoDB-specific apps without coming across any impediment and without changing any settings in your account. To take no chances, we’ll always keep a seven-day-old backup of all your databases, so if you delete or edit any content by mistake, we can quickly restore it.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia hosting Control Panel is chosen during the signup process for your new Linux VPS web hosting packages , InnoDB will be installed on the VPS server together with other required pieces of software, so you won’t need to do anything if you decide to make use of script-powered web apps that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and start installing the app manually or through our one-click installer. The system will automatically detect which engine the particular application requires and will assign it to the specific MySQL database, so the installation process will continue flawlessly and the app can import its content into that database. Therefore, you can activate applications with different requirements regarding the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

InnoDB is included as standard with all dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It is an integral part of the software package that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you will be able to log in and to activate a various PHP script-driven app that needs this MySQL storage engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app installation wizard begins importing content into the database, the engine will be chosen automatically depending on the particular app’s prerequisites, so you can use both MyISAM and InnoDB without the need to select either one of them explicitly at any point. Therefore, you can make use of a vast collection of applications for your sites.