What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved database crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is endorsed by many programmers that run scalable software apps, because it works more effectively with huge amounts of data, while it keeps the server load low. Furthermore, it uses row-level locking in case any information should be updated, whereas lots of other engines lock the entire table and hence require much more time to accomplish multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest editions of Joomla™ are two examples of popular script-based software platforms that have shifted over to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting
by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any script-driven web application which requires the storage engine without having to deal with any problem as soon as you open your shared hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation process, regardless of whether you use our single-click installation tool or create the database and activate the application manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll make regular backups of all your MySQL databases, so you can be certain that you’ll never lose any content if you delete a database by mistake or you overwrite some key information – you just have to inform us and we will restore your data back to normal.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the hosting Control Panel included with all our semi-dedicated server
packages and you start installing a PHP-driven software application either manually or using our single-click application installer tool, the MySQL database storage engine will be picked automatically on the basis of the requirements of the specific app. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any time. To avoid any risk of losing info if you update an application or if you erase a database accidentally, we will carry out backups of all your databases each day, so if anything happens, we can recover your content.
InnoDB in VPS Web Hosting
All VPS web hosting
that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to take advantage of any PHP script-driven web application that requires this particular MySQL database engine without the need to set up anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be up and running within the hour, so you can sign in and start creating your Internet sites straight away. Once you set up a new database and begin the app activation process, our system will set the engine for that MySQL database automatically. In this way, you can make use of various applications simultaneously without the need to change anything on the server. You can create a WordPress-powered personal blog that makes use of the default MySQL engine – MyISAM, and a Magento web store that uses InnoDB, for example.
InnoDB in Dedicated Servers Hosting
InnoDB comes by default with all Linux dedicated servers hosting packages
ordered with the Hepsia Control Panel. It’s included in the software package that will be installed on all Hepsia-equipped servers, so once your machine is ready, you’ll be able to sign in and to install any PHP-powered web application that requires this storage engine. When you create a new database via the Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app installation wizard begins inserting content into the database, the engine will be set automatically depending on the requirements of the specific application, so you can run both InnoDB and MyISAM without selecting either one of them explicitly at any point. In this way, you can use a broad variety of applications for your sites.