Through the Databases Manager integrated into the Control Panel, it will be easier to make brand new MySQL and PgSQL databases immediately! Also, you will have immediate access to the administration area software tools (phpMyAdmin and phpPgAdmin, respectively), in order for you to be able to immediately update the database you want.
A Well designed Interface
The most effective database managing user interface
Database management may sound like a hard task to beginner website hosting clients, but with the Databases Manager, it’s in fact relatively easy! To set up a brand new database, you just ought to type in the username and password. Database back–ups are just a mouse click away also.People that desire to explore their databases and also modify them can use the phpMyAdmin and phpPgAdmin tools.
Speedy Database Backup
Back up your databases in a moment
We have developed the manual database back–up generation into a very simple job. To do this: in the Databases Manager, click on the ’clock’ symbol on the side of the database that you would like to back up and afterwards wait around for a few seconds for the backup process to take place. Depending on the size of your database, the building of the back–up file will need somewhere between a couple of seconds and a minute.
You can create as many copies per database as you want. We have not set any limitations on the number of databases that you can back up too.
Support for PgSQL
Guaranteed reliability for your personal databases
PgSQL databases are much less sought after than the standard MySQL databases. Nevertheless, they are a favored alternative for developers who are looking for the ultimate protection for their web sites and web apps. Because of the user–friendly Databases Manager included in the TrafficHostCity Control Panel, you can control your PostgreSQL databases with merely a mouse click.
You are going to find PgSQL databases provided by default with the advanced shared website hosting packages. If you are with a regular hosting package, you can easily request PgSQL databases to be added to your website hosting account as upgrades.
The new face of MySQL
We have integrated InnoDB – the new standard MySQL database engine on all of our servers. InnoDB is designed for sizeable database websites that need high levels of efficiency and scalability. Trials have revealed that web sites applying InnoDB based tables reach a 3–fold efficiency grow for massive joins, in comparison to those using MyISAM tables.
InnoDB takes advantage of row–level locking as a way to get rid of the operation issues witnessed at the high consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Complete stats for your databases
We offer you a very easy route to track the database use on your dynamic sites. Through the in–depth database statistics user interface, that is built–into the Control Panel, you can monitor the load created through your busy websites in real time. The supplied details will enable you to assess the database load changes each hour, daily or on a monthly basis.
You’ll be able to keep track of the database load for your web sites within the Database Stats portion of the Control Panel. The table on–screen reveals the database lookups accumulated within the present month. To assess data for a past month, click on the back arrows situated at the top.