Database Manager

Administering your databases is less complicated than ever before, thanks to the Online Control Panel interface for MySQL and PgSQL management! In case you do not have considerable expertise in handling databases, you will find it very easy to use the Database Manager.

You may create a brand new database by merely typing the user name and security password or make a database back–up with a click of the mouse. Furthermore, through the Data Manager you will have direct access to the management area for each and every database, allowing you to quickly revise it.

We’ve made the manual database backup creation into a quite simple job. To do so: in the Database Manager, click on the ’clock’ icon next to the database that you want to back up and afterwards hang on for a few seconds for the process to take place. Depending on the size of the database, the building of a back–up file is going to take between a couple of seconds and a minute.

You may make as many backups of a database as you wish. We haven’t fixed any limitations about the quantity of databases you could back up as well.

Nearly all of our web hosting plans packages present PgSQL support. Whilst falling behind MySQL with regards to popularity and usage, PgSQL databases are famous for giving the highest level of safety for your site content. It is the reason why brands like Skype and Yahoo use PgSQL databases as an alternative to MySQL.

When considering database administration, PgSQL is as straightforward as MySQL.

With Watz My Domain, you shall consistently discover the latest version of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more reliable compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, most of all – it grants total transaction support. It also makes use of row–level locking, as an alternative for MyISAM’s table–level locking, that seemed to lead to effectiveness troubles at high usage occasions.

Keeping track of the load made by the databases within your powerful web site assists you to stop virtually any overload issues that can slow it down and ward off site visitors. For this purpose, we have bundled a comprehensive Database Stats tool into your Online Control Panel. There you will find comprehensive information regarding the incoming requests to your databases for each and every hour, day and month.

Using the number of day–to–day and hourly queries, it is possible to determine which databases are used the most and also consider steps to enhance their load.