What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got a number of upsides that make it the engine of choice for lots of open-source script-driven web applications, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding enormous data volumes will be much faster with InnoDB, since it locks only one database row to accomplish an operation, not the entire database 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 treated. Simply put, importing new or editing existing data will either be fully completed, or will be aborted and the procedure will be rolled back if any issue shows up during the process, which means that the content that remains in the database will not be lost.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our Linux cloud website hosting plans
by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-driven web app which needs the storage engine without encountering any difficulty as soon as you order your account. InnoDB will be pre-selected as the default engine for a particular database during the app activation process, irrespective of whether you take advantage of our 1-click installer or create the database and activate the application manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will generate daily database backups, so you can be certain that you won’t ever lose any data if you erase a database by accident or you overwrite some important information – you just need to touch base with us and we’ll restore everything the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our Linux semi-dedicated hosting plans
by default, so as soon as you get a new account, you can move on and install any PHP-based application that requires the database storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the respective app’s prerequisites. This will permit you to install and manage InnoDB-specific applications without having any obstacle and without having to change any settings in your account. To avoid any risk, we will always keep a seven-day-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can easily restore it.
InnoDB in VPS Servers
If our in-house developed Hepsia hosting Control Panel is chosen during the registration process for a new VPS plans
, InnoDB will be installed on the Virtual Private Server along with other essential software, so you will not have to do anything if you decide to install open-source script-driven applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a new database and begin installing the application manually or through our single-click installer tool. The system will recognize which engine the app in question needs and will set it for the specific MySQL database, so the installation will proceed flawlessly and the app can dump its content in that database. Thus, you can manage applications with various prerequisites regarding the MySQL engine without the need to make any changes on your VPS server.
InnoDB in Dedicated Servers
When you get a new dedicated server
, you’ll be able to pick any of the three Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to install this MySQL database storage engine manually to be able to manage PHP-powered web applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require to run very large sites, it’s quite possible that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a given app requires MyISAM instead of InnoDB, you won’t have to deal with any predicament while running it. The engine that will be used will be detected automatically once the app installation process starts, so you won’t need to change any settings manually at any point.