Learn more about InnoDB and find out why it’s recently been selected as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining popularity lately, as it provides a significantly better overall performance and a faster crash recovery compared with the default engine used by the MySQL database management system – MyISAM. InnoDB is used by plenty of web developers that create highly scalable applications, due to the fact that it works much better with immense volumes of data, while it keeps the server processing load low. Moreover, it locks only one database row if anything should be updated, while many other engines lock the entire table and therefore need more time to execute several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest Joomla™ editions are two examples of widespread open-source script-based software applications which have moved to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting
by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-powered web app which requires the MySQL database storage engine without any problems as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app activation process, no matter if you take advantage of our one-click installation tool or create the MySQL database and install the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will maintain daily backups of all your MySQL databases, so you can be certain that you’ll never lose any content if you erase a database by mistake or you overwrite some crucial info – you will simply need to contact us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
You can use a script-based web application that needs InnoDB with all of our semi-dedicated server
packages, due to the fact that all the accounts are created on our leading-edge cloud platform where the database engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you take advantage of our single-click app installer. In either case, the required engine will be picked automatically as soon as the application’s installation begins, so you won’t have to configure anything manually, irrespective of whether the app requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you delete one by accident, as we generate a few database backups every day, each of which is preserved for 1 week.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting
that are ordered with our custom-built Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to add it manually in case you need to use open-source scripts that require it. All it takes to run such a script is to set up a new database and to start the setup process – once the setup wizard obtains access to the database in question and starts dumping content in 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 run scripts that need MyISAM – the other popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will allow you to activate different scripts on a single physical machine and to use the latter to its fullest capacity.