We provide you with an easy to use Databases Manager, bundled inside our Web Control Panel, from which you could make new MySQL and PgSQL databases right away. Moreover, you’re able to manage each of their configuration settings with the convenient access provided to the phpMyAdmin and phpPgAdmin software tools.
A User friendly User interface
Deal with your databases with only a click of the mouse
Taking control of your databases is easier than ever before, thanks to the Web Control Panel interface for MySQL and PgSQL management! Assuming you do not have substantial expertise in utilizing databases, it will be easy to manage our Databases Manager.
You can create a new database by merely entering the username and password or generate a database back–up with a mouse click. Furthermore, through the Data Manager you’ll have direct access to the management area for every database, so you can effectively manage it.
Simple and quick Database Back–up
Database backup copies are just a click away
Within the Databases Manager it is easy to make an archived duplicate of your database when you need! Thus, you will always have a backup of your dynamic information if your website gets compromised or if you erroneously delete a database. To create a backup: click the ’clock’ icon next to any database and then just wait for a few seconds for the backup process to be carried out.
There are not any limitations about the volume of databases you would be able to back up or the amount of back–ups you can create for a database.
Essentially the most risk–free open source databases
Nearly all of the website hosting packages feature PgSQL support. Whilst falling behind MySQL regarding acceptance and application, PgSQL databases are renowned for supplying the greatest level of stability for your web site content material. That is the reason why brands like Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.
When it comes to database management, PgSQL is identically easy to understand as MySQL.
The brand new face of MySQL
With PCSOFTECH, you’ll consistently find the most recent build of MySQL and the default MySQL storage engine – InnoDB, mounted.
InnoDB is definitely more stable when compared to the former storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it provides full transaction support. Furthermore, it works by using row–level locking, as an alternative for MyISAM’s table–level locking, that seemed to lead to effectiveness issues at peak usage times.
Detailed Database Stats
Thorough stats for your databases
Keeping track of the load accumulated by the databases on your powerful site will help you avoid all overload difficulties that can slow it down and ward off website visitors. As a result, we’ve built in a in depth Database Stats tool inside the Web Control Panel. There you can find in–depth info about the arriving requests to your databases for every hour, day and month.
Based on the quantity of day–to–day and by the hour queries, you’ll be able to determine which databases are being used the most and then take measures to enhance their load.