Databases Manager

Administering your databases is less complicated than before, as a result of Web Hosting Control Panel user interface for MySQL and PgSQL management! In case you do not have substantial knowledge of dealing with databases, it will be easy to handle TR Technology’s Databases Manager.

You can make a completely new database by only keying in the user name and password or produce a database back–up with just a click of the mouse. Furthermore, with the Data Manager you’ll possess direct access to the administration area for every database, so you can immediately update it.

From the Databases Manager you are able to generate an archived backup of your database when you wish! Therefore, you are going to always have a back–up of your operating content material if your website gets compromised or if you erroneously eliminate a database. To generate a backup: click the ’clock’ image beside a particular database and then simply wait for a few seconds for the process to be done.

There are not any restricts about the volume of databases you would be able to back up or the number of backup copies you can create for any database.

PgSQL databases are significantly less popular than the well–known MySQL databases. Then again, they’re a preferred selection for web developers seeking the uttermost stability for their web sites and applications. Via the easy–to–use Databases Manager built into the TR Technology Control Panel, you can administer all of your PostgreSQL databases with merely a mouse click.

You can find PgSQL databases integrated automatically inside the best cloud website hosting packages packages. In case you are using a regular hosting package, it is easy to ask for PgSQL databases to be included in your hosting account as upgrades.

We have integrated InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is ideal for substantial database websites that demand high effectiveness and scalability. Tests indicate that websites making use of InnoDB based tables reach a 3–fold functionality boost for significant joins, in comparison with those making use of MyISAM tables.

InnoDB employs row–level locking so as to clear away the overall performance difficulties discovered at the high usage times of the earlier version of the database engine – MyISAM, which employs table–level locking.

Checking the load accumulated by the databases on your active site assists you to reduce all sorts of overload problems that might slow it down and ward off site visitors. For this reason, we have incorporated a comprehensive Database Stats tool in the Web Hosting Control Panel. There you can find extensive information about the incoming requests to your databases for each hour, day and month.

Using the volume of day–to–day and per hour queries, you’ll be able to determine which databases are utilized the most and also consider actions to enhance their load.