InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got plenty of pluses which have made it the engine of choice for numerous open-source script-based web applications, including Joomla and Magento, which have shifted over to InnoDB permanently. For instance, importing huge amounts of data will be faster with InnoDB, due to the fact that it locks only a single database row to perform a given task, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is treated. To put it simply, appending new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a given issue occurs in the meantime, therefore the content that remains in the database will not be damaged.
InnoDB in Hosting
You will be able to run any open-source script-driven web application that requires InnoDB if you have a hosting plan with us, as the storage engine is present on our cutting-edge cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is needed. You can activate apps which use the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you will not have to modify anything manually at any point. Furthermore, we will also carry out regular backups of all the MySQL databases that you have in your shared web hosting account, so if you delete or overwrite something, we can quickly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
You can make use of a PHP-powered app that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our advanced cloud hosting platform where the storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our one-click app installer. In either case, the required engine will be selected automatically as soon as the application’s installation starts, so you won’t have to edit anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to recover any of your databases in case you unintentionally remove one, as we make several backups every day, each of which is kept for seven days.
InnoDB in VPS Servers
All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-based software app that requires this particular database storage engine without installing anything manually. You can pick Hepsia on the VPS order form and your brand-new VPS server will be set up within the hour, so you can log in and begin setting up your Internet sites right away. Once you set up a new MySQL database and begin the app activation process, our system will select the engine for that database automatically. Thus, you can install different apps at the same time without editing anything on the Virtual Private Server. You can create a WordPress-driven personal blog that uses MyISAM – the default MySQL engine, and a Magento-driven shopping portal that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It is part of the standard software package that will be installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is up and running, you’ll be able to log in and to install any open-source script-powered app that requires this particular MySQL database engine. When you create a new MySQL database through the Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app installation wizard starts importing information into the database, the engine will be set automatically in accordance with the particular app’s requirements, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any moment. In this way, you can use an extensive selection of apps for your Internet sites.