InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got numerous advantages which have made it the preferred engine for lots of PHP-based software apps, such as Magento and Joomla™, which have switched to InnoDB permanently. For instance, adding immense data volumes will be faster with InnoDB, because it locks only one row to accomplish a certain operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. In simpler words, importing new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any problem shows up in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other website hosting service providers, it’s part of the default set of features that we offer with our shared hosting plans. In case you’d like to make use of an open-source script-based web application that needs InnoDB specifically, in order to be activated and to operate properly, you will not need to deal with any problems since the InnoDB storage engine is available on our custom-built cloud platform. Regardless of whether you set up a new database and install an app manually or make use of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the app needs InnoDB rather than MyISAM. In addition to the outstanding crash recovery offered by InnoDB, we also store regular database backups, so that we can swiftly restore any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
You can make use of a PHP-powered web app that requires InnoDB with all of our semi-dedicated server packages, because all the accounts are created on our cutting-edge cloud platform where the database engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our one-click app installer. Either way, the required engine will be selected automatically once the activation of the app starts, so you won’t have to modify anything manually, regardless of whether the application needs InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you unintentionally erase one, as we create a few backups every day, each of which is saved for seven days.
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is selected during the signup process for a new VPS plans , InnoDB will be activated on the Virtual Private Server along with other necessary pieces of software, so you won’t need to do anything if you decide to run open-source script-driven applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and begin installing the app manually or using our 1-click installation tool. The system will automatically detect the engine that the application in question needs and will assign it to the specific database, so the installation will proceed impeccably and the app can dump its content in that database. Thus, you can install apps with different requirements in regard to the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options that you can choose on the order page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s pretty likely that you will run very popular Internet sites that will attract many individuals, and since InnoDB is one of the best choices for such sites, we will install it along with all the other software apps that are available with a Hepsia-equipped dedicated server. If you create a brand new MySQL database in your account, there won’t be any active storage engine until you start installing a PHP script, whether manually via your browser or using the automatic script installer tool that is integrated into the Control Panel. The required engine will be automatically recognized and will be assigned to the database in question, so you can use scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without having any obstacle.