Database Manager

The Database Manager in the Web Site Control Panel has an effective but intuitive interface. It is possible to configure a new MySQL or PostgreSQL database by simply specifying a username and security password. Additionally, you can make a backup file or change the password of any database with just a click of the mouse.

From the Database Manager you will possess immediate access to the administration area for all of your databases, so you can make hassle–free alterations in case you need to.

With the Database Manager it is easy to generate an archived copy of your database anytime you want! Therefore, you’ll always have a data backup of your operating content material in case your site gets broken into or you accidentally eliminate a database. To create a backup: click on the ’clock’ symbol beside any database and after that just wait for a few seconds for the backup process to be executed.

There won’t be any limitations for the quantity of databases you are able to back up or the volume of backup copies you can make for a database.

You’re going to find PgSQL support in all our Linux cloud hosting plans. PgSQL databases aren’t as sought after and widely used as MySQL, nevertheless they give the best level of stability for your website content and articles. Because of this, many well–known brands like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, as a result of the easy–to–use user interface of the Database Manager.

PgSQL databases are provided by default in the most advanced web hosting packages. For the basic plans, they’re offered as upgrades.

With Website Hosting Ninja, you will consistently discover the most recent version of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more dependable as compared to the old storage engine’s version – MyISAM. It is ACID–compliant and, most importantly – it gives complete transaction support. In addition, it makes use of row–level locking, in lieu of MyISAM’s table–level locking, that seemed to trigger efficiency problems at high usage occasions.

Keeping tabs on the load accumulated by the databases within your powerful web site makes it possible to reduce any sort of overload troubles that might slow it down and ward off website visitors. Therefore, we’ve incorporated a complete Database Stats tool within the Web Site Control Panel. There you can see extensive information on the arriving requests to your databases for every single hour, day and month.

In line with the number of day–to–day and hourly queries, it is possible to find out what databases are employed the most and also take steps to enhance their load.