Databases Manager

Supervising your databases is easier than before, as a result of Hosting Control Panel interface for MySQL and PgSQL administration! Assuming you do not have extensive experience in handling databases, it will be an easy task to handle our Databases Manager.

You may create a brand new database by merely entering the username and password or make a database backup with simply a mouse click. In addition, via the Data Manager you will have direct access to the admin area for every database, so its possible to instantly revise it.

Through the Databases Manager you’re able to produce an archived backup of your database anytime you desire! This way, you are going to always have a backup of your operating content material in the event your site gets compromised or if you mistakenly get rid of a database. To produce a backup: click the ’clock’ icon on the side of a certain database and then just wait for a couple of seconds for the backup process to be concluded.

There are not any restricts about the quantity of databases you can back up or the volume of back–ups you can create for a database.

PgSQL databases are significantly less sought after when compared to the popular MySQL databases. Having said that, they’re a favored selection for web developers who seek the finest security for their websites and web applications. Thanks to the easy–to–use Databases Manager incorporated into the WalletFriendlyHost Control Panel, you can control all of your PostgreSQL databases with merely a click of the mouse.

You’re going to find PgSQL databases incorporated automatically inside the advanced hosting packages. In case you are with a basic hosting package, you’ll be able to request PgSQL databases to be added in your account as upgrades.

With WalletFriendlyHost, you will regularly discover the most current release of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is a lot more stable than the past storage engine’s version – MyISAM. It’s ACID–compliant and, best of all – it provides complete transaction support. Furthermore, it uses row–level locking, as an alternative to MyISAM’s table–level locking, that previously used to lead to functionality troubles at peak usage periods.

Keeping track of the load accumulated by the databases on your active web site assists you to reduce all sorts of overload problems that might slow it down and ward off visitors. For this purpose, we’ve included a comprehensive Database Stats tool directly into the Hosting Control Panel. There you can find in–depth info about the arriving requests to your databases for every hour, day and month.

In line with the volume of day–to–day and by the hour queries, it will be easy to determine which databases are employed the most and also take procedures to enhance their load.