InnoDB is a very popular database storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has numerous pluses which make it the engine of choice for a lot of PHP script-driven web apps, among them Joomla™ and Magento, which have moved to InnoDB permanently. For example, adding large volumes of data will be faster with InnoDB, as it locks only one row to carry out a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is handled. Put simply, adding new or editing existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case any issue appears during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it’s part of the standard set of services that we’re offering with our cloud website hosting packages. If you would like to use an open-source script-powered web application that needs InnoDB specifically, in order to be installed and to operate correctly, you will not have any problems since the MySQL database storage engine is available on our in-house developed cloud hosting platform. No matter if you create a new MySQL database and install an app manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application needs it instead of MyISAM. Besides the outstanding database failure recovery that InnoDB is offering, we also maintain daily database backups, so that we can swiftly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our semi-dedicated service by default, so as soon as you create a new account, you can move on and activate any script-powered application that requires this particular database engine. Several engines are installed on our cloud website hosting platform, so when you set up a brand new database and begin installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected on the basis of the requirements of the particular application. This will permit you to activate and manage InnoDB-specific applications without any impediment and without needing to edit any settings in your account. To avoid any risk, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or edit any content unintentionally, we can easily rescue it.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be part of the default software bundle that will be installed on your server before we give it to you. You won’t have to set up anything manually and you’ll be able to enable and use any PHP-powered software application that requires InnoDB as soon as your Virtual Private Server is ready, which takes no more than 1 hour after the order process itself. Several engines are available, so whenever you set up a MySQL database using the Hepsia hosting Control Panel, a particular engine will be selected when the app activation begins and our system will automatically detect the engine that is required by the app in question. In case you need MyISAM, for example, you will not have to do anything different from installing the preferred app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All Linux dedicated service that are ordered with our custom Hepsia Control Panel include a software package that’s pre-activated and besides everything else, you will get the InnoDB database engine, so you will not need to activate it manually if you wish to use PHP scripts that require it. All it takes to use such a script is to create a new database and to begin the installation process – as soon as the setup wizard gets access to the database in question and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you won’t have to modify any settings on the server. This will permit you to use a variety of scripts on a single physical server and to use it to its full capabilities.