InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got a lot of advantages that have made it the engine of choice for lots of script-based web apps, among them Magento and Joomla, which have switched to InnoDB for good. For instance, importing large data volumes will be much faster with InnoDB, since it locks only one database row to complete a certain task, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, importing new or editing existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a certain problem appears in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with other web hosting providers, it is an integral part of the default set of services offered with our web hosting packages. If you wish to use a PHP-powered web application that requires InnoDB specifically, in order to be activated and to perform properly, you won’t come across any obstacles since the InnoDB storage engine is available on our in-house built cloud Internet hosting platform. No matter if you create a brand new MySQL database and install an app manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application requires it instead of MyISAM. In addition to the excellent crash recovery that InnoDB is offering, we also keep regular database backups, so we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can use a script-driven web app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our advanced cloud web hosting platform where the MySQL database storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our single-click application installer tool. In either case, the needed engine will be selected automatically the moment the app’s activation begins, so you will not have to update anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you remove one by accident, as we create several MySQL database backups every day, each of which is saved for 1 week.

InnoDB in VPS

In case our custom-built Hepsia Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be activated on the server together with other needed pieces of software, so you won’t need to do anything if you decide to manage PHP-powered apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand new MySQL database and start the app installation manually or through our single-click installer. The system will detect which engine the app in question needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the app can insert its content into that database. Thus, you can use apps with various requirements with regard to the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our in-house built Hepsia Control Panel include a software package that is pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not need to activate it manually if you’d like to run open-source PHP scripts that need it. All it takes to run such a script is to set up a new MySQL database and to initiate the setup process – as soon as the installer wizard obtains access to the database and begins 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 particular script. You’ll also be able to run scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will allow you to install different scripts on a single physical server and to use it to its maximum capabilities.