Databases Manager

Overseeing your databases now is easier than in the past, due to the Web Control Panel user interface for MySQL and PgSQL control! Even if you do not have thorough experience in utilizing databases, it will be an easy task to manage SuntechSpace’s Databases Manager.

You can create a brand new database just by keying in the user name and security password or produce a database backup with merely a click of the mouse. In addition, via the Data Manager you have direct access to the administration area for each and every database, allowing you to easily update it.

From the Databases Manager you are able to produce an archived duplicate of your database when you need! For this reason, you will always have a data backup of your dynamic content material in the event your site gets broken into or if you incorrectly remove a database. To make a back–up: click the ’clock’ icon on the side of a given database and then simply wait for a few seconds for the process to be carried out.

There aren’t any limits on the quantity of databases you would be able to back up or the number of backups you can make for a database.

PgSQL databases are significantly less famous as compared to the standard MySQL databases. Nevertheless, they are a preferred selection for programmers seeking the greatest stability for their sites and apps. Via the easy–to–use Databases Manager incorporated into the SuntechSpace Control Panel, you can control your PostgreSQL databases with a click of the mouse.

You can find PgSQL databases provided automatically with the top Linux website hosting packages. In case you are using a regular hosting package, you’ll be able to request PgSQL databases to be added in your web hosting account as upgrades.

With SuntechSpace, you will invariably discover the most current build of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more reliable as compared to the past storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it gives 100% transaction support. Furthermore, it employs row–level locking, as a substitute for MyISAM’s table–level locking, that used to trigger effectiveness issues at peak usage times.

Tracking the load produced by the databases on your busy web site will let you reduce all sorts of overload problems that might slow it down and ward off website visitors. For this reason, we have designed a complete Database Stats tool straight into the Web Control Panel. There you can see all–encompassing info on the incoming requests to your databases for each hour, day and month.

In line with the volume of day–to–day and by the hour queries, it’s possible to determine which databases are employed the most as well as take actions to optimize their work.