InnoDB is a database storage engine for MySQL databases, which is used by well known script-powered web applications like Magento and Joomla 3. It’s ideal for scalable applications, since it works amazingly well when processing huge amounts of data. Instead of locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same period of time. Also, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be treated. If a given operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved undamaged and won’t be partially mixed with newly imported content.

InnoDB in Cloud Hosting

Every PHP-powered app that needs InnoDB will function impeccably on our cutting-edge cloud platform and the database storage engine is available with all our cloud hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to change any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We’ll store regular backups of your content, so if you accidentally erase a database that is important to you or you overwrite some part of it, we will be able to restore your content the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so as soon as you purchase a new account, you can go ahead and activate any PHP script-powered application that needs this particular database storage engine. A number of engines are installed on our cloud web hosting platform, so when you create a new MySQL database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the requirements of the specific application. This will permit you to install and manage InnoDB-specific apps without having to deal with any difficulty and without the need to modify any settings in your account. To avoid any risk, we will always have a one-week-old backup of all your MySQL databases, so if you remove or change any content by accident, we can swiftly recover it.

InnoDB in VPS Servers

If our in-house built Hepsia hosting Control Panel is picked during the signup process for a new VPS servers , InnoDB will be activated on the Virtual Private Server along with other necessary software, so you won’t have to do anything if you choose to install open-source script-driven software apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new MySQL database and start the app installation manually or through our single-click installer tool. The system will recognize the engine that the particular app requires and will assign it to the specific MySQL database, so the installation will continue impeccably and the application can enter its content into that database. Therefore, you can make use of applications with various requirements concerning the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you’ll be able to select any of the three hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this database engine manually in order to be able to use PHP-powered software applications that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the system resources that you need to run very large websites, it is rather likely that you will resort to InnoDB. You will be able to make use of other engines as well, so in case a particular app needs MyISAM rather than InnoDB, you won’t need to deal with any difficulty while managing it. The engine that will be used will be recognized automatically as soon as the app installation process commences, so you won’t have to configure any setting manually at any moment.