Databases Manager

Overseeing your databases now is easier than before, thanks to the Web Site Control Panel interface for MySQL and PgSQL management! Even if you do not have thorough experience of handling databases, it will be easy to manage the Databases Manager.

You can make a brand new database by simply keying in the username and password or produce a database back–up with a simple click of the mouse. Furthermore, through the Data Manager you will possess direct access to the administrative area for each individual database, which enables you to easily manage it.

Through the Databases Manager you’ll be able to make an archived backup of your database when you wish! Thus, you will always have a backup of your active content material in case your web site gets hacked or you incorrectly eliminate a database. To generate a backup: click the ’clock’ symbol beside any database and afterwards just wait for a couple of seconds for the process to be executed.

There are not any boundaries on the volume of databases you would be able to back up or the quantity of back–ups you can create for a database.

Just about all of the cloud web hosting packages deliver PgSQL support. Whilst dropping behind MySQL with respect to reputation and application, PgSQL databases are famous for delivering the greatest level of protection for your website content material. It is the reason why companies like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

With regards to database administration, PgSQL is equally simple and easy as MySQL.

The MySQL databases on HD Web Hosting’s servers make use of the most current release of the InnoDB storage engine. InnoDB was developed to guarantee the highest possible efficiency for sites that process significant volumes of data. It features CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning you can easily update/insert/create/alter/drop several times for a single "operation" of your web app. At the same time, it uses row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and performance.

Keeping track of the load produced by the databases for your active web site assists you to prevent any kind of overload difficulties that might slow it down and ward off site visitors. As a result, we’ve integrated a in–depth Database Stats tool straight into the Web Site Control Panel. There you will find thorough info about the arriving requests to your databases for each and every hour, day and month.

Depending on the amount of daily and hourly queries, it’s possible to find out which databases are employed the most and take actions to enhance their load.