InnoDB

: Hosting Definitions; AAAA Records; Access Log Manager; Additional RAM; Administration Services; Advanced Tools; Email Aliases; Antivirus Protection; APC; Web Applications; Auto-reply Emails; Browsable Daily Backups; Catch-all Emails; CentOS; Live Chat Support; ClientExec Billing And Support Software; Genuine Cloud Architecture; CNAME Records; Hosting Control Panel; Hardware; CPanel Control Panel; CPU Share; Cron Jobs; Custom Error Pages; MX And A Records; Daily Data Back-up; Data Centers; Data Compression; Debian; Dedicated IP; Server Network Hardware; DirectAdmin Control Panel; Disk Space; Domain Backorders; DomainKeys Identified Mail; Domain Manager; Parked Domain Names; Domain Registration Transfer; Dreamweaver Compatible; Dropbox Backups; Email Forwarding; Email Manager; Enom Domain Name Reseller Account; EPP Transfer Protection; Error Log Viewer; Extensive Online Documentation; Extra Dedicated IPs; File Manager; FTP Accounts; FTP Manager; Full DNS Management; WHOIS Management; Guaranteed RAM; Hepsia Control Panel; Domain Names Hosted; Hotlinking Protection; Htaccess Generator; WHOIS Shield; Imagemagick And GD Library; InnoDB; Installation And Troubleshooting; Instant Account Activation; Integrated Ticketing System; IonCube; IP Blocking; JailHost; Email Accounts; Mailing Lists; Mailing List Members; Managed Services Package; Marketing Tools; Money Back Guarantee; Memcached; Microsoft Frontpage Extensions; ModSecurity; Monitoring And Rebooting; MySQL And Load Stats; 2.5 Gbit Network Connectivity; Data Corruption; Node.js; No Overselling; NS Records; One-Hour Response Guarantee; Perl Modules; Password Protected Directories; Perl; PostgreSQL Databases; PgSQL Database Storage; Phone Support; PHP 4 And PHP 5 Support; PhpMyAdmin; PhpPgAdmin; Python; RAID; Registrar Lock; Server Reselling Options; Serverside Includes; Shared SSL IP; SiteMap Generator; SMTP Server; Spam Filters; SPF Protection; MySQL Databases; MySQL Database Storage; SRV Records; Data Caching; SSL Certificate Generator; Stable Linux With Apache; Subdomains; Help Desk; Bandwidth; TXT Records; Ubuntu; UPS And Diesel Back-up Generator; Service Uptime; URL Redirector; Varnish; VPN Traffic; Multiple Control Panels; Set-up Fee; Multiple OS; Full Root-level Access; SSH Telnet; Web Accelerators; Online Site Builder; Web And FTP Statistics; Web Installer; Webmail; Assisted Website Migration; Website Manager; Free Site Themes; Weekly Backup; Weekly OS Update; Zend Optimizer; ZFS Mails And MySQL; Order

InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a much better overall performance and an improved database failure recovery compared to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many developers that run highly scalable software apps, because it works better with huge volumes of data, while it keeps the server load low. In addition, it uses row-level locking if any info should be updated, while lots of other engines lock the entire table and hence require much more time to carry out several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest Joomla^™ versions are two instances of widespread open-source script-based software apps that have shifted over to InnoDB.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting providers, it’s included in the standard set of services that we are offering with our web hosting plans. In case you wish to make use of an open-source script-driven application that requires InnoDB specifically, in order to be installed and to work correctly, you won’t come across any problems as the InnoDB storage engine is available on our in-house developed cloud platform. No matter if you set up a brand-new database and install an application manually or use our single-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application needs it rather than MyISAM. In addition to the outstanding database crash recovery offered by InnoDB, we also keep daily backups of all databases, so that we can easily recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so as soon as you get a new account, you can go on and install any PHP script-driven software application that requires this particular MySQL storage engine. A couple of engines are installed on our cloud web hosting platform, so when you create a new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set based on the requirements of the particular app. This will allow you to install and manage InnoDB-specific apps without having to cope with any difficulty and without having to edit any settings in your semi-dedicated account. To take no chances, we will always keep a 7-day-old backup of all your MySQL databases, so if you erase or edit any content by mistake, we can swiftly rescue it.

InnoDB in VPS Servers

When you acquire a VPS server from our company, you’ll be able to make use of our in-house built Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to install any PHP-powered software app which needs InnoDB, as this database storage engine is part of the software package that will be installed on the server during its configuration. When you create a brand-new MySQL database via the hosting Control Panel, you will just need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you won’t need to do anything else in your VPS account. Correspondingly, if an application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

When you order a new dedicated server, you’ll be able to pick one of the three hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to install this MySQL database engine manually to be able to use PHP-powered applications that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the server resources that you require in order to run large-size sites, it’s rather likely that you’ll use InnoDB. You’ll be able to use other engines too, so in case a particular app requires MyISAM instead of InnoDB, you will not need to deal with any impediment while managing it. The engine that will be used will be recognized automatically the moment the app installation process begins, so you will not have to configure any settings manually at any time.