Find out about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a very popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has a number of strong sides that make it the preferred engine for plenty of script-powered software apps, among them Joomla™ and Magento, which have moved to InnoDB permanently. For example, adding immense data volumes will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. To put it simply, appending new or editing existent data will either be entirely completed, or will be annulled and the procedure will be rolled back if any issue occurs during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
Every open-source script-powered application that needs InnoDB will function impeccably on our avant-garde cloud platform and the MySQL database storage engine is offered with all our shared hosting
packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s requirements without having to modify any setting in your shared hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will make regular backups of your content, so if you accidentally erase a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting
include InnoDB and you can take advantage of all the features offered by this MySQL database storage engine with any PHP-based app that requires it. It is among the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the particular app. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer tool. To be on the safe side, we’ll store daily backups of all your MySQL databases, so if anything goes wrong following some update or if you erase some content unintentionally, we will be able to get the database back to the way it was on any of the past 7 days.
InnoDB in VPS Hosting
If our custom-built Hepsia Control Panel is selected during the signup process for a new Linux VPS hosting packages
, InnoDB will be activated on the VPS server along with other essential pieces of software, so you won’t need to do anything if you choose to make use of PHP-powered software applications that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new database and begin the app installation manually or using our 1-click installer. The system will recognize the engine that the particular app needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can insert its content into that database. In this way, you can activate apps with various prerequisites concerning the MySQL engine without making any modifications on your Virtual Private Server.
InnoDB in Dedicated Web Hosting
InnoDB is available by default with all dedicated servers hosting packages
that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is up and running, you’ll be able to sign in and to install a various PHP-based web application that requires this particular database engine. If you set up a new database through the hosting Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app configuration wizard starts entering information into the database, the engine will be picked automatically in accordance with the requirements of the particular application, so you can run both MyISAM and InnoDB without the need to select either one of them explicitly at any time. Thus, you can make use of an extensive selection of apps for your sites.