Databases Manager

Managing your databases is simpler than ever before, on account of the Control Panel user interface for MySQL and PgSQL management! In case you do not have detailed experience of handling databases, it will be simple to handle our Databases Manager.

You can create a new database just by entering the username and security password or create a database backup with just a click of the mouse. Furthermore, via the Data Manager you have direct access to the administrative area for every single database, which means you can effectively update it.

Via the Databases Manager it is simple to make an archived backup of your database when you would like! That way, you will always have a data backup of your operating content if your web site gets hacked or if you mistakenly delete a database. To generate a backup: click on the ’clock’ image on the side of a certain database and afterwards wait for a couple of seconds for the backup process to be executed.

There are not any confines about the volume of databases you would be able to back up or the number of backups you can create for any database.

Almost all of Benznet’s shared hosting packages bundles present PgSQL support. Whilst dropping behind MySQL with regards to popularity and usage, PgSQL databases are renowned for supplying the maximum level of security for your web site content and articles. That’s the key reason why companies such as Skype and Yahoo rely on PgSQL databases instead of MySQL.

When considering database administration, PgSQL is just as simple as MySQL.

The MySQL databases on Benznet’s servers make use of the most recent version of the InnoDB storage engine. InnoDB has been intended to ensure the optimum efficiency for websites that work with massive volumes of data. It offers CPU efficiency that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, so that you can easily update/insert/create/alter/drop a couple of times for one "operation" of your web application. Moreover, it makes use of row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

We provide you a fairly easy method to keep an eye on the database consumption on your active websites. Via the descriptive database stats interface, which is integrated into the Control Panel, you can easily keep track of the load made through your active web sites in real time. The offered information will help you to assess the database load variations by the hour, on a daily basis or monthly.

You are able to record the database load for all your web sites through the Database Stats portion of the Control Panel. The table onscreen shows the database queries generated in the present month. To have a look at information for an earlier month, just click on the back arrows situated at the top.