InnoDB is a database engine for MySQL relational databases, which is used by widely used open-source script-driven applications like Magento and Joomla v3. It is perfect for scalable apps, since it performs amazingly well when handling huge volumes of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. Besides, InnoDB offers a better crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be handled. If a given operation hasn’t been fully completed for some reason, the action will be rolled back. In this way, the information in the database will be retained intact and will not be partially mixed with newly added content.
InnoDB in Shared Web Hosting
Every PHP script-based software app that requires InnoDB will run flawlessly on our avant-garde cloud hosting platform and the database storage engine is offered with all our shared web hosting plans. Whenever you create a 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 prerequisites without having to modify any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to get the most out of its full capacity. We’ll keep daily backups of your content, so in case you unintentionally delete a database that is important to you or you overwrite some part of it, we’ll be able to restore the database the way it was only several hours earlier.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting services include InnoDB and you will be able to make the most of all the options offered by this storage engine with any open-source script-powered software application that requires it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the prerequisites of the respective app. You won’t need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer. To avoid any risk, we will carry out regular backups of all your MySQL databases, so if anything goes wrong after some update or if you erase some data accidentally, we will be able to get your database back to the way it was on any of the past seven days.
InnoDB in VPS Hosting
In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for your new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other essential software, so you won’t need to do anything if you decide to run PHP-powered web apps that need this MySQL database 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 through our 1-click installer. The system will automatically recognize the engine that the app in question needs and will set it for the specific database, so the installation process will continue flawlessly and the app can enter its data into that database. Therefore, you can manage applications with various requirements with regard to the MySQL engine without making any modifications on your VPS.
InnoDB in Dedicated Web Hosting
All Linux dedicated web hosting ordered with our in-house developed Hepsia Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually in case you wish to run scripts that need it. All it takes to use such a script is to set up a new database and to begin the installation process – once the script installation wizard acquires access to the database and starts dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to use scripts that require MyISAM, the other popular MySQL engine, so you won’t need to configure any settings on the dedicated server. This will permit you to install a variety of scripts on a single machine and to use the latter to its full capacity.