InnoDB
What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster database failure recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of devs that write highly scalable applications, because it works much more effectively with large amounts of data, while it keeps the server load low. What’s more, it locks only one database row if any info should be edited, whereas lots of other engines lock the entire table and therefore need more time to complete several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla™ are two examples of famous open-source script-based web applications that have shifted over to InnoDB.
-
InnoDB in Hosting
You can use any PHP script-powered application that requires InnoDB in case you’ve got a
Linux hosting with us, as the MySQL storage engine is available on our leading-edge cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate applications that need the MyISAM engine without the need to deal with any complication as well and, once again, the engine will be selected automatically, so you will not have to edit anything manually at any moment. Furthermore, we’ll also perform regular backups of all the databases that you’ve got in the shared hosting account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the past seven days.
-
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our
Linux semi-dedicated hosting packages by default, so once you create a new account, you can go on and install any open-source script-driven web app that requires this particular storage engine. A number of engines are pre-installed on our cloud platform, so when you set up a brand-new database and begin installing an application manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected based on the requirements of the app in question. This will permit you to activate and manage InnoDB-specific apps without having to cope with any complication and without the need to change any settings in your semi-dedicated account. To take no chances, we’ll always have a 7-day-old backup of all your databases, so if you delete or change any content by accident, we can quickly rescue it.
-
InnoDB in VPS Hosting
All
VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to run any PHP-based software app that needs this database storage engine without installing anything manually. You can select Hepsia on the VPS configuration page and your brand new VPS server will be up and running within one hour, so you can sign in and start creating your Internet sites right away. When you set up a new database and begin the app installation process, our system will select the engine for this MySQL database automatically. Thus, you can activate various apps at the same time without having to change anything on the Virtual Private Server. You can set up a WordPress-based blog that uses MyISAM – the default MySQL engine, and a Magento-based web shop that makes use of the InnoDB engine, for instance.
-
InnoDB in Dedicated Web Hosting
All
dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually in case you would like to activate scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the setup – once the installation wizard accesses the database and starts importing content 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’ll also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you won’t need to edit any settings on the dedicated server. This will enable you to activate different scripts on one single physical server and to use it to its full potential.