InnoDB is a popular storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of strengths which make it the preferred engine for lots of PHP-powered applications, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding large data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to perform a specific task, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. In simpler words, appending new or updating existing data will either be fully completed, or will be annulled and the operation will be rolled back if a given issue shows up in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Hosting

InnoDB is available with all our hosting plans by default, not as a paid upgrade or upon request, so you can install and run any PHP script-powered software app which needs the MySQL database storage engine without encountering any difficulty once you activate your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, irrespective of whether you use our one-click installer or create the MySQL database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will store regular backups of all your MySQL databases, so you can be sure that you will never lose any data in case you delete a database by mistake or you overwrite some crucial info – you simply have to notify us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

You can install a PHP script-driven software app that requires InnoDB with all of our semi-dedicated server packages, because all the accounts are created on our avant-garde cloud web hosting platform where the MySQL database storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our single-click application installer tool. In either case, the required engine will be chosen automatically once the application’s installation starts, so you won’t have to configure anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you unintentionally remove one, as we generate a couple of MySQL database backups every day, each of which is kept for 1 week.

InnoDB in VPS Servers

If you obtain a VPS server from our company, you’ll be able to take full advantage of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to run any PHP-powered web application which requires InnoDB, as this MySQL database engine is part of the standard software package that will be installed on your VPS server during its creation. When you set up a brand-new MySQL database through the hosting Control Panel, you’ll simply have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you won’t need to do anything else in your account. Analogously, if an application needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom Hepsia Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t need to add it manually if you need to activate open-source PHP scripts that require it. All it takes to run such a script is to create a new database and to begin the installation process – as soon as the setup wizard obtains access to the database and begins entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to run scripts that require MyISAM, the other popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will allow you to activate different scripts on a single machine and to use the latter to its maximum potential.