', 'auto'); ga('send', 'pageview'); InnoDB
InnoDB is a database engine for MySQL relational databases, which is used by widely used open-source script-based web applications such as Magento and Joomla 3. It is excellent for scalable apps, as it works very well when handling enormous amounts of data. Instead of locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same period of time. Also, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that prescribe how data imports and updates should be treated. In case a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will be kept safe and sound and will not be partially merged with newly imported content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with other website hosting service providers, it’s an integral part of the standard set of features that we offer with our shared web hosting plans. In case you’d like to use a script-powered app that needs InnoDB in particular, in order to be installed and to operate correctly, you will not encounter any difficulties because the MySQL database storage engine is available on our custom-built cloud web hosting platform. Regardless of whether you set up a new database and install an app manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires it rather than MyISAM. In addition to the amazing database failure recovery that InnoDB is offering, we also carry out daily database backups, so that we can swiftly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you can get the most out of all the options offered by this database storage engine with any PHP script-driven web app that needs it. It’s one of the engines that are available on our cloud website hosting platform, so the one that will be selected depends on the requirements of the respective app. You won’t need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To avoid any risk, we’ll keep regular backups of all your MySQL databases, so if anything goes wrong following an update or if you delete some content by accident, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the server together with other necessary pieces of software, so you will not need to do anything if you decide to run PHP script-based applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new database and begin installing the application manually or through our 1-click installation tool. The system will automatically detect the engine that the particular application needs and will set it for the specific database, so the installation will proceed flawlessly and the app can enter its content into that database. Thus, you can make use of apps with various prerequisites concerning the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t have to add it manually in case you want to run open-source PHP scripts that need it. All it takes to use such a script is to create a new database and to initiate the setup process – as soon as the script configuration wizard acquires access to the database and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You’ll also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to modify any settings on the dedicated server. This will enable you to install different scripts on a single physical machine and to use the latter to its fullest potential.