What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a storage engine for MySQL relational databases, which is used by popular script-powered software apps like Magento and Joomla™ 3.x. It’s ideal for scalable applications, because it excels in managing enormous amounts of data. Rather than locking the entire table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Furthermore, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – rules that specify how data imports and updates should be handled. In case a given task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the content in the database will remain intact and will not be partially merged with newly entered content.
InnoDB in Cloud Hosting
Every script-based web application that requires InnoDB will run flawlessly on our leading-edge cloud platform and the storage engine comes with all our cloud hosting
packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without having to configure any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to take advantage of its full potential. We’ll make daily content backups, so if you unintentionally erase a database that you need or you overwrite specific parts of it, we’ll be able to restore your data the way it was just several hours earlier.
InnoDB in VPS Servers
When you purchase a VPS server
from us, you will be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to activate any PHP script-powered application that requires InnoDB, as this particular database storage engine is an integral part of the default software package that will be pre-installed on your VPS server during its creation. When you create a brand-new database via the hosting Control Panel, you’ll simply need to start installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the application in question needs it, so you won’t have to do anything else in your account. In the same manner, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options which you can select on the server order page when you buy a dedicated server
from us. Since this is the most powerful kind of hosting, it is rather likely that you will manage highly popular Internet sites that will attract lots of individuals, and since InnoDB is one of the best options for such sites, we’ll install it along with all the other software applications that come with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your account, there won’t be any activated database storage engine till you start installing a script, whether manually via your Internet browser or using the automatic script installer tool that is included in the Control Panel. The necessary engine will be recognized automatically and will be assigned to the database in question, so you can activate scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without experiencing any complication.