From the Databases Manager integrated into the Web Hosting Control Panel, you’ll be able to make new MySQL and PgSQL databases immediately! Also, you’ll get direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), so that you can comfortably edit the database you want.
A Simple point and click Interface
The easiest to use database management interface
Database management may appear like a complicated job to unskilled hosting clients, but with Pagesroot’s Databases Manager, it’s in fact relatively easy! To set up a completely new database, you simply need to enter the username and password. Database backup copies are only a mouse click away as well.Those who desire to examine their databases and also revise them can use the phpMyAdmin and phpPgAdmin tools.
Simple and quick Database Backup
Database backup copies can be a click away
With the Databases Manager it is easy to make an archived duplicate of your database anytime you want! Thus, you’ll always have a data backup of your operating content material in the event your site gets hacked or you erroneously remove a database. To create a backup: click the ’clock’ symbol on the side of any database and then wait for a few seconds for the process to be executed.
There are no restricts on the volume of databases you are able to back up or the number of back–ups you may make for a database.
Just about the most risk–free open source databases
Almost all of Pagesroot’s Linux website hosting packages bundles present PgSQL support. While dropping behind MySQL when considering acceptance and employment, PgSQL databases are renowned for providing the top level of protection for your site content. This is the main reason why businesses like Skype and Yahoo employ PgSQL databases instead of MySQL.
With regards to database management, PgSQL is as simple and easy as MySQL.
The fresh face of MySQL
With Pagesroot, you will regularly find the newest edition of MySQL and the default MySQL storage engine – InnoDB, set up.
InnoDB is definitely more secure when compared to the former storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it provides 100% transaction support. In addition, it makes use of row–level locking, as an alternative for MyISAM’s table–level locking, that used to trigger efficiency problems at high usage times.
Detailed Database Stats
Complete stats for all your databases
Checking the load produced by the databases within your powerful site makes it possible to stop all overload difficulties that can slow it down and chase away website visitors. For this purpose, we’ve bundled a in–depth Database Stats tool in the Web Hosting Control Panel. There you can see all–encompassing info about the incoming requests to your databases for every hour, day and month.
Based on the number of day–to–day and by the hour queries, you are going to be able to find out which databases are employed the most as well as consider procedures to enhance their work.