Learn more about InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of developers that create highly scalable software apps, due to the fact that it works more efficiently with enormous volumes of data, while it keeps the server processing load low. Moreover, it uses row-level locking if any info should be edited, while lots of other engines lock the entire table and thus require more time to handle multiple consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for some reason, the action is rolled back to avoid confusion or losing data. Magento and the newest Joomla™ editions are two instances of popular PHP-driven software platforms which have moved to InnoDB.
InnoDB in Shared Hosting
You will be able to install any open-source script-driven software app that needs InnoDB if you’ve got a shared hosting service
with our company, as the MySQL database storage engine is available on our innovative cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is needed. You can install apps which use the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be selected automatically, so you won’t need to edit any setting manually at any point. On top of that, we’ll also make regular backups of all the databases that you’ve got in the shared hosting account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
You can activate a script-based app that needs InnoDB with all of our semi-dedicated server
packages, as all the accounts are created on our leading-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our 1-click application installer tool. In either case, the needed engine will be selected automatically once the app’s installation starts, so you won’t have to edit anything manually, regardless of whether the app requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your databases if you delete one by mistake, as we carry out several database backups every day, each of which is kept for 7 days.
InnoDB in VPS Servers
If you obtain a VPS server
from our company, you’ll be able to make use of our custom Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to manage any script-powered app which needs InnoDB, as this MySQL database engine is an integral part of the standard software package that will be pre-installed on the Virtual Private Server during its configuration. When you set up a brand new MySQL database via the Control Panel, you will simply have to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question requires it, so you will not need to do anything else in your account. Identically, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
InnoDB is available as standard with all Linux dedicated servers
ordered with the Hepsia hosting Control Panel. It’s included in the default software bundle that will be pre-installed on all Hepsia-equipped servers, so once your machine is assembled, you’ll be able to sign in and to activate any kind of PHP-powered app that requires this particular MySQL storage engine. When you set up a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app activation wizard starts dumping information in the newly created database, the engine will be set automatically on the basis of the particular app’s requirements, so you can use both MyISAM and InnoDB without selecting either one specifically at any time. Thus, you can make use of a broad variety of apps for your Internet sites.