InnoDB

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

InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and an improved database crash recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of programmers that write highly scalable software apps, due to the fact that it works better with huge volumes of data, while it keeps the server processing load low. Also, it locks only a single database row if any info should be edited, while many other engines lock the entire database table and hence need much more time to execute multiple consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest versions of Joomla^™ are two examples of popular open-source script-driven applications which have switched to InnoDB.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s part of the standard set of services that we’re offering with our website hosting plans. If you want to use a script-driven software application that requires InnoDB in particular, in order to be activated and to perform properly, you won’t encounter any obstacles because the database engine is available on our custom-built cloud website hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular app requires it instead of MyISAM. In addition to the outstanding database crash recovery offered by InnoDB, we also generate regular database backups, so we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel coming with all our semi-dedicated server packages and you start installing a PHP-powered application either manually or using our one-click app installer, the MySQL database storage engine will be picked automatically based on the prerequisites of the given application. As InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any time. To prevent any risk of losing information if you update an application or if you remove a database unintentionally, we’ll generate a backup of all your databases every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Servers

All Linux VPS plans that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to use any PHP script-powered web application that requires this MySQL storage engine without activating anything manually. You can pick Hepsia on the VPS order page and your brand-new Virtual Private Server will be ready within one hour, so you can sign in and begin building your web sites right away. When you set up a new MySQL database and start the app installation process, our system will pick the engine for that database automatically. Thus, you can use different applications simultaneously without having to update anything on the server. You can create a WordPress-powered weblog that uses MyISAM – the default MySQL engine, and a Magento-powered e-store that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to pick any of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to install this database storage engine manually to be able to manage PHP-based applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require to run large-size sites, it is pretty likely that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a particular app requires MyISAM instead of InnoDB, you will not run into any complication while using it. The engine that will be used will be recognized automatically when the app installation procedure begins, so you will not have to fine-tune any settings manually at any moment.