Find out about InnoDB and see why it’s recently been chosen as the default MySQL database engine.
InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got many pluses that make it the engine of choice for numerous PHP-powered software apps, including Magento and Joomla™, which have moved to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, as it locks only one database row to carry out 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 manner in which the info is tackled. Simply put, importing new or modifying existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a certain problem shows up in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Cloud Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it is part of the default set of services that we’re offering with our cloud website hosting
packages. If you want to use a PHP-driven application that needs InnoDB particularly, in order to be installed and to operate properly, you will not face any impediments since the MySQL database engine is available on our in-house built cloud website hosting platform. Regardless of whether you create a brand new MySQL database and activate an app manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the given app needs InnoDB instead of MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also make regular database backups, so we can quickly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated plans
support InnoDB and you can use all the features of this database engine with any PHP script-powered application that needs it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the requirements of the given application. You will not need to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our one-click app installer tool. To avoid any risk, we will maintain daily MySQL database backups, so if anything goes wrong following some update or if you erase some data accidentally, we’ll be able to get the database back to the way it was on any of the previous seven days.
InnoDB in Dedicated Servers
If you acquire a new dedicated server
, you will be able to choose any of the 3 Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to add this MySQL database storage engine manually to be able to manage PHP script-powered software apps that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need in order to manage very large Internet sites, it’s very likely that you will resort to InnoDB. You’ll be able to use other engines as well, so if a particular app needs MyISAM rather than InnoDB, you won’t need to deal with any difficulty while using it. The engine that will be used will be automatically recognized once the app installation process starts, so you will not have to tweak any setting manually at any point.