InnoDB is a storage engine for MySQL databases, which is used by widespread script-powered software apps like Joomla v3 and Magento. It’s excellent for scalable applications, since it works amazingly well when managing huge volumes of data. 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 handle a lot more tasks for the same length of time. In addition, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that indicate how data inserts and updates should be handled. In case a certain task has not been entirely completed for some reason, the action will be rolled back. In this way, the database content will remain safe and sound and will not be partially merged with newly entered content.
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it is part of the standard set of services offered with our shared web hosting packages. If you would like to make use of a PHP-based software app that requires InnoDB specifically, in order to be activated and to operate correctly, you won’t have any obstacles since the InnoDB database storage engine is available on our custom-developed cloud website hosting platform. No matter if you create a brand new MySQL database and install an application manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also maintain daily backups of all databases, so that we can easily recover any database in your shared hosting account.
InnoDB in Semi-dedicated Servers
You can make use of a PHP script-driven web app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud web hosting platform where the database storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our 1-click app installer tool. Either way, the needed engine will be picked automatically the moment the app’s activation starts, so you will not need to configure anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. Also, we’ll always be able to recover any of your databases in case you remove one by mistake, as we carry out several database backups every day, each of which is kept for one week.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is selected during the registration process for your new VPS servers , InnoDB will be activated on the VPS server together with other essential pieces of software, so you will not need to do anything if you decide to install script-powered software apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a brand new MySQL database and start the app installation procedure manually or through our 1-click installation tool. The system will recognize which engine the particular application requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can import its content into that database. Therefore, you can install applications with various prerequisites about the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated servers ordered with the Hepsia Control Panel. It’s an essential part of the default software package that will be pre-installed on all Hepsia-equipped servers, so as soon as your physical machine is ready, you’ll be able to sign in and to activate any kind of script-driven application that requires this particular database storage engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app configuration wizard starts importing data into the database, the engine will be set automatically depending on the prerequisites of the given application, so you can run both MyISAM and InnoDB without selecting either one explicitly at any moment. Therefore, you can make use of a wide range of applications for your websites.