InnoDB is a database storage engine for MySQL relational databases, which is used by well known open-source script-powered software apps like Joomla 3.x and Magento. It’s excellent for scalable apps, because it performs exceptionally well when handling large amounts of data. Rather than locking the whole table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Moreover, InnoDB offers a faster crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and updates should be treated. In case a certain task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and won’t be partially merged with newly inserted content.
InnoDB in Cloud Hosting
You can run any PHP script-powered web application that requires InnoDB if you’ve got a cloud hosting with our company, as the storage engine is available on our advanced cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can install apps which need the MyISAM engine without encountering any impediment as well and, once again, the engine will be selected automatically, so you won’t need to configure anything manually at any point. What’s more, we will also make daily backups of all the MySQL databases that you have in the account, so if you delete or overwrite something, we can easily restore it the way it was on any of the previous 7 days.
InnoDB in VPS Servers
All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to take advantage of any open-source script-powered software app that needs the storage engine without the need to activate anything manually. You can select Hepsia on the VPS order form and your brand-new VPS server will be set up within one hour, so you can log in and begin building your Internet sites right away. Once you set up a brand new MySQL database and start the app installation process, our system will choose the engine for this database automatically. In this way, you can install different apps at the same time without the need to edit anything on the server. You can create a WordPress online journal that makes use of the default MySQL engine – MyISAM, and a Magento-powered e-commerce website that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It is part of the default software bundle that we install on all Hepsia-managed dedicated servers, so once your physical machine is up and running, you will be able to log in and to activate any script-driven software application that requires this particular database storage engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app configuration wizard begins entering data into the newly created database, the engine will be selected automatically based on the prerequisites of the application in question, so you can run both InnoDB and MyISAM without having to select either one specifically at any time. In this way, you can use an extensive range of applications for your Internet sites.