InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is used by many web developers that create highly scalable web apps, since it works more efficiently with enormous data volumes, while it keeps the server load low. What’s more, it locks only one database row in case anything should be modified, while lots of other engines lock the entire table and therefore need more time to fulfill several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for some reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest versions of Joomla™ are two instances of popular PHP script-based software apps which have shifted over to InnoDB.
InnoDB in Cloud Hosting
You will be able to make use of any script-powered software app that requires InnoDB in case you’ve got a Linux cloud hosting with us, as the database storage engine is available on our innovative cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is needed. You can activate applications that use the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be selected automatically, so you will not need to configure any setting manually at any time. In addition, we’ll also carry out daily backups of all the MySQL databases that you’ve got in your shared account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
You can run a PHP script-powered software app that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our 1-click app installer tool. Either way, the needed engine will be chosen automatically as soon as the installation of the app begins, so you won’t need to update anything manually, regardless of whether the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to recover any of your databases if you delete one by accident, as we create a couple of database backups every day, each of which is kept for one week.
InnoDB in VPS Servers
If our custom-built Hepsia Control Panel is picked during the signup process for your new VPS servers , InnoDB will be activated on the Virtual Private Server together with other required pieces of software, so you will not need to do anything if you decide to run PHP script-based software apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new MySQL database and start the app installation procedure manually or through our single-click installation tool. The system will automatically detect which engine the particular app requires and will set it for the specific database, so the installation process will continue impeccably and the application can import its data into that database. Thus, you can make use of apps with different prerequisites regarding the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not need to install it manually in case you wish to activate PHP scripts that require it. All it takes to use such a script is to set up a new database and to begin the setup – as soon as the setup wizard gets access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you won’t have to modify any settings on the dedicated server. This will enable you to install a variety of scripts on one single server and to use the latter to its maximum capacity.