Database Manager

Supervising your databases is much easier than in the past, due to the Hosting Control Panel user interface for MySQL and PgSQL control! Even if you do not have considerable expertise in managing databases, it will be an easy task to use TrexHost’s Database Manager.

You could make a completely new database by just keying in the username and security password or produce a database backup with a simple click of the mouse. Likewise, via the Data Manager you’ll possess direct access to the administration area for every database, so that you can easily update it.

Assuming you have worked with databases, you are aware that making a manual database back–up is not really an elementary task. As a way to change this, we have made very simple tool that can back up your entire database with simply one click. The back–up file shall be available for you in under a minute, with respect to the size of the chosen database.

You won’t notice any limits on how many backups you can create for a chosen database.

PgSQL databases are less famous as compared to the common MySQL databases. Having said that, they’re a favorite option for programmers who seek the finest protection for their sites and web applications. Because of the user–friendly Database Manager included in the TrexHost Control Panel, you can administer all your PostgreSQL databases with a mouse click.

You are going to find PgSQL databases provided automatically inside of the best Linux shared hosting packages. Assuming that you are with a regular hosting package, it is possible to request PgSQL databases to be included in your website hosting account as upgrades.

We have incorporated InnoDB – the new default MySQL database engine on our web servers. InnoDB is designed for sizeable database sites that demand high levels of functionality and scalability. Experiments demonstrate that web sites making use of InnoDB based tables attain a 3–fold general performance boost for substantial joins, when compared with those applying MyISAM tables.

InnoDB makes use of row–level locking in order to be able to remove the functionality difficulties seen at the peak usage times of the prior release of the database engine – MyISAM, which uses table–level locking.

Monitoring the load made by the databases in your active website makes it possible to prevent any sort of overload issues that can slow it down and chase away visitors. For this specific purpose, we have bundled a thorough Database Stats tool into the Hosting Control Panel. There you can find all–inclusive info on the arriving requests to your databases for every single hour, day and month.

In line with the quantity of daily and per hour queries, you are able to find out what databases are being used the most as well as consider measures to enhance their work.