Databases Manager

The Databases Manager in the Web Hosting Control Panel comes with an effective nevertheless user–friendly user interface. You’ll be able to set up a brand new MySQL or PostgreSQL database by simply typing in a username and password. Moreover, you can make a backup file or alter the security password of the database with only a click of the mouse.

Within the Databases Manager you’ll get immediate access to the administrator area for all of your databases, so you’re able to make hassle–free adjustments when you have to.

Assuming you have dealt with databases, you already know that generating a manual database backup is simply not a simple job. So as to change this, we’ve created very simple tool that will back up your complete database with merely a single mouse click. The backup file is going to be ready for you in less than a minute, with regards to the size of the selected database.

There aren’t any limits on the number of backup copies you could make for a specific database.

PgSQL databases are less common as opposed to the popular MySQL databases. Having said that, they are a preferred option for designers who are looking for the uttermost safety for their websites and applications. Because of the intuitive Databases Manager built–into the Red Dot Hosting Control Panel, you can control all your PostgreSQL databases with only a mouse click.

You’re going to find PgSQL databases bundled by default in the top Linux shared website hosting packages. Provided that you are using a regular hosting package, you can easily ask for PgSQL databases to be added in your hosting account as upgrades.

With Red Dot Hosting, you’ll inevitably discover the newest build of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more secure in comparison to the previous storage engine’s version – MyISAM. It is ACID–compliant and, most of all – it gives total transaction support. It also uses row–level locking, instead of MyISAM’s table–level locking, that previously used to result in efficiency troubles at peak usage occasions.

Tracking the load caused by the databases for your dynamic website will help you prevent all overload problems that could slow it down and chase away visitors. For this reason, we have built–in a complete Database Stats tool in the Web Hosting Control Panel. There you can see all–encompassing information on the incoming requests to your databases for every hour, day and month.

In line with the volume of daily and by the hour queries, it will be easier to find out what databases are used the most and then take steps to enhance their work.