InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-powered software applications such as Magento and Joomla 3.x. It is excellent for scalable apps, since it excels in handling enormous volumes of data. Instead of locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. In addition, InnoDB offers a much better crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a particular task has not been fully completed for some reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and won’t be partially mixed with new content.
InnoDB in Hosting
InnoDB is offered with all our hosting services by default, not as a paid upgrade or upon request, so you can activate and manage any script-powered app which requires the InnoDB database engine without encountering any difficulty once you open your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, no matter if you take advantage of our 1-click installer or create the MySQL database and activate the app manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We will keep regular backups of all your databases, so you can rest assured that you won’t ever lose any data in case you delete a database by accident or you overwrite some essential information – you simply need to notify us and we will restore your database the way it was.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our Linux semi-dedicated hosting by default, so once you buy a new semi-dedicated account, you can move on and install any script-powered software application that needs the database storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you set up a brand new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set depending on the respective app’s requirements. This will allow you to activate and run InnoDB-specific applications without having to deal with any problem and without needing to modify any settings in your semi-dedicated account. To be on the safe side, we will always keep a seven-day-old backup of all your databases, so if you erase or alter any content by mistake, we can easily rescue it.
InnoDB in VPS Hosting
All Linux VPS hosting 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 software app that needs this database storage engine without activating anything manually. You can pick Hepsia on the VPS order page and your brand-new server will be set up within one hour, so you can log in and begin creating your Internet sites straight away. When you set up a brand new MySQL database and begin the app installation process, our system will pick the engine for that MySQL database automatically. In this way, you can use different applications simultaneously without having to edit anything on the VPS server. You can set up a WordPress personal weblog that uses the default MySQL engine – MyISAM, and a Magento e-commerce website that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Web Hosting
All dedicated web hosting ordered with our in-house developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually in case you’d like to use open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to begin the setup process – as soon as the installer wizard obtains access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to activate scripts that need the other very popular MySQL engine – MyISAM, so you won’t need to modify any settings on the dedicated server. This will permit you to run different scripts on one single machine and to use the latter to its full potential.