Find out about InnoDB and see why it’s been chosen as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-driven software applications like Joomla™ 3.x and Magento. It’s ideal for scalable apps, as it works very well when managing immense volumes of data. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. Furthermore, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data inserts and updates should be handled. If a particular task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and won’t be partially mixed with newly added content.
InnoDB in Shared Website Hosting
You can activate any PHP-powered application that requires InnoDB in case you have a Linux shared website hosting package
with us, as the database engine is available on our cutting-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can run applications which need the MyISAM engine without any obstacles as well and, once again, the engine will be selected automatically, so you won’t have to update anything manually at any point. Furthermore, we will also perform daily backups of all the MySQL databases that you’ve got in the shared hosting account, so if you erase or overwrite something, we can quickly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
You can use a script-driven app that needs InnoDB with all of our semi-dedicated server
plans, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our 1-click app installer tool. Either way, the required engine will be picked automatically the moment the activation of the app starts, so you will not have to edit anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases if you unintentionally remove one, as we carry out several MySQL database backups every day, each of which is preserved for one week.
InnoDB in VPS
All Linux VPS packages
that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to take advantage of any script-powered software application that requires this particular database engine without installing anything manually. You can choose Hepsia on the VPS configuration page and your brand-new server will be set up within 60 minutes, so you can sign in and begin creating your sites right away. Once you set up a new MySQL database and begin the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can use various apps simultaneously without the need to modify anything on the Virtual Private Server. You can have a WordPress-based weblog that makes use of MyISAM – the default MySQL engine, and a Magento web store that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages
ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually if you need to use open-source scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup process – as soon as the setup wizard acquires access to the database in question and starts dumping data in it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You will also be able to activate scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to change any settings on the server. This will permit you to run different scripts on one single server and to use the latter to its full capabilities.