InnoDB

: Definitions; AAAA Records; Access Log Manager; Additional RAM; Administration Services; Advanced Tools; Email Aliases; Antivirus Protection; APC; Best 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; 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 Address; Server Network Hardware; DirectAdmin Control Panel; Disk Space; Domain Backorders; DomainKeys Identified Mail; Domain Manager; Parked Domains; Domain Registration Transfer; Dreamweaver Compatibility; 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; DNS Management; Full WHOIS Management; Guaranteed RAM; Hepsia Control Panel; Hosted Domain Names; Hotlink Protection; Htaccess Generator; WHOIS Protection; 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 Scripting; PostgreSQL Databases; PostgreSQL Database Storage; Phone Support; PHP 4 And PHP 5 Support; PhpMyAdmin; PhpPgAdmin; Python; RAID; Registrar Lock; Server Reselling Options; Server Side 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; Customer Support; Bandwidth; TXT Records; Ubuntu; UPS And Diesel Back-up Generator; Hosting Service Uptime; URL Redirection; Varnish; VPN Traffic; Multiple Control Panels; Setup Fees; Multiple OS; Full Root-level Access; SSH Telnet; Web Accelerators; Online Website Builder; Web And FTP Statistics; Web Installer; Webmail; Assisted Website Migration; Website Manager; Free Website Templates; Weekly Backup; Weekly OS Update; Zend Optimizer; ZFS Mails And MySQL; Order Now

InnoDB is a popular database engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got lots of upsides which have made it the engine of choice for plenty of open-source script-powered web applications, among them Joomla^™ and Magento, which have switched over to InnoDB for good. For instance, importing huge amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to perform a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is tackled. Simply put, appending new or updating existent data will either be fully completed, or will be annulled and the operation will be rolled back if some issue shows up during the process, hence the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

Any open-source script-based web application that requires InnoDB will run flawlessly on our leading-edge cloud platform and the MySQL database storage engine comes with all our cloud web hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full capacity. We will store daily backups of your content, so in case you unintentionally erase a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore your database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can activate a script-driven web application that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud platform where the MySQL database storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our 1-click application installer. Either way, the needed engine will be chosen automatically the moment the app’s installation starts, so you will not need to update anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to recover any of your databases if you accidentally delete one, as we create several database backups every day, each of which is kept for 7 days.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to select any of the three hosting Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to enable this MySQL storage engine manually to be able to manage script-powered applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need in order to run large-size Internet sites, it’s rather possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a particular app requires MyISAM rather than InnoDB, you won’t need to deal with any impediment while using it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you will not need to edit any settings manually at any point.