InnoDB

: Glossary; Disk Space; Hepsia Control Panel; Domain Names Hosted; InnoDB; Integrated Ticketing System; Email Accounts; Memcached; Node.js; Subdomains; Customer Support; Data Traffic; Varnish; VPN Traffic; Assisted Website Migration; Weekly Backup; Buy Now

InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by many developers that build scalable web applications, because it works much more effectively with huge amounts of data, while it keeps the server load low. In addition, it it locks only one row in the database in case any info should be modified, whereas many other engines lock the entire database table and hence need much more time to carry out several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest editions of Joomla^™ are two examples of famous PHP-powered apps which have shifted over to InnoDB.

InnoDB in Shared Website Hosting

You’ll be able to make use of any PHP-driven software application that needs InnoDB in case you have a shared website hosting plan with us, as the MySQL database storage engine is present on our cutting-edge cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can install apps that use the MyISAM engine without any impediments as well and, again, the engine will be pre-selected, so you won’t need to update anything manually at any point. Furthermore, we will also perform daily backups of all the databases that you have in your shared account, so in case you erase or overwrite anything, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you will be able to use all the features offered by this MySQL database engine with any PHP-powered software application that requires it. It’s among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the particular app. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To be on the safe side, we’ll carry out daily backups of all your MySQL databases, so if something goes wrong after an update or if you delete some data by mistake, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is picked during the signup process for a new VPS hosting plans , InnoDB will be activated on the server along with other needed software, so you will not need to do anything if you decide to install script-based software apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated too. You can set up a brand new MySQL database and start the app installation manually or through our one-click installation tool. The system will detect which engine the particular app needs and will set it for the specific database, so the installation will continue flawlessly and the app can insert its data into that database. Thus, you can use apps with various requirements in regard to the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s part of the standard software bundle that will be pre-installed on all Hepsia-equipped servers, so as soon as your machine is assembled, you will be able to sign in and to install a various open-source script-based software app that needs this MySQL database storage engine. When you set up a new database through the hosting Control Panel, there won’t be any active engine until you start installing an app. As soon as the app activation wizard starts dumping content in the database, the engine will be set automatically on the basis of the prerequisites of the app in question, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any moment. Thus, you can make use of a wide selection of apps for your sites.