Database Manager

The Database Manager inside our Web Hosting Control Panel provides an effective nevertheless uncomplicated interface. It’s possible to set up a brand new MySQL or PostgreSQL database by just entering a user name and password. What’s more, you can make a back–up file or customize the security password of your database with only a click of the mouse.

Through the Database Manager you’ll get immediate access to the management area for each of your databases, so that you can make simple adjustments in case you have to.

From the Database Manager it’s easy to produce an archived backup of your database anytime you need! For this reason, you are going to always have a backup of your dynamic content material in case your web site gets broken into or you mistakenly get rid of a database. To make a backup: click the ’clock’ image alongside a certain database and afterwards just wait for a few seconds for the process to be finalized.

There won’t be any restrictions about the number of databases you can back up or the amount of backups you can create for any database.

Just about all of Peep Host’s Linux shared packages packages present PgSQL support. Although dropping behind MySQL in terms of acceptance and utilization, PgSQL databases are renowned for delivering the greatest level of security for your web site content. This is the main reason why companies like Skype and Yahoo employ PgSQL databases rather than MySQL.

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

With Peep Host, you will invariably discover the most up–to–date release of MySQL and the default MySQL storage engine – InnoDB, mounted.

InnoDB is a lot more reliable when compared to the past storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it provides complete transaction support. What’s more, it takes advantage of row–level locking, as an alternative for MyISAM’s table–level locking, that previously used to lead to efficiency issues at peak usage times.

We supply you a simple and easy technique to keep an eye on the database utilization of your powerful sites. From your detailed database statistics interface, that’s incorporated into the Web Hosting Control Panel, it is easy to observe the load created by your active sites in real time. The supplied information will help you to evaluate the database load fluctuations per hour, on a daily basis or per month.

You’re able to track the database load for your websites through the Database Stats section of the Web Hosting Control Panel. The table onscreen reveals the database lookups accumulated within the present month. To assess info for an earlier month, all you have to do is click on the back arrows positioned at the top.