InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has many strengths that have made it the preferred engine for a lot of open-source script-driven applications, such as Magento and Joomla, which have switched to InnoDB for good. For instance, importing enormous amounts of data will be faster with InnoDB, because it locks only one row to accomplish a specific operation, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is treated. Put simply, appending new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back if a given issue occurs in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with other web hosting providers, it is an essential part of the standard set of features that we’re offering with our web hosting packages. In case you’d like to use a script-based software app that requires InnoDB particularly, in order to be activated and to perform properly, you will not come across any impediments as the database engine is available on our custom-developed cloud platform. No matter if you create a brand-new MySQL database and activate an app manually or make use of our single-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app requires it rather than MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also perform daily database backups, so that we can swiftly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

You can install a PHP script-powered software application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our innovative cloud web hosting platform where the MySQL storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click app installer tool. In either case, the needed engine will be picked automatically as soon as the activation of the app starts, so you won’t have to configure anything manually, no matter if the application requires InnoDB or the more frequently used MyISAM. In addition, we will always be able to recover any of your MySQL databases in case you remove one by mistake, as we perform a couple of MySQL database backups every day, each of which is kept for 1 week.

InnoDB in VPS Servers

In case our custom-built Hepsia Control Panel is selected during the signup process for your new VPS hosting plans , InnoDB will be installed on the server together with other needed pieces of software, so you won’t have to do anything if you decide to use script-powered applications that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new database and begin the app installation process manually or through our single-click installation tool. The system will automatically detect which engine the app in question requires and will assign it to the specific database, so the installation process will continue flawlessly and the application can enter its content into that database. Thus, you can make use of applications with various requirements concerning the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to choose one of the 3 hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to add this database engine manually in order to be able to use PHP-powered apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you need to run large-scale websites, it is quite likely that you will use InnoDB. You will be able to use other engines too, so if a given application needs MyISAM instead of InnoDB, you will not have to deal with any impediment while using it. The engine that will be used will be recognized automatically as soon as the app installation commences, so you will not have to alter any settings manually at any moment.