InnoDB is a very popular database engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got numerous strengths that have made it the preferred engine for numerous PHP-powered applications, including Magento and Joomla, which have shifted over to InnoDB for good. For instance, importing immense volumes of data will be faster with InnoDB, due to the fact that it locks only one row to execute an operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is handled. Put simply, adding new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case some problem occurs during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Hosting

Every script-powered app that needs InnoDB will function flawlessly on our leading-edge cloud website hosting platform and the database storage engine is available with all our hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected based on the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will carry out regular content backups, so if you accidentally remove a database that you need or you overwrite some part of it, we’ll be able to restore your database the way it was only a few hours ago.

InnoDB in Semi-dedicated Hosting

You can install an open-source script-driven app that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our avant-garde cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you take advantage of our one-click application installer tool. In either case, the required engine will be picked automatically once the activation of the app starts, so you will not have to update anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to restore any of your MySQL databases if you unintentionally erase one, as we carry out a few MySQL database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS

In case our custom-developed Hepsia Control Panel is selected during the signup process for a new Linux VPS packages , InnoDB will be activated on the VPS server together with other essential pieces of software, so you will not need to do anything if you choose to make use of script-driven web applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand-new database and start the app installation procedure manually or through our 1-click installer tool. The system will recognize which engine the app in question requires and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can import its content into that database. Thus, you can manage apps with various requirements about the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Hosting

When you order a new dedicated server, you’ll be able to choose one of the 3 hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to activate this MySQL database engine manually in order to be able to run script-powered web applications that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you require in order to manage large-size Internet sites, it is very possible that you’ll use InnoDB. You will be able to make use of other engines as well, so if a given application needs MyISAM rather than InnoDB, you won’t encounter any problem while using it. The engine that will be used will be automatically detected when the app installation procedure commences, so you won’t have to edit any settings manually at any time.