Find out about InnoDB and find out why it’s already been chosen as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster crash recovery in comparison with the default engine used by MySQL – MyISAM. InnoDB is preferred by numerous developers that build scalable apps, because it works better with immense amounts of data, while it keeps the server processing load low. In addition, it it locks only one row in the database if anything should be modified, whereas lots of other engines lock the entire table and hence need much more time to execute multiple consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla™ versions are two examples of widespread open-source script-based software apps that have switched over to InnoDB.
InnoDB in Cloud Hosting
You will be able to use any PHP-driven web application that requires InnoDB if you’ve got a Linux cloud package
with us, as the MySQL database storage engine is available on our leading-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can run applications that require the MyISAM engine without any problems as well and, once again, the engine will be selected automatically, so you won’t need to change anything manually at any point. Furthermore, we’ll also create regular backups of all the MySQL databases that you’ve got in your account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the Control Panel coming with each of our semi-dedicated server
accounts and you start installing a PHP script-driven app either manually or using our 1-click application installer tool, the MySQL database storage engine will be set automatically on the basis of the requirements of the particular application. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual intervention required on your end at any point. To avoid any risk of losing data if you update an app or if you erase a database unintentionally, we’ll make a backup of all your MySQL databases every day, so if something happens, we can recover your content.
InnoDB in VPS
All Linux VPS packages
that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any script-based software app that needs this database engine without activating anything manually. You can pick Hepsia on the VPS order page and your new server will be up and running within sixty minutes, so you can sign in and begin setting up your Internet sites right away. When you create a brand-new database and begin the app activation process, our system will pick the engine for that database automatically. Thus, you can run various apps at the same time without the need to edit anything on the VPS server. You can set up a WordPress-based online blog that uses MyISAM – the default MySQL engine, and a Magento shopping portal that uses InnoDB, for example.
InnoDB in Dedicated Hosting
InnoDB is available as standard with all Linux dedicated servers hosting packages
ordered with the Hepsia hosting Control Panel. It’s an integral part of the default software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to install a various open-source script-driven web app that requires this database engine. When you set up a new database through the Control Panel, there won’t be any activated engine till you begin installing an app. Once the app installation wizard begins dumping data in the database, the engine will be picked automatically on the basis of the particular app’s prerequisites, so you can run both MyISAM and InnoDB without the need to select either one of them explicitly at any time. Therefore, you can use an immense range of apps for your sites.