What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster crash recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by numerous programmers that run scalable software apps, due to the fact that it works much more effectively with immense amounts of data, while it keeps the server processing load low. Also, it uses row-level locking if any info should be edited, while lots of other engines lock the entire database table and hence need more time to perform multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla™ editions are two examples of popular open-source script-based web apps that have shifted over to InnoDB.
InnoDB in Hosting
Every PHP script-driven web application that needs InnoDB will run impeccably on our cutting-edge cloud website hosting platform and the MySQL database engine comes with all our hosting
plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to change any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We will carry out daily backups of your content, so in case you accidentally erase a database that you need or you overwrite specific parts of it, we’ll be able to restore your database the way it was only a few hours ago.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
support InnoDB and you can make the most of all the features offered by this database storage engine with any PHP-driven web application that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the particular application. You will not have to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click application installer. To avoid any risk, we will carry out daily MySQL database backups, so if anything goes wrong after an update or if you delete some content by mistake, we’ll be able to get your database back to the way it was on any of the previous 7 days.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is picked during the registration process for your new VPS servers
, InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you won’t have to do anything if you decide to run PHP-driven applications that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand-new database and begin installing the application manually or through our single-click installer tool. The system will detect which engine the app in question needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can enter its data into that database. Therefore, you can activate apps with various prerequisites concerning the MySQL engine without having to make any modifications on your server.
InnoDB in Dedicated Servers
All dedicated servers
that are ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not have to install it manually if you’d like to run open-source scripts that require it. All it takes to install such a script is to set up a new database and to start the setup process – as soon as the script setup wizard accesses the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that require the other very popular MySQL engine, MyISAM, so you won’t have to update any settings on the dedicated server. This will permit you to install a variety of scripts on one single machine and to use it to its full capabilities.