InnoDB
What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a much better overall performance and a faster database failure recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by many programmers that run highly scalable apps, as it works much more efficiently with enormous amounts of data, while it keeps the server processing load at a minimum. What’s more, it uses row-level locking if anything should be updated, whereas lots of other engines lock the entire database table and thus need more time to perform multiple consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla™ editions are two examples of widespread open-source script-powered software platforms which have switched to InnoDB.
-
InnoDB in Cloud Hosting
Every PHP-powered app that needs InnoDB will run impeccably on our avant-garde cloud website hosting platform and the storage engine is available with all our
cloud hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to modify any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will create daily backups of your content, so in case you accidentally remove a MySQL database that’s important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was only a few hours earlier.
-
InnoDB in Semi-dedicated Servers
All our
semi-dedicated servers come with InnoDB and you’ll be able to take advantage of all the options offered by this MySQL storage engine with any open-source script-powered web app that needs it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the specific app. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To avoid any risk, we will carry out daily database backups, so if something goes wrong following some update or if you erase some data accidentally, we will be able to restore the database the way it was on any of the past 7 days.
-
InnoDB in VPS Servers
If our custom-built Hepsia Control Panel is selected during the registration process for a new
VPS servers , InnoDB will be activated on the server along with other essential pieces of software, so you will not have to do anything if you decide to manage open-source script-driven software apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a new database and start the app installation procedure manually or using our one-click installer tool. The system will recognize which engine the application in question requires and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can enter its data into that database. Therefore, you can activate applications with various prerequisites regarding the MySQL engine without the need to make any changes on your server.
-
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the features that you can pick on the server configuration page when you purchase a
dedicated server from our company. Since this is the most powerful type of web hosting, it’s very likely that you’ll manage popular websites that will draw many people, and since InnoDB is among the very best options for such sites, we will enable it together with all the other software apps that come with a Hepsia-equipped dedicated server. If you create a new database in your dedicated server account, there won’t be any active database engine until you start installing a PHP script, whether manually through your web browser or using the automatic scripts installer tool that is integrated into the hosting Control Panel. The necessary engine will be detected automatically and will be set for the database in question, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without needing to deal with any problem.