InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-powered software applications such as Magento and Joomla 3. It is ideal for scalable applications, as it performs incredibly well when managing enormous volumes of data. Rather than locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same period of time. Also, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. In case a specific task hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will remain undamaged and won’t be partially mixed with newly appended content.
InnoDB in Shared Hosting
InnoDB is offered with all our shared hosting by default, not as a paid upgrade or upon request, so you can install and run any PHP-based web app that requires the MySQL storage engine without having to deal with any impediment as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, regardless of whether you take advantage of our one-click installation tool or create the MySQL database and install the app manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll make daily backups of all your databases, so you can rest assured that you will never lose any content in case you delete a database unintentionally or you overwrite some vital info – you’ll simply have to inform us and we will restore your data the way it was.
InnoDB in Semi-dedicated Hosting
You can install a script-powered web application that requires InnoDB with all of our semi-dedicated server plans, as all the accounts are set up on our cutting-edge cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click application installer. In either case, the needed engine will be picked automatically the moment the activation of the application starts, so you won’t have to change anything manually, no matter if the application requires InnoDB or the more commonly used MyISAM. Also, we will always be able to retrieve any of your databases in case you unintentionally erase one, as we perform a couple of MySQL database backups every day, each of which is stored for one whole week.
InnoDB in VPS
If you get a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the standard software pack that will be installed on your VPS server before we give it to you. You will not need to set up anything manually and you’ll be able to enable and use any PHP-powered app that requires InnoDB when your VPS server is ready, which takes no more than 1 hour after the order procedure itself. A few engines are offered, so whenever you create a MySQL database using the Hepsia Control Panel, a particular engine will be picked when the app activation commences and our system will automatically recognize the engine that is required by the app in question. If you need MyISAM, for instance, you won’t have to do anything different than installing the app of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Hosting
Our Hepsia hosting Control Panel is one of the features which you can choose on the order form when you purchase a dedicated server from us. As this is the most powerful kind of hosting, it’s quite likely that you’ll run highly popular sites that will attract lots of visitors, and since InnoDB is among the very best choices for such sites, we will install it together with all the other software applications that come with a Hepsia-equipped server. When you create a brand-new MySQL database in your dedicated account, there won’t be any activated MySQL storage engine until you start installing an open-source script, whether manually through your browser or using the automatic script installation tool that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to the database in question, so you can install scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without needing to cope with any problem.