InnoDB

: Glossary; AAAA Records; Access Log Manager; Additional RAM; Administration Services; Advanced Tools; Email Aliases; Antivirus Protection; APC; Web Apps; Auto-responder Emails; Browsable Daily Backups; Catch-all Emails; CentOS; Live Chat Support; ClientExec Billing And Support Software; Genuine Cloud Architecture; CNAME Records; Web 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 Address; Server Network Hardware; DirectAdmin Control Panel; Disk Space; Domain Backorders; DomainKeys Identified Mail; Domain Manager; Parked Domains; 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; Full WHOIS Management; Guaranteed RAM; Hepsia Control Panel; Domains Hosted; Hotlinking Protection; Htaccess Generator; ID 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; SSI; 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; Service Uptime; URL Redirection; Varnish; VPN Traffic; Multiple Control Panels; Setup Fees; 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 database storage engine for MySQL databases, which is used by widespread open-source script-powered apps like Magento and Joomla^™ v3. It is ideal for scalable apps, as it works stunningly well when processing enormous amounts of data. Rather than locking the whole table to add new information to a database like many other engines do, InnoDB locks only one row, so it can process much more operations for the same length of time. Besides, InnoDB offers a much better database failure recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. In case a particular task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be retained intact and will not be partially merged with newly imported content.

InnoDB in Website Hosting

You can activate any script-based application that requires InnoDB if you’ve got a Linux website hosting with us, as the database storage engine is present on our leading-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is needed. You can install applications which require the MyISAM engine without encountering any impediment as well and, once again, the engine will be pre-selected, so you will not need to change anything manually at any time. Furthermore, we’ll also make regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB comes with each of our Linux semi-dedicated hosting by default, so as soon as you buy a new account, you can move on and install any PHP script-powered web app that needs this particular MySQL storage engine. Several engines are installed on our cloud website hosting platform, so when you create a new database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen based on the requirements of the specific app. This will permit you to activate and manage InnoDB-specific applications without the need to cope with any impediment and without the need to change any settings in your semi-dedicated account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can quickly retrieve it.

InnoDB in VPS

If our custom Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers , InnoDB will be activated on the VPS server together with other necessary software, so you will not have to do anything if you choose to make use of PHP script-powered software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a brand-new database and begin the app installation process manually or using our 1-click installer. The system will recognize the engine that the application in question requires and will assign it to the specific database, so the installation process will proceed flawlessly and the app can dump its content in that database. Therefore, you can use applications with different requirements regarding the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Hosting

When you get a new dedicated server, you will be able to choose one of the 3 Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually to be able to use script-driven apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you require to run large-scale sites, it is pretty possible that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a given app needs MyISAM instead of InnoDB, you will not experience any problem while using it. The engine that will be used will be automatically recognized the moment the app installation commences, so you will not have to alter any setting manually at any moment.