InnoDB
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 provides a better overall performance and an improved database failure recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by many devs that create scalable web applications, because it works more effectively with huge amounts of data, while it keeps the server load at a minimum. Furthermore, it uses row-level locking in case any information should be edited, while many other engines lock the entire database table and thus need more time to execute multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed for any reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest Joomla™ versions are two instances of widely used script-powered software apps which have switched to InnoDB.
-
InnoDB in Shared Website Hosting
Every PHP-powered web app that needs InnoDB will function impeccably on our cutting-edge cloud hosting platform and the database storage engine is available with all our
shared website hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected based on the app’s requirements without the need to configure any setting in your account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We’ll keep daily backups of your content, so in case you accidentally delete a database that is important to you or you overwrite a certain part of it, we will be able to restore the database the way it was only a couple of hours earlier.
-
InnoDB in Semi-dedicated Servers
You can run a PHP script-powered software app that requires InnoDB with any of our
semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our 1-click app installer. Either way, the required engine will be chosen automatically once the application’s installation starts, so you won’t need to modify anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. In addition, we’ll always be able to restore any of your MySQL databases in case you accidentally erase one, as we make a few backups every day, each of which is stored for 7 days.
-
InnoDB in VPS Servers
All
VPS hosting plans that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-based web app that needs this database engine without needing to activate anything manually. You can pick Hepsia on the VPS configuration page and your brand-new VPS server will be set up within 1 hour, so you can sign in and start building your sites straight away. When you create a brand-new MySQL database and start the app activation process, our system will choose the engine for that MySQL database automatically. Thus, you can make use of various applications simultaneously without the need to update anything on the server. You can have a WordPress-based personal blog that uses MyISAM – the default MySQL engine, and a Magento shopping portal that makes use of the InnoDB engine, for example.
-
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the features which you can choose on the server configuration page when you buy a
dedicated server from our company. Since this is the most powerful type of web hosting, it is very likely that you’ll manage very popular websites that will attract plenty of individuals, and since InnoDB is one of the best choices for such sites, we will activate it along with all the other software applications that are offered with a Hepsia-equipped dedicated server. If you create a brand-new database in your account, there won’t be any active MySQL database storage engine till you begin installing an open-source PHP script, whether manually through your web browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be set for that database, so you can run scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without the need to deal with any impediment.