InnoDB is a database engine for MySQL databases, which is used by well known open-source script-based software applications like Magento and Joomla™ v3. It’s perfect for scalable applications, because it works unbelievably well when processing large amounts of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Besides, InnoDB offers a better crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and updates should be treated. If a particular task has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will stay intact and will not be partially merged with newly added content.
InnoDB in Shared Hosting
Every PHP-based web app that needs InnoDB will run impeccably on our advanced cloud web hosting platform and the database storage engine comes with all our shared hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without having to modify any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We will maintain regular backups of your content, so if you accidentally erase a database that you need or you overwrite specific parts of it, we’ll be able to restore your database the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you begin installing a script-based web app either manually or using our 1-click app installer, the database storage engine will be selected automatically based on the requirements of the given application. Since InnoDB is available on the cloud hosting platform where your new account will be created, it will be set as the default engine for any app that requires it without any manual action required on your end at any moment. To prevent any chance of losing data if you update an application or if you erase a database by mistake, we’ll make backups of all your MySQL databases each day, so if something goes wrong, we can recover your content.
InnoDB in VPS Servers
In case our custom Hepsia hosting Control Panel is selected during the registration process for a new VPS web hosting plans , InnoDB will be installed on the server along with other needed pieces of software, so you won’t need to do anything if you choose to manage script-based software applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a brand new database and start the app installation procedure manually or through our 1-click installer. The system will automatically recognize the engine that the application in question needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can import its data into that database. In this way, you can activate apps with various requirements regarding the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans that are ordered with our in-house built Hepsia hosting Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually in case you need to use open-source scripts that need it. All it takes to run such a script is to set up a new database and to begin the installation process – as soon as the setup wizard gains access to the database in question and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You will also be able to install scripts that require the other widely used MySQL engine – MyISAM, so you will not need to configure any settings on the dedicated server. This will allow you to install various scripts on one single physical server and to use the latter to its full capacity.