Database Manager

Supervising your databases is easier than ever, thanks to the Web Site Control Panel user interface for MySQL and PgSQL administration! Provided you do not have thorough knowledge of dealing with databases, you will find it simple to use the Database Manager.

You can make a whole new database just by entering the user name and security password or produce a database backup with simply a click of the mouse. Likewise, with the Data Manager you’ll get direct access to the administrative area for every single database, which means you can quite easily modify it.

With the Database Manager it is simple to make an archived backup of your database whenever you want! That way, you are going to always have a data backup of your operating content material in case your web site gets hacked or if you mistakenly erase a database. To create a backup: click on the ’clock’ icon beside a given database and then just wait for a few seconds for the process to be finished.

There are not any restricts about the quantity of databases you would be able to back up or the amount of backup copies you can create for a database.

You’re going to find PgSQL support in each of our Linux cloud web hosting services plans. PgSQL databases aren’t as famous and widely used as MySQL, nevertheless they provide you with the best level of security for your website content and articles. For this reason, a number of popular companies like Skype and Yahoo work with PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, due to the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided by default in the most sophisticated web hosting packages. For the regular packages, they’re included as upgrades.

With Web Host Systems, you’ll consistently discover the newest version of MySQL and also the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more reliable in comparison to the past storage engine’s version – MyISAM. It is ACID–compliant and, most of all – it gives you 100% transaction support. Furthermore, it uses row–level locking, rather than MyISAM’s table–level locking, that seemed to cause functionality problems at peak usage times.

Web Host Systems offers you a simple approach to keep tabs on the database use for your dynamic web sites. From the in–depth database statistics interface, that’s built into the Web Site Control Panel, you’ll be able to keep track of the load created from your active websites in real time. The presented information will enable you to analyze the database load changes on an hourly basis, on a daily basis or on a monthly basis.

You are able to record the database load for all your websites through the Database Stats area of the Web Site Control Panel. The table on–screen shows the database queries generated during the present month. To examine information for an earlier month, simply click on the back arrows situated at the top.