InnoDB
What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a very popular database storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has got numerous upsides that make it the preferred engine for a lot of open-source script-driven web apps, such as Joomla™ and Magento, which have moved to InnoDB permanently. For example, importing immense amounts of data will be faster with InnoDB, since it locks only a single row to perform a specific operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, appending new or modifying existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case any issue appears during the process, which means that the content that remains in the database will not be damaged.
-
InnoDB in Web Hosting
Any open-source script-driven web app that requires InnoDB will function impeccably on our advanced cloud web hosting platform and the MySQL database engine comes with all our
web hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s specifications without having to change 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 take advantage of its full capacity. We’ll make regular backups of your content, so in case you accidentally erase a database that you need or you overwrite a certain part of it, we will be able to restore your data the way it was only a couple of hours ago.
-
InnoDB in Semi-dedicated Hosting
All our
semi-dedicated hosting packages come with InnoDB and you can take full advantage of all the options offered by this database engine with any script-based application that needs it. InnoDB is one of the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the respective app. You will not have to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer. To be on the safe side, we will carry out regular database backups, so if something goes wrong following some update or if you remove some data by accident, we will be able to restore your database the way it was on any of the previous seven days.
-
InnoDB in VPS Web Hosting
All
Linux VPS web hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to run any PHP script-powered app that requires this MySQL storage engine without having to install anything manually. You can pick Hepsia on the VPS order page and your brand-new VPS server will be up and running within 60 minutes, so you can log in and begin setting up your web sites right away. When you create a new database and start the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can install various applications simultaneously without updating anything on the server. You can set up a WordPress-based personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-store that uses the InnoDB engine, for instance.
-
InnoDB in Dedicated Servers Hosting
Our Hepsia hosting Control Panel is one of the options that you can pick on the order page when you buy a
dedicated server from our company. As this is the most powerful kind of web hosting, it is pretty likely that you will run very popular websites that will attract many people, and since InnoDB is among the very best choices for such Internet sites, we’ll install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. If you set up a brand-new database in your dedicated server account, there won’t be any activated database engine until you start installing a PHP script, whether manually through your Internet browser or using the automatic script installer that is integrated into the hosting Control Panel. The necessary engine will be recognized automatically and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without the need to cope with any impediment.