InnoDB is a storage engine for MySQL relational databases, which is used by popular script-powered software apps such as Magento and Joomla 3. It’s perfect for scalable applications, since it works astonishingly well when managing large amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be handled. If a given operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially merged with newly added content.

InnoDB in Cloud Web Hosting

InnoDB is available with all our cloud web hosting by default, not upon request or as a paid upgrade, so you can activate and run any PHP-powered app that requires the InnoDB storage engine without any impediments as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, no matter if you take advantage of our single-click installation tool or create the database and install the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be certain that you’ll never lose any content if you delete a database by mistake or you overwrite some key information – you simply need to notify us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated servers by default, so the moment you buy a new semi-dedicated account, you can move on and install any script-powered software app that needs this database storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you set up a new database and begin installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set on the basis of the concrete app’s prerequisites. This will permit you to activate and manage InnoDB-specific applications without having to deal with any problem and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we will always have a 1-week-old backup of all your MySQL databases, so if you delete or alter any content by accident, we can easily restore it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to run any script-based web application that needs the MySQL database engine without the need to set up anything manually. You can choose Hepsia on the VPS order page and your brand new Virtual Private Server will be ready within the hour, so you can log in and start creating your websites straight away. When you create a new database and start the app activation process, our system will set the engine for this database automatically. Thus, you can activate various applications at the same time without having to configure anything on the VPS server. You can create a WordPress-based personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven web store that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to pick one of the three Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to activate this MySQL database storage engine manually in order to be able to run PHP-based software applications that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you require to manage large-scale sites, it is quite likely that you will use InnoDB. You will be able to use other engines too, so in case a certain app needs MyISAM rather than InnoDB, you will not experience any difficulty while using it. The engine that will be used will be automatically detected once the app installation process commences, so you will not have to configure any setting manually at any moment.