Learn more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of programmers that write highly scalable web apps, since it works more effectively with huge data volumes, while it keeps the server load low. Additionally, it locks only a single database row in case any info should be edited, while many other engines lock the entire database table and therefore require much more time to carry out several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest versions of Joomla™ are two examples of popular open-source script-based web apps which have shifted over to InnoDB.
InnoDB in Hosting
InnoDB is offered with all our hosting
by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-based software app that needs the InnoDB storage engine without encountering any impediment once you open your account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, no matter if you use our 1-click installation tool or create the database and activate the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will create daily backups of all your databases, so you can be sure that you will never lose any content in case you erase a database accidentally or you overwrite some key info – you simply have to alert us and we’ll restore your content the way it was.
InnoDB in VPS Servers
If our custom-built Hepsia Control Panel is selected during the registration process for your new VPS servers
, InnoDB will be activated on the VPS server together with other needed pieces of software, so you won’t have to do anything if you decide to activate script-powered web applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a new database and begin the app installation process manually or using our single-click installer tool. The system will recognize the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can import 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.
InnoDB in Dedicated Servers
All dedicated servers
ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you won’t have to activate it manually if you’d like to activate PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to begin the installation process – as soon as the installation wizard obtains access to the database in question and starts dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that need the other very popular MySQL engine – MyISAM, so you will not need to configure any settings on the server. This will enable you to run a variety of scripts on one single machine and to use it to its full capacity.