InnoDB is a storage engine for MySQL databases, which is used by widespread open-source script-powered software apps like Joomla 3.x and Magento. It’s perfect for scalable apps, as it excels in managing immense amounts of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. Furthermore, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data inserts and updates should be handled. If a certain operation has not been fully completed for some reason, the action will be rolled back. Thus, the database content will be retained undamaged and won’t be partially mixed with newly imported content.
InnoDB in Shared Web Hosting
Every PHP script-driven web app that needs InnoDB will function impeccably on our cutting-edge cloud hosting platform and the database storage engine is offered with all our shared web hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without the need to configure any setting in your shared account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll keep regular content backups, so in case you accidentally delete a database that’s important to you or you overwrite some part of it, we will be able to restore your database the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our Linux semi-dedicated servers by default, so once you create a new semi-dedicated account, you can move on and activate any PHP script-powered software application that requires the MySQL database engine. A number of engines are installed on our cloud web hosting platform, so when you create a new database and begin installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen based on the requirements of the specific application. This will permit you to install and run InnoDB-specific applications without having any problem and without the need to configure any settings in your account. To take no chances, we’ll always keep a 7-day-old backup of all your databases, so if you erase or edit any content unintentionally, we can easily retrieve it.
InnoDB in VPS Servers
If our custom-developed Hepsia hosting Control Panel is selected during the signup process for your new VPS hosting plans , InnoDB will be installed on the VPS server together with other required software, so you won’t have to do anything if you choose to use script-driven apps that require this MySQL database engine. The default MySQL engine, MyISAM, will be installed as well. You can create a new database and begin the app installation manually or through our 1-click installer tool. The system will recognize which engine the particular application requires and will set it for the specific MySQL database, so the installation will proceed flawlessly and the application can dump its content in that database. Thus, you can activate apps with different prerequisites in regard to the MySQL engine without making any modifications 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. Since this is the most powerful kind of web hosting, it’s rather likely that you will manage popular sites that will attract plenty of visitors, and since InnoDB is among the best choices for such websites, we’ll install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your dedicated server account, there won’t be any active storage engine until you start installing a PHP script, whether manually through your web browser or using the automatic script installation tool that is included in the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to that database, so you can make use of scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to cope with any obstacle.