InnoDB
What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL databases, which is used by well known PHP-powered software apps such as Joomla™ 3.x and Magento. It’s ideal for scalable applications, as it performs really well when processing huge data volumes. Rather than locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. Additionally, InnoDB offers a much better crash recovery and supports transactions and foreign keys – rules that define how data inserts and modifications should be treated. In case a given operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.
-
InnoDB in Website Hosting
You can use any script-based software application that needs InnoDB in case you have a
Linux website hosting package with our company, as the MySQL storage engine is present on our innovative cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can activate apps which need the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to modify any setting manually at any point. On top of that, we’ll also perform daily backups of all the MySQL databases that you’ve got in the shared web hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.
-
InnoDB in Semi-dedicated Hosting
You can run a PHP-driven web app that requires InnoDB with any of our
semi-dedicated server packages, as all the accounts are created on our leading-edge cloud web hosting platform where the MySQL database engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our single-click application installer. In either case, the needed engine will be selected automatically the moment the application’s installation starts, so you will not have to edit anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you unintentionally remove one, as we create several MySQL database backups every day, each of which is preserved for 1 whole week.
-
InnoDB in Dedicated Web Hosting
All
Linux dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-activated and among everything else, you’ll get the InnoDB database engine, so you won’t have to add it manually in case you’d like to run PHP scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup process – once the script installation wizard receives access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the script. You’ll also be able to activate scripts that require the other widely used MySQL engine, MyISAM, so you will not need to change any settings on the dedicated server. This will allow you to install various scripts on a single machine and to use the latter to its full capabilities.