Databases Manager

Administering your databases is much easier than ever, due to the Web Control Panel interface for MySQL and PgSQL administration! Even if you do not have considerable experience of dealing with databases, you will find it an easy task to use the Databases Manager.

You can create a brand new database by just specifying the user name and password or create a database back–up with merely a click of the mouse. Moreover, through the Data Manager you will possess direct access to the admin area for each individual database, allowing you to quite simply manage it.

Through the Databases Manager you’ll be able to create an archived duplicate of your database anytime you would like! That way, you’ll always have a back–up of your active content if your website gets compromised or you erroneously remove a database. To create a back–up: click the ’clock’ icon next to a certain database and after that simply wait for a few seconds for the backup process to be concluded.

There aren’t any limitations on the number of databases you would be able to back up or the number of backup copies you can create for a database.

Almost all of Your Home PC Tech’s cloud website hosting plans grant PgSQL support. Although falling behind MySQL with respect to reputation and usage, PgSQL databases are renowned for delivering the best level of stability for your site content material. That is the primary reason why companies like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

In relation to database administration, PgSQL is just as effortless to use as MySQL.

The MySQL databases on Your Home PC Tech’s web servers make use of the latest build of the InnoDB storage engine. InnoDB is made to guarantee the max functionality for websites that deal with huge amounts of data. It features CPU efficiency that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning you are able to update/insert/create/alter/drop many times for a single "operation" of your app. Moreover, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Checking the load produced by the databases within your active site will let you reduce all kinds of overload difficulties that might slow it down and chase away site visitors. As a result, we’ve built–in a thorough Database Stats tool into the Web Control Panel. There you will find all–encompassing information regarding the inbound requests to your databases for each and every hour, day and month.

Based on the number of daily and per hour queries, you are able to find out what databases are employed the most and consider actions to optimize their load.