What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-powered web applications such as Magento and Joomla™ 3. It is ideal for scalable apps, because it works astonishingly well when processing immense data volumes. Instead of locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same period of time. Furthermore, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. If a given operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be retained intact and will not be partially mixed with newly appended content.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our cloud web hosting
by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP script-powered web application that needs the database storage engine without the need to deal with any problem as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation, regardless of whether you make use of our one-click installer or create the MySQL database and activate the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will create daily database backups, so you can be certain that you won’t ever lose any data in case you erase a database by mistake or you overwrite some important info – you will simply need to inform us and we will restore everything the way it was.
InnoDB in Semi-dedicated Servers
You can activate an open-source script-based application that needs InnoDB with all of our semi-dedicated server
plans, because all the accounts are created on our innovative cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our 1-click application installer tool. Either way, the needed engine will be picked automatically the moment the installation of the application begins, so you will not need to modify anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you erase one by mistake, as we perform a few backups every day, each of which is saved for 7 days.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options that you can pick on the server order page when you purchase a dedicated server
from our company. As this is the most powerful kind of website hosting, it is pretty likely that you’ll manage very popular sites that will draw a lot of visitors, and since InnoDB is one of the best choices for such Internet sites, we’ll install it along with all the other software apps that are available with a Hepsia-managed dedicated server. When you set up a brand new database in your dedicated account, there won’t be any active MySQL storage engine till you begin installing a PHP script, whether manually through your web browser or using the automatic script installer that is included in the Control Panel. The necessary engine will be detected and will be set for the database in question, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without the need to cope with any difficulty.