Database Manager

The Database Manager within our Control Panel has a robust nevertheless convenient–to–use user interface. You can easily set up a new MySQL or PostgreSQL database simply by specifying a user name and password. Also, you can create a back–up file or customize the password of a database with merely a mouse click.

Within the Database Manager you’ll get immediate access to the admin area for all your databases, so its possible to make easy changes in the event you have to.

With the Database Manager you are able to create an archived duplicate of your database anytime you wish! That way, you are going to always have a back–up of your operating content if your website gets compromised or you erroneously erase a database. To produce a backup: click the ’clock’ symbol beside a certain database and afterwards simply wait for a couple of seconds for the process to be finalized.

There are not any restricts for the amount of databases you are able to back up or the volume of backups you can create for any database.

Almost all of our Linux website hosting packages bundles offer PgSQL support. Whilst dropping behind MySQL when it comes to reputation and employment, PgSQL databases are renowned for giving the maximum level of protection for your web site content and articles. This is the key reason why companies like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

In relation to database administration, PgSQL is as quick as MySQL.

With Web Kit Live, you will regularly find the newest edition of MySQL as well as the default MySQL storage engine – InnoDB, installed.

InnoDB is much more secure than the previous storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it provides full transaction support. You’ll find, it uses row–level locking, as opposed to MyISAM’s table–level locking, that seemed to result in efficiency problems at peak usage times.

We provide you a hassle–free option to keep an eye on the database utilization of your busy web sites. Through the thorough database stats user interface, that is included in the Control Panel, you’re able to track the load accumulated by your dynamic websites in real time. The displayed details will assist you to assess the database load changes every hour, on a daily basis or each month.

It is possible to keep an eye on the database load for your websites within the Database Stats section of the Control Panel. The table onscreen reveals the database queries generated within the present month. To assess information and facts for a previous month, just click on the back arrows located at the top.