InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a better overall performance and a faster crash recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of devs that run highly scalable software applications, as it works much more effectively with large amounts of data, while it keeps the server processing load low. In addition, it uses row-level locking in case any information should be edited, while lots of other engines lock the entire table and thus need much more time to fulfill several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla™ editions are two examples of famous PHP-based software apps that have switched over to InnoDB.
InnoDB in Cloud Hosting
You can activate any script-driven app that requires InnoDB if you have a cloud hosting service with us, as the storage engine is present on our leading-edge cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can run applications that need the MyISAM engine without having to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t need to change any setting manually at any time. Furthermore, we will also create daily backups of all the MySQL databases that you’ve got in your shared account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our Linux semi-dedicated service by default, so the moment you create a new account, you can go on and activate any PHP-driven app that needs this database storage engine. Several engines are installed on our cloud web hosting platform, so when you set up a new database and begin installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected on the basis of the respective app’s prerequisites. This will permit you to activate and run InnoDB-specific applications without coming across any impediment and without the need to configure any settings in your semi-dedicated account. To be on the safe side, we will always keep a one-week-old backup of all your MySQL databases, so if you erase or edit any content unintentionally, we can swiftly recover it.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the software pack that will be pre-installed on your server before we give it to you. You won’t have to configure anything manually and you will be able to enable and manage any open-source script-based software app that needs InnoDB as soon as your Virtual Private Server is ready, which takes no more than one hour after the order process itself. A couple of engines are available, so every time you set up a database through the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process starts and our system will automatically recognize the engine that is required by the app in question. In case you need MyISAM, for instance, you will not need to do anything different from installing the chosen application, whether manually or using our app installer.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated service ordered with the Hepsia hosting Control Panel. It’s part of the default software package that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is assembled, you will be able to log in and to install any type of script-powered software app that needs this MySQL database storage 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. Once the app installation wizard begins entering data into the database, the engine will be set automatically based on the prerequisites of the app in question, so you can use both MyISAM and InnoDB without the need to select either of them explicitly at any point. Therefore, you can use an immense selection of applications for your Internet sites.