Databases Manager

The Databases Manager inside the Site Control Panel contains an effective nevertheless simple to use interface. You are able to configure a brand new MySQL or PostgreSQL database simply by typing a username and password. In addition, you may create a backup file or alter the security password of a database with simply a mouse click.

With the Databases Manager you will possess direct access to the management area for each of your databases, meaning you can make quick alterations when you need to.

We have changed the manual database back–up formation into a quite easy job. To execute that: within the Databases Manager, click on the ’clock’ icon near the database that you want to back up and then wait around for a few seconds for the process to take place. Depending on the size of your database, the generation of a backup file will take between a few seconds and a minute.

You can create as many back–ups of a database as you would like. We’ve not set any restrictions on the number of databases that you could back up as well.

You can find PgSQL support in all our Linux shared website hosting bundles. PgSQL databases might not be as popular and frequently used as MySQL, however they deliver the maximum level of stability for your website content. Because of this, a number of widely known brands like Skype and Yahoo work with PgSQL databases. Taking care of PgSQL databases is as elementary as MySQL, due to the easy–to–use user interface of the Databases Manager.

PgSQL databases are provided by default with the most advanced web hosting plans. For the standard bundles, they are presented as upgrades.

With Hostrionics, you will inevitably find the most recent build of MySQL as well as the default MySQL storage engine – InnoDB, mounted.

InnoDB is more dependable compared to the earlier storage engine’s version – MyISAM. It’s ACID–compliant and, even more importantly – it offers 100% transaction support. You’ll find, it uses row–level locking, as a substitute for MyISAM’s table–level locking, that used to result in effectiveness troubles at peak usage periods.

Checking the load produced by the databases on your active website will help you prevent all sorts of overload difficulties that can slow it down and ward off site visitors. For this specific purpose, we have provided a detailed Database Stats tool in the Site Control Panel. There you can see all–encompassing info on the arriving requests to your databases for every hour, day and month.

Depending on the quantity of day–to–day and per hour queries, you’ll be able to find out which databases are used the most and then take procedures to enhance their work.