InnoDB is a database engine for MySQL relational databases, which is used by widely used PHP-based apps like Magento and Joomla™ v3. It’s perfect for scalable apps, since it works really well when handling huge data volumes. Rather than locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same length of time. Moreover, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – rules that define how data inserts and updates should be treated. If a specific operation has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and will not be partially mixed with newly inserted content.
InnoDB in Cloud Website Hosting
Any script-driven application that requires InnoDB will function flawlessly on our innovative cloud hosting platform and the MySQL database storage engine is offered with all our cloud website hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database will make use of will be selected on the basis of the app’s requirements without having to update any setting in your shared web hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll make regular backups of your content, so in case you unintentionally erase a database that is important to you or you overwrite certain parts of it, we will be able to restore your database the way it was just a few hours ago.
InnoDB in Semi-dedicated Servers
InnoDB comes with all our Linux semi-dedicated hosting plans by default, so as soon as you create a new account, you can move on and activate any script-powered software app that requires this particular database storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a new database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set depending on the requirements of the specific application. This will permit you to install and run InnoDB-specific apps without running into any complication and without updating any settings in your account. To take no chances, we’ll always keep a seven-day-old backup of all your databases, so if you delete or change any content by accident, we can swiftly restore it.
InnoDB in VPS Servers
In case our in-house built Hepsia hosting Control Panel is chosen during the registration process for your new VPS plans , InnoDB will be installed on the server along with other necessary software, so you will not have to do anything if you decide to run open-source script-powered apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a new MySQL database and start the app installation manually or using our single-click installer tool. The system will automatically recognize the engine that the particular application needs and will assign it to the specific database, so the installation will continue flawlessly and the application can insert its data into that database. Therefore, you can install apps with different requirements concerning the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Servers
When you buy a new dedicated server, you’ll be able to select one of the 3 Control Panels offered by us – Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to install this database storage engine manually in order to be able to manage script-powered software apps that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need to run large-scale websites, it is pretty likely that you’ll resort to InnoDB. You will be able to use other engines too, so in case a certain application requires MyISAM instead of InnoDB, you won’t have any obstacle while running it. The engine that will be used will be automatically recognized as soon as the app installation process starts, so you won’t need to change any settings manually whatsoever.