Database Manager

Taking control of your databases is simpler than before, as a result of Web Control Panel interface for MySQL and PgSQL control! Assuming you do not have thorough knowledge in making use of databases, you will find it easy to handle ushosting247’s Database Manager.

You can create a brand new database by only typing the username and password or make a database backup with only a mouse click. Likewise, via the Data Manager you will possess direct access to the management area for each database, meaning you can easily manage it.

We’ve developed the manual database back–up formation into a very simple task. To do this: inside of the Database Manager, click on the ’clock’ symbol beside the database that you would like to back up and after that wait around for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of any back–up file will require somewhere between a few seconds and a minute.

You can create as many backups per database as you want. We’ve not determined any boundaries for the quantity of databases you can back up either.

Just about all of ushosting247’s cloud website hosting service packages provide PgSQL support. Although falling behind MySQL in terms of global recognition and usage, PgSQL databases are famous for offering up the top level of protection for your site content. That’s the reason why businesses like Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.

When considering database administration, PgSQL is equally effortless to use as MySQL.

With ushosting247, you’ll invariably find the most up–to–date release of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more dependable when compared to the past storage engine’s edition – MyISAM. It is ACID–compliant and, most significantly – it provides total transaction support. Furthermore, it employs row–level locking, in contrast to MyISAM’s table–level locking, that previously used to cause effectiveness troubles at high usage occasions.

Checking the load accumulated by the databases for your active site assists you to reduce any sort of overload problems that might slow it down and chase away site visitors. For this purpose, we have built–in a descriptive Database Stats tool directly into the Web Control Panel. There you can see all–inclusive info about the incoming requests to your databases for each hour, day and month.

In line with the volume of day–to–day and per hour queries, you are able to find out what databases are employed the most and take procedures to optimize their work.