Databases Manager

Managing your databases is less complicated than ever, thanks to the Control Panel interface for MySQL and PgSQL administration! Provided you do not have detailed experience of making use of databases, it will be effortless to handle the Databases Manager.

You can make a brand new database by just specifying the user name and security password or make a database back–up with merely a click of the mouse. At the same time, with the Data Manager you will possess direct access to the management area for each database, to help you to conveniently modify it.

We have changed the manual database back–up formation into a quite easy task. To execute that: inside the Databases Manager, click the ’clock’ symbol near the database that you would like to back up and afterwards wait for a few seconds for the backup process to take place. With respect to the size of your database, the building of a back–up file will take between a couple of seconds and a minute.

You can make as many backups per database as you would like. We haven’t set any boundaries about the volume of databases you can back up as well.

PgSQL databases are much less common compared to the well–known MySQL databases. Nonetheless, they represent a favorite selection for designers who are looking for the ultimate security for their sites and apps. Because of the user–friendly Databases Manager integrated into the Technocorp Control Panel, you can administer all of your PostgreSQL databases with just a click of the mouse.

You’re going to find PgSQL databases provided automatically within the top Linux web hosting packages packages. Assuming that you are using a regular hosting package, it is possible to ask for PgSQL databases to be included in your hosting account as upgrades.

With Technocorp, you will inevitably discover the most recent version of MySQL as well as the default MySQL storage engine – InnoDB, mounted.

InnoDB is far more reliable when compared to the past storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it includes full transaction support. You’ll find, it works by using row–level locking, as an alternative to MyISAM’s table–level locking, that would always lead to functionality troubles at high usage periods.

Checking the load generated by the databases on your dynamic web site makes it possible to stop all kinds of overload troubles that could slow it down and chase away website visitors. As a result, we’ve provided a thorough Database Stats tool inside the Control Panel. There you can see broad information about the arriving requests to your databases for each and every hour, day and month.

Based on the amount of day–to–day and per hour queries, it will be easy to determine which databases are being used the most and consider measures to enhance their work.