InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP script-driven software applications like Joomla v3 and Magento. It’s perfect for scalable applications, as it performs incredibly well when managing huge volumes of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. Furthermore, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that specify how data imports and updates should be treated. In case a given operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be kept intact and won’t be partially merged with newly inserted content.

InnoDB in Shared Hosting

You can install any script-based web application that needs InnoDB if you’ve got a shared hosting service with us, as the MySQL database engine is present on our advanced cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can run apps which require the MyISAM engine without any difficulty as well and, again, the engine will be selected automatically, so you will not need to update anything manually at any point. In addition, we’ll also perform daily backups of all the databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so as soon as you create a new account, you can go on and install any open-source script-based software application that needs this particular MySQL database engine. A few engines are installed on our cloud website hosting platform, so when you set up a brand-new database and start installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set based on the prerequisites of the respective application. This will allow you to activate and run InnoDB-specific apps without needing to cope with any complication and without needing to modify any settings in your account. To take no chances, we’ll always have a 7-day-old backup of all your databases, so if you remove or edit any content by mistake, we can easily retrieve it.

InnoDB in VPS Servers

If our custom-developed Hepsia Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be activated on the VPS server along with other necessary pieces of software, so you won’t have to do anything if you choose to make use of PHP-powered web applications that require this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a new MySQL database and begin the app installation manually or using our one-click installation tool. The system will automatically detect which engine the particular application 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. Therefore, you can run apps with different prerequisites concerning the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

InnoDB comes by default with all Linux dedicated servers that are ordered with the Hepsia Control Panel. It is part of the default software bundle that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is set up, you’ll be able to sign in and to activate any open-source script-powered app that needs this particular database storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app activation wizard begins inserting information into the database, the engine will be picked automatically on the basis of the given app’s requirements, so you can use both MyISAM and InnoDB without selecting either one explicitly at any point. In this way, you can make use of a wide collection of applications for your Internet sites.