InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got lots of advantages which make it the engine of choice for a lot of PHP-powered software applications, such as Joomla and Magento, which have moved to InnoDB for good. For example, adding large data volumes will be much faster with InnoDB, since it locks only one row to execute an operation, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. To put it simply, appending new or editing existent data will either be entirely completed, or will be annulled and the operation will be rolled back if some problem shows up in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-driven web application that needs the InnoDB storage engine without having to deal with any impediment as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, regardless of whether you use our one-click installer or create the MySQL database and activate the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll make daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content if you delete a database accidentally or you overwrite some essential information – you’ll just have to get in touch with us and we’ll restore everything the way it was.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you can take full advantage of all the features of this storage engine with any script-driven web app that needs it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be used depends on the particular app’s prerequisites. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will create daily database backups, so if anything goes wrong after some update or if you delete some content unintentionally, we will be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the default software bundle that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to activate anything manually and you will be able to enable and manage any PHP script-driven web app that needs InnoDB once your VPS server is set up, which takes no more than one hour after the order procedure itself. A couple of engines are offered, so every time you create a MySQL database using the Hepsia hosting Control Panel, a particular engine will be picked when the app activation process begins and our system will automatically recognize the engine that is required by the application in question. If you have to use MyISAM, for example, you will not need to do anything different from installing the preferred app, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom-developed Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you would like to use scripts that require it. All it takes to install such a script is to set up a new MySQL database and to initiate the setup process – once the script setup wizard obtains access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that need the other popular MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will allow you to use different scripts on a single physical server and to use it to its full capabilities.