Database Manager

Supervising your databases is much simpler than ever, due to the Web Hosting Control Panel user interface for MySQL and PgSQL control! Even though you may not have extensive knowledge in dealing with databases, you will find it very easy to use the Database Manager.

You may create a completely new database merely by typing the username and password or create a database backup with merely a click of the mouse. In addition, from the Data Manager you’ll get direct access to the admin area for each and every database, so you can effortlessly manage it.

With the Database Manager it is easy to make an archived duplicate of your database anytime you want! Thus, you are going to always have a data backup of your dynamic information in the event your website gets hacked or you mistakenly delete a database. To make a back–up: click the ’clock’ symbol beside a given database and afterwards wait for a couple of seconds for the backup process to be executed.

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

You will find PgSQL support in our Linux website hosting offers. PgSQL databases are not as popular and widely used as MySQL, however they supply the top level of protection for your web site content. Due to this, many popular companies like Skype and Yahoo employ PgSQL databases. Managing PgSQL databases is as elementary as MySQL, on account of the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided automatically in the most innovative web hosting bundles. For the regular plans, they’re suggested as upgrades.

With lms WEBS, you’ll inevitably discover the most recent build of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more secure when compared to the former storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it gives you complete transaction support. What’s more, it takes advantage of row–level locking, as an alternative for MyISAM’s table–level locking, that used to result in performance problems at peak usage times.

Keeping tabs on the load produced by the databases on your active site will let you reduce any overload problems that can slow it down and chase away site visitors. As a result, we have incorporated a in depth Database Stats tool inside the Web Hosting Control Panel. There you can get detailed information on the arriving requests to your databases for each hour, day and month.

Based on the quantity of day–to–day and per hour queries, it will be straightforward to find out which databases are employed the most and also take steps to optimize their load.