InnoDB
Learn what a database engine is, what exactly are the merits of the InnoDB engine and why it's gaining a lot of popularity.
InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and a faster crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by numerous devs that write scalable software applications, due to the fact that it works much more effectively with immense data volumes, while it keeps the server load low. Also, it locks only a single row in the database in case anything should be updated, while many other engines lock the entire table and therefore require much more time to complete several successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest releases of Joomla™ are two instances of widespread open-source script-based web apps that have moved to InnoDB.
-
InnoDB in Cloud Web Hosting
InnoDB is offered with all our
Linux cloud web hosting plans by default, not upon request or as a paid upgrade, so you can install and run any script-based app that requires the InnoDB database engine without any problems as soon as you order your shared account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, regardless of whether you use our 1-click installation tool or create the MySQL database and activate the app manually, provided that the app requires it instead of the more popular MyISAM engine. We will create daily database backups, so you can be sure that you won’t ever lose any content if you erase a database by accident or you overwrite some vital info – you’ll simply need to touch base with us and we’ll restore your content back to normal.
-
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the Control Panel coming with each of our
semi-dedicated server packages and you start installing a PHP-powered app either manually or using our one-click application installer, the storage engine for the database will be set automatically based on the requirements of the particular app. Since InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any point. To avoid any risk of losing information if you update an application or if you erase a database by accident, we’ll make backups of all your databases every day, so if something happens, we can rescue your data.
-
InnoDB in VPS Servers
In case our custom-developed Hepsia Control Panel is picked during the registration process for your new
VPS web hosting plans , InnoDB will be activated on the Virtual Private Server along with other necessary software, so you will not have to do anything if you choose to activate open-source script-driven software applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can create a new MySQL database and begin the app installation procedure manually or using our 1-click installer. The system will automatically recognize the engine that the particular app needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the app can insert its content into that database. Therefore, you can use applications with different prerequisites in regard to the MySQL engine without making any changes on your Virtual Private Server.
-
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options which you can pick on the server configuration page when you purchase a
dedicated server from our company. As this is the most powerful kind of website hosting, it’s very likely that you’ll manage highly popular sites that will attract plenty of individuals, and since InnoDB is among the best options for such websites, we’ll install it together with all the other software applications that come with a Hepsia-managed server. If you set up a brand-new MySQL database in your dedicated account, there won’t be any activated storage engine until you begin installing an open-source script, whether manually via your Internet browser or using the automatic script installer that is integrated into the hosting Control Panel. The needed engine will be automatically recognized and will be assigned to the database in question, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without needing to deal with any obstacle.