Databases Manager

The Databases Manager within our Control Panel includes a powerful but convenient to use user interface. It is easy to set up a whole new MySQL or PostgreSQL database simply by typing in a user name and password. Moreover, you may create a back–up file or modify the security password of any database with simply a click of the mouse.

Within the Databases Manager you’ll get direct access to the administrative area for every one of your databases, which means you can make simple changes in the event you have to.

Within the Databases Manager it is simple to create an archived backup of your database anytime you want! This way, you’ll always have a back–up of your dynamic content if your website gets broken into or if you incorrectly remove a database. To produce a back–up: click the ’clock’ image next to a certain database and then just wait for a couple of seconds for the process to be performed.

There aren’t any confines on the quantity of databases you can back up or the number of back–ups you may make for a database.

You are going to find PgSQL support in all our shared hosting offers. PgSQL databases aren’t as well–known and widely used as MySQL, however they give the highest possible level of stability for your website content and articles. For this reason, a lot of well–known companies such as Skype and Yahoo make use of PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, as a result of the intuitive interface of the Databases Manager.

PgSQL databases are included by default inside the most advanced web hosting plans. For the basic packages, they are featured as upgrades.

With Web Hosting Train, you’ll invariably find the most up–to–date edition of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is much more dependable when compared to the previous storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it grants complete transaction support. Furthermore, it utilizes row–level locking, in lieu of MyISAM’s table–level locking, that would always cause efficiency issues at peak usage times.

Monitoring the load accumulated by the databases for your active website makes it possible to reduce any sort of overload troubles that can slow it down and chase away website visitors. For that reason, we have built in a detailed Database Stats tool into the Control Panel. There you can get detailed info about the arriving requests to your databases for every single hour, day and month.

Depending on the quantity of day–to–day and by the hour queries, it’s possible to find out which databases are utilized the most and take procedures to enhance their work.