Learn more about InnoDB and see why it’s recently been picked out as the default MySQL database engine.
InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP script-driven web apps such as Joomla™ v3 and Magento. It is ideal for scalable applications, because it performs stunningly well when handling immense data volumes. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same length of time. Besides, InnoDB offers a much better crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be handled. If a particular operation has not been fully completed for some reason, the action will be rolled back. In this way, the information in the database will be kept safe and sound and will not be partially mixed with newly imported content.
InnoDB in Website Hosting
You’ll be able to use any script-based web app that needs InnoDB if you’ve got a Linux website hosting
with us, as the database storage engine is available on our cutting-edge cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can activate apps which need the MyISAM engine without any difficulties as well and, once again, the engine will be pre-selected, so you will not need to modify anything manually at any moment. On top of that, we will also carry out regular backups of all the databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database from the Control Panel included with all our semi-dedicated server
accounts and you begin installing a PHP-based web app either manually or using our single-click app installer tool, the database storage engine will be picked automatically based on the requirements of the app in question. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To avoid any chance of losing information if you update an app or if you erase a database unintentionally, we’ll make backups of all your MySQL databases each day, so if anything happens, we can rescue your content.
InnoDB in VPS Hosting
If you choose a virtual private server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the default software bundle that will be pre-installed on your Virtual Private Server before we give it to you. You will not need to set up anything manually and you’ll be able to install and run any PHP-powered application that needs InnoDB as soon as your Virtual Private Server is ready, which takes no more than one hour after the order procedure itself. A few engines are available, so every time you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be activated once the app activation process begins and our system will recognize the engine that is required by the app in question. In case you need to use MyISAM, for instance, you will not have to do anything different than installing the preferred application, whether manually or using our application installer tool.
InnoDB in Dedicated Web Hosting
InnoDB is included by default with all Linux dedicated web hosting
ordered with the Hepsia Control Panel. It’s part of the default software package that we install on all Hepsia-managed servers, so as soon as your machine is set up, you will be able to log in and to install any type of script-powered application that needs this particular database engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app configuration wizard starts entering content into the newly created database, the engine will be chosen automatically in accordance with the prerequisites of the application in question, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any point. Thus, you can use a wide range of applications for your sites.