Database Manager

The Database Manager inside our Web Control Panel provides a refined yet uncomplicated interface. You’re able to set up a whole new MySQL or PostgreSQL database by just specifying a user name and password. Furthermore, you can create a backup file or modify the security password of any database with only a mouse click.

Within the Database Manager you will possess direct access to the management area for each of your databases, in order to make effortless alterations in the event you need to.

We’ve designed the manual database back–up generation into a simple job. To execute this: inside the Database Manager, click the ’clock’ icon beside the database that you would like to back up and afterwards wait for a few seconds for the backup process to take place. Depending upon the size of your database, the generation of any backup file can take somewhere between a few seconds and a minute.

You can make as many backups per database as you would like. We haven’t determined any limits for the number of databases that you could back up as well.

PgSQL databases are significantly less common as opposed to the prevalent MySQL databases. Nonetheless, they are a favored choice for developers who seek the uttermost security for their web sites and apps. Because of the user–friendly Database Manager integrated into the HostBuddy Control Panel, you can manage all your PostgreSQL databases with only a mouse click.

You will find PgSQL databases included automatically with the best hosting plans packages. Provided that you are with a standard hosting package, you are able to ask for PgSQL databases to be added in your website hosting account as upgrades.

With HostBuddy, you will inevitably find the most current version of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more dependable as compared to the past storage engine’s edition – MyISAM. It is ACID–compliant and, best of all – it gives you complete transaction support. What’s more, it takes advantage of row–level locking, as an alternative for MyISAM’s table–level locking, that would always trigger performance troubles at peak usage times.

Checking the load generated by the databases for your busy website makes it possible to avoid all overload issues that might slow it down and chase away site visitors. For this specific purpose, we’ve incorporated a detailed Database Stats tool into the Web Control Panel. There you can get comprehensive information about the arriving requests to your databases for each hour, day and month.

In line with the number of day–to–day and by the hour queries, it’s possible to find out what databases are being used the most and also consider measures to enhance their load.