Learn what a database engine is, what are the benefits of the InnoDB engine and why it's gaining a lot of popularity.
InnoDB is a database engine for MySQL relational databases, which is used by widely used script-based software apps such as Magento and Joomla™ 3.x. It is perfect for scalable applications, as it works incredibly well when processing large data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same length of time. Furthermore, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. If a given task has not been entirely completed for any reason, the action will be rolled back. Thus, the database content will be retained undamaged and will not be partially merged with new content.
InnoDB in Cloud Hosting
InnoDB is offered with all our Linux cloud packages
by default, not as a paid upgrade or upon request, so you can install and run any script-based web application that requires the database storage engine without encountering any problem once you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app activation, no matter if you take advantage of our single-click installation tool or create the database and set up the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We will make daily backups of all your databases, so you can be certain that you will never lose any data in case you delete a database accidentally or you overwrite some important info – you will simply need to inform us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our Linux semi-dedicated hosting packages
by default, so as soon as you purchase a new account, you can go ahead and install any script-driven app that requires this MySQL database storage engine. A number of engines are pre-installed on our cloud platform, so when you create a brand new database and begin installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected in accordance with the particular app’s prerequisites. This will allow you to install and run InnoDB-specific applications without running into any problem and without needing to modify any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you remove or alter any content unintentionally, we can swiftly recover it.
InnoDB in VPS
All Linux VPS packages
that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to use any script-based software application that requires the storage engine without activating anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be ready within 60 minutes, so you can log in and begin setting up your Internet sites straight away. Once you set up a new MySQL database and start the app installation process, our system will choose the engine for that database automatically. In this way, you can install various apps simultaneously without changing anything on the server. You can create a WordPress-driven blog that makes use of the default MySQL engine – MyISAM, and a Magento-driven online shopping portal that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Hosting
InnoDB comes as standard with all Linux dedicated servers hosting packages
that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software package that will be installed on all Hepsia-equipped dedicated servers, so as soon as your machine is ready, you will be able to log in and to install any type of open-source script-driven web app that requires this particular database engine. If you create a new database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app setup wizard begins entering information into the database, the engine will be chosen automatically based on the prerequisites of the particular application, so you can run both MyISAM and InnoDB without the need to select either of them specifically at any point. Thus, you can use a large variety of applications for your websites.