From the Database Manager built–into the Web Control Panel, you are able to make new MySQL and PgSQL databases immediately! At the same time, you’ll get direct access to the management area software programs (phpMyAdmin and phpPgAdmin, respectively), which enables you to easily edit the database you want.
A Simple to use Interface
Control your databases with just a click of the mouse
Overseeing your databases is much easier than ever before, thanks to the Web Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have thorough knowledge of working with databases, you will find it effortless to use our Database Manager.
You can create a completely new database by only typing the username and security password or produce a database back–up with just a mouse click. Furthermore, within the Data Manager you’ll get direct access to the management area for each and every database, so you can efficiently revise it.
Simple and easy Database Back–up
Database backup copies are a mouse click away
Through the Database Manager you’re able to produce an archived backup of your database anytime you want! For this reason, you’ll always have a data backup of your operating content if your site gets hacked or you accidentally remove a database. To make a back–up: click on the ’clock’ image alongside a particular database and then just wait for a few seconds for the process to be finalized.
There won’t be any restricts about the quantity of databases you are able to back up or the amount of backup copies you can make for a database.
Support for PgSQL
Warranted security for your databases
PgSQL databases are less popular when compared to the well–known MySQL databases. On the other hand, they represent a favored option for designers who are looking for the best safety for their websites and web apps. Thanks to the user–friendly Database Manager built–into the Site Host Pros Control Panel, you can manage all of your PostgreSQL databases with a simple mouse click.
Yow will discover PgSQL databases integrated automatically inside of the advanced website hosting packages. In case you are with a basic hosting package, you can ask for PgSQL databases to be added in your web hosting account as upgrades.
The fresh face of MySQL
We have incorporated InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is great for significant database sites that require high levels of general performance and scalability. Tests have indicated that sites applying InnoDB based tables achieve a 3–fold overall performance grow for large joins, in contrast to those applying MyISAM tables.
InnoDB takes advantage of row–level locking so as to clear away the overall performance difficulties witnessed at the top consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Comprehensive stats for all of your databases
Monitoring the load caused by the databases on your powerful web site makes it possible to avoid all overload problems that might slow it down and chase away visitors. For that reason, we’ve built–in a complete Database Stats tool into the Web Control Panel. There you can get detailed info about the inbound requests to your databases for every single hour, day and month.
In line with the quantity of day–to–day and hourly queries, it will be straightforward to find out what databases are being used the most and take measures to optimize their work.