InnoDB
What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and an improved database failure recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by a lot of devs that run scalable software applications, because it works more effectively with immense volumes of data, while it keeps the server processing load at a minimum. Additionally, it uses row-level locking if any info should be updated, while lots of other engines lock the entire database table and hence need much more time to process multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for whatever reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest Joomla™ versions are two instances of famous script-based web apps which have switched to InnoDB.
-
InnoDB in Hosting
Every PHP script-powered web app that requires InnoDB will run flawlessly on our cutting-edge cloud hosting platform and the database storage engine is available with all our
hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will use will be selected based on the app’s requirements without having to configure any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll make regular content backups, so in case you accidentally delete a database that you need or you overwrite certain parts of it, we’ll be able to restore your data the way it was just a few hours ago.
-
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-driven web app that requires InnoDB with any of our
semi-dedicated server packages, as all the accounts are created on our innovative cloud web hosting platform where the MySQL storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer. Either way, the required engine will be selected automatically once the activation of the app begins, so you will not need to configure anything manually, no matter if the application requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to retrieve any of your databases if you accidentally erase one, as we create a few MySQL database backups every day, each of which is saved for 1 whole week.
-
InnoDB in VPS Web Hosting
If you order a
virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the software bundle that will be installed on your Virtual Private Server before we give it to you. You won’t have to configure anything manually and you will be able to enable and manage any PHP-powered app that requires InnoDB as soon as your Virtual Private Server is set up, which takes no more than 60 minutes after the order process itself. A couple of engines are available, so anytime you create a database through the Hepsia Control Panel, a particular engine will be picked once the app installation commences and our system will recognize which engine is required by the application in question. In case you need MyISAM, for example, you will not have to do anything different from installing the desired application, whether manually or using our application installer.
-
InnoDB in Dedicated Servers Hosting
When you obtain a new
dedicated server, you will be able to choose one of the 3 hosting Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to enable this database storage engine manually so as to be able to use open-source script-driven apps that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require in order to run large-scale websites, it’s very possible that you will use InnoDB. You’ll be able to use other engines as well, so if a certain application requires MyISAM instead of InnoDB, you won’t come across any impediment while managing it. The engine that will be used will be automatically detected once the app installation procedure starts, so you will not need to fine-tune any setting manually at any time.