InnoDB is a popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got lots of strengths that make it the preferred engine for many script-powered software applications, among them Magento and Joomla™, which have moved to InnoDB for good. For example, adding immense data volumes will be much faster with InnoDB, due to the fact that it locks only a single row to carry out a certain operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is handled. To put it simply, appending new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back if any problem shows up in the meantime, thus the content that remains in the database won’t be lost.
InnoDB in Website Hosting
InnoDB is offered with all our Linux website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP script-based web application that needs the InnoDB storage engine without the need to deal with any obstacle once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation process, no matter if you take advantage of our single-click installation tool or create the MySQL database and activate the app manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll create daily database backups, so you can be certain that you will never lose any content if you delete a database unintentionally or you overwrite some important information – you just need to notify us and we will restore the database back to normal.
InnoDB in Semi-dedicated Hosting
You can use an open-source script-driven web app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our innovative cloud web hosting platform where the MySQL database 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 – if you make use of our 1-click app installer tool. In either case, the required engine will be picked automatically as soon as the activation of the application begins, so you won’t have to update anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. In addition, we will always be able to restore any of your databases if you unintentionally delete one, as we create several backups every day, each of which is saved for seven days.
InnoDB in VPS
All Linux VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to run any script-driven app that needs this MySQL database storage engine without the need to set up anything manually. You can select Hepsia on the VPS order page and your brand-new Virtual Private Server will be set up within sixty minutes, so you can log in and begin building your sites straight away. When you create a new MySQL database and start the app installation process, our system will pick the engine for that database automatically. Thus, you can run different apps at the same time without configuring anything on the server. You can set up a WordPress-based personal journal that uses MyISAM – the default MySQL engine, and a Magento online shop that uses the InnoDB engine, for instance.
InnoDB in Dedicated Hosting
All Linux dedicated hosting ordered with our custom-built Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not need to add it manually in case you need to run PHP scripts that need it. All it takes to use such a script is to create a new database and to initiate the installation process – once the setup wizard gains access to the database and starts importing content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to install scripts that require MyISAM – the other very popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will enable you to run different scripts on one single server and to use the latter to its maximum capacity.