InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-powered applications such as Magento and Joomla v3. It’s ideal for scalable applications, as it performs stunningly well when processing large amounts of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. In addition, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. If a given operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the database content will be preserved intact and won’t be partially mixed with newly inserted content.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any open-source script-powered software application which needs the MySQL database engine without any obstacles as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, regardless of whether you use our single-click installer or create the database and activate the application manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll generate daily backups of all your databases, so you can rest assured that you won’t ever lose any content if you erase a database by mistake or you overwrite some important info – you’ll simply need to notify us and we will restore your data back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you’ll be able to take full advantage of all the features offered by this database engine with any open-source script-driven web app that requires it. InnoDB is among the engines that we have on our cloud hosting platform, so the one that will be selected depends on the requirements of the app in question. You will not have to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer. To be on the safe side, we’ll make daily MySQL database backups, so if something goes wrong following an update or if you erase some data by accident, we will be able to restore the database the way it was on any of the past 7 days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the standard software package that will be installed on your Virtual Private Server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and manage any open-source script-based software app that needs InnoDB when your VPS server is set up, which takes no more than 60 minutes after the order submission procedure itself. A few engines are available, so anytime you set up a database through the Hepsia Control Panel, a particular engine will be picked when the app installation commences and our system will automatically detect which engine is required by the application in question. If you need MyISAM, for instance, you will not need to do anything different than installing the application of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel include a software package that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t need to install it manually in case you want to run scripts that need it. All it takes to use such a script is to set up a new MySQL database and to begin the installation process – as soon as the setup wizard obtains access to the database in question and begins entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to modify any settings on the dedicated server. This will permit you to use various scripts on a single machine and to use it to its full potential.