InnoDB
What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a significantly better overall performance and an improved database crash recovery compared with the default engine used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that write scalable web applications, because it works much more efficiently with enormous amounts of data, while it keeps the server processing load at a minimum. What’s more, it locks only one database row if any info should be modified, while many other engines lock the entire database table and thus require more time to execute several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for some reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest Joomla™ editions are two examples of widespread PHP-based software platforms which have moved to InnoDB.
-
InnoDB in Cloud Website Hosting
You’ll be able to use any PHP-based web application that requires InnoDB in case you have a
Linux cloud website hosting package with us, as the database storage engine is available on our advanced cloud platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is needed. You can install applications which use the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be selected automatically, so you won’t need to edit any setting manually at any point. What’s more, we’ll also perform daily backups of all the databases that you have in your shared web hosting account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.
-
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our
Linux semi-dedicated packages by default, so once you get a new semi-dedicated account, you can go ahead and activate any PHP script-based software app that needs this database engine. A couple of engines are installed on our cloud platform, so when you set up a brand new MySQL database and begin installing an app manually, or opt to use the Hepsia 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 activate and run InnoDB-specific apps without encountering any problem and without changing any settings in your account. To avoid any risk, we’ll always keep a one-week-old backup of all your databases, so if you delete or alter any content accidentally, we can easily rescue it.
-
InnoDB in Dedicated Hosting
All
Linux dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not have to activate it manually if you’d like to activate 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 – once the installer wizard gets access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to use scripts that require MyISAM – the other widely used MySQL engine, so you will not need to edit any settings on the server. This will allow you to run various scripts on a single machine and to use the latter to its maximum capacity.