Databases Manager

Administering your databases now is easier than ever before, thanks to the Site Control Panel user interface for MySQL and PgSQL management! In case you do not have extensive expertise in utilizing databases, you will find it very easy to use JoyHost’s Databases Manager.

You can make a brand new database by only typing the user name and password or create a database backup with only a click of the mouse. In addition, from the Data Manager you’ll have direct access to the administrator area for each database, meaning you can efficiently manage it.

Assuming you have worked with databases, you know that making a manual database back–up is not really an elementary task. So as to change this, we’ve developed a simple and easy to use tool that will back up your entire database with one mouse click. The back–up file is going to be available for you in less than a minute, depending on the size of the selected database.

You won’t notice any limitations on exactly how many copies you could make for any specific database.

A majority of JoyHost’s Linux cloud website hosting bundles provide PgSQL support. While falling behind MySQL when considering acceptance and utilization, PgSQL databases are famous for offering up the maximum level of security for your website content and articles. That is the primary reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

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

The MySQL databases on JoyHost’s web servers make use of the most current version of the InnoDB storage engine. InnoDB has been meant to ensure the max performance for web sites that operate with massive volumes of data. It supplies CPU effectiveness that can not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning that you’ll be able to update/insert/create/alter/drop more than once for one "operation" of your application. Additionally, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Keeping tabs on the load produced by the databases within your dynamic site makes it possible to prevent all kinds of overload troubles that might slow it down and chase away visitors. For this purpose, we’ve included a thorough Database Stats tool directly into the Site Control Panel. There you can see detailed info on the arriving requests to your databases for each and every hour, day and month.

In line with the volume of daily and per hour queries, you are going to be able to find out which databases are employed the most and also take steps to optimize their work.