Databases Manager

Administering your databases is less complicated than in the past, as a result of Website Control Panel user interface for MySQL and PgSQL management! Assuming you do not have thorough experience of utilizing databases, it will be an easy task to handle Discount Hosting Store’s Databases Manager.

You may create a brand new database by simply specifying the user name and security password or create a database backup with merely a mouse click. Also, within the Data Manager you will have direct access to the administrative area for each individual database, so you’re able to conveniently update it.

Within the Databases Manager you can create an archived duplicate of your database whenever you need! This way, you will always have a data backup of your active content in case your web site gets hacked or you incorrectly remove a database. To make a backup: click on the ’clock’ symbol alongside a certain database and afterwards simply wait for a few seconds for the process to be finished.

There are not any limitations for the amount of databases you can back up or the volume of backups you can make for any database.

A lot of our website hosting bundles offer PgSQL support. Although dropping behind MySQL in terms of reputation and usage, PgSQL databases are renowned for offering up the greatest level of protection for your site content. It is the primary reason why businesses like Skype and Yahoo go with PgSQL databases instead of MySQL.

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

The MySQL databases on Discount Hosting Store’s web servers employ the newest release of the InnoDB storage engine. InnoDB has been built to ensure the optimum functionality for websites that work with significant amounts of data. It presents CPU efficiency that could not be matched by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, meaning that you can easily update/insert/create/alter/drop many times for a single "operation" of your app. Moreover, it works by using row–level locking in lieu of MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Checking the load caused by the databases in your powerful site will let you avoid all sorts of overload difficulties that can slow it down and chase away website visitors. For this specific purpose, we’ve bundled a in depth Database Stats tool within the Website Control Panel. There you can get thorough info on the arriving requests to your databases for each hour, day and month.

Depending on the volume of daily and by the hour queries, it’s possible to determine which databases are utilized the most and also consider steps to enhance their work.