InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP script-powered web apps such as Joomla v3 and Magento. It’s perfect for scalable applications, as it works astonishingly well when processing enormous data volumes. Instead of locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that specify how data imports and modifications should be handled. If a certain task hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the content in the database will be kept safe and sound and will not be partially merged with newly added content.
InnoDB in Cloud Web Hosting
You’ll be able to activate any open-source script-based web application that requires InnoDB if you have a cloud web hosting package with us, as the storage engine is available on our avant-garde cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can install apps that need the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you will not have to edit anything manually at any moment. What’s more, we’ll also generate regular backups of all the MySQL databases that you’ve got in the shared web hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
InnoDB comes with each of our semi-dedicated hosting by default, so as soon as you create a new account, you can go on and activate any open-source script-powered web app that requires this particular database engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a new database and begin installing an application manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be picked depending on the prerequisites of the respective application. This will permit you to install and run InnoDB-specific applications without the need to deal with any obstacle and without editing any settings in your semi-dedicated account. To be on the safe side, we will always have a 1-week-old backup of all your databases, so if you erase or edit any content by accident, we can quickly retrieve it.
InnoDB in VPS Hosting
If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the standard software bundle that will be pre-installed on your VPS server before we hand it over to you. You won’t have to set up anything manually and you’ll be able to install and use any PHP script-powered web app that needs InnoDB when your VPS is up and running, which takes no more than sixty minutes after the order procedure itself. A number of engines are available, so every time you set up a database through the Hepsia Control Panel, a particular engine will be activated when the app installation process commences and our system will automatically detect which engine is required by the app in question. If you need to use MyISAM, for example, you won’t have to do anything different than installing the desired application, whether manually or using our app installer.
InnoDB in Dedicated Web Hosting
All dedicated servers hosting packages that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to install it manually in case you would like to run PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to start the installation process – once the setup wizard gains access to the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you will not have to edit any settings on the dedicated server. This will allow you to use different scripts on one single physical server and to use the latter to its full potential.