Databases Manager

The Databases Manager within our Hosting Control Panel includes a refined but still user–friendly and uncomplicated user interface. You can set up a brand new MySQL or PostgreSQL database simply by entering a username and password. Moreover, you can create a back–up file or modify the security password of any database with just a mouse click.

Via the Databases Manager you’ve got direct access to the admin area for each of your databases, so its possible to make simple and easy alterations if you happen to have to.

Via the Databases Manager it’s easy to produce an archived backup of your database whenever you wish! Thus, you will always have a back–up of your active content in the event your site gets compromised or if you accidentally remove a database. To make a back–up: click the ’clock’ symbol on the side of any database and afterwards wait for a few seconds for the backup process to be finalized.

There are no boundaries on the quantity of databases you can back up or the quantity of backup copies you can make for a database.

A majority of our cloud packages packages present PgSQL support. While dropping behind MySQL in terms of acceptance and utilization, PgSQL databases are famous for delivering the top level of protection for your website content material. That is the basic reason why companies such as Skype and Yahoo make use of PgSQL databases and not MySQL.

In relation to database management, PgSQL is identically effortless to use as MySQL.

With merohostnepal.com, you will regularly find the latest build of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is more secure compared to the previous storage engine’s edition – MyISAM. It is ACID–compliant and, even more importantly – it has complete transaction support. What’s more, it uses row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to result in efficiency troubles at high usage periods.

Checking the load accumulated by the databases for your powerful site will help you stop any sort of overload problems that might slow it down and chase away visitors. For that reason, we’ve bundled a thorough Database Stats tool inside the Hosting Control Panel. There you can see comprehensive information on the arriving requests to your databases for every single hour, day and month.

In line with the quantity of daily and hourly queries, it will be straightforward to find out what databases are used the most and then consider measures to optimize their work.