InnoDB is a very popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got a number of strengths which make it the engine of choice for lots of script-based web applications, among them Joomla™ and Magento, which have switched to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, since it locks only a single row to execute a given task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, appending new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back if any problem appears in the meantime, thus the content that remains in the database won’t be damaged.
InnoDB in Website Hosting
Every script-powered app that needs InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the MySQL database storage engine comes with all our website hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use 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 application that requires this specific engine and you will be able to get the most out of its full capacity. We’ll maintain daily content backups, so in case you accidentally remove a database that’s important to you or you overwrite a certain part of it, we will be able to restore your database the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
You can use an open-source script-driven software application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our one-click application installer tool. Either way, the needed engine will be chosen automatically the moment the app’s activation begins, so you will not need to change anything manually, regardless of whether the app requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you accidentally delete one, as we create a couple of MySQL database backups every day, each of which is saved for one whole week.
InnoDB in Dedicated Hosting
When you buy a new dedicated server, you’ll be able to choose any of the three hosting Control Panels offered by us – cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this MySQL database engine manually in order to be able to use PHP-powered software apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you require in order to manage large-size sites, it is rather likely that you will resort to InnoDB. You will be able to make use of other engines too, so if a given app needs MyISAM rather than InnoDB, you won’t have any problem while managing it. The engine that will be used will be detected automatically the moment the app installation procedure commences, so you won’t have to configure any setting manually whatsoever.