We present you with a simple to use Databases Manager, integrated inside our Web Site Control Panel, from where you can set up brand–new MySQL and PgSQL databases straight away. In addition, you’re allowed to command all their configuration settings via the convenient access presented to the phpMyAdmin and phpPgAdmin software tools.
A Convenient–to–use User interface
The simplest database management user interface
Database management might sound like a difficult task to beginner cloud hosting customers, however with the Databases Manager, it’s in fact pretty simple! To make a completely new database, you only need to type in your username and password. Database backups are a click away too.People who need to examine their databases and alter them are able to use the phpMyAdmin and phpPgAdmin tools.
Quick and easy Database Back–up
Database backup copies can be a click away
Through the Databases Manager it is simple to generate an archived duplicate of your database when you need! That way, you’ll always have a backup of your dynamic content material in the event your website gets compromised or if you erroneously remove a database. To produce a back–up: click on the ’clock’ image beside a certain database and afterwards wait for a few seconds for the backup process to be executed.
There are not any restricts about the amount of databases you would be able to back up or the volume of backups you can make for any database.
Support for PgSQL
Assured protection for your personal databases
PgSQL databases are much less common than the standard MySQL databases. Nevertheless, they are a favored option for programmers seeking the uttermost protection for their websites and web applications. Thanks to the easy–to–use Databases Manager incorporated into the Peter Publishing Control Panel, you can manage all your PostgreSQL databases with just a mouse click.
You will find PgSQL databases incorporated by default inside the advanced web hosting plans packages. Provided that you are with a basic hosting package, it is possible to ask for PgSQL databases to be included in your cloud hosting account as upgrades.
The newest face of MySQL
The MySQL databases on Peter Publishing’s web servers utilize the most recent build of the InnoDB storage engine. InnoDB was made to guarantee the maximum effectiveness for websites that work with big volumes of data. It boasts CPU efficiency that could not be equalled by any other disk–based relational database engines.
InnoDB is ACID–compliant and offers total transaction support, which means you can easily update/insert/create/alter/drop several times for one "operation" of your web application. Furthermore, it utilizes row–level locking and not MyISAM’s table–level locking, that raises multi–user concurrency and performance.
Detailed Database Stats
Thorough stats for all of your databases
Checking the load produced by the databases in your busy web site will let you avoid any kind of overload difficulties that might slow it down and ward off site visitors. As a result, we’ve included a descriptive Database Stats tool in the Web Site Control Panel. There you can find in depth information on the arriving requests to your databases for each and every hour, day and month.
Depending on the quantity of day–to–day and per hour queries, it is possible to find out what databases are utilized the most as well as take measures to optimize their load.