Database Manager

Supervising your databases now is easier than in the past, due to the Web Site Control Panel user interface for MySQL and PgSQL control! Assuming you do not have considerable experience in working with databases, it will be easy to work with the Database Manager.

You can make a new database by simply specifying the user name and security password or create a database back–up with only a mouse click. In addition, with the Data Manager you will have direct access to the admin area for each and every database, allowing you to immediately manage it.

With the Database Manager it is easy to generate an archived copy of your database whenever you need! Therefore, you are going to always have a backup of your operating information in case your site gets hacked or if you mistakenly get rid of a database. To produce a back–up: click the ’clock’ icon on the side of a particular database and after that just wait for a few seconds for the backup process to be finished.

There aren’t any confines about the amount of databases you would be able to back up or the volume of backups you can create for a database.

Most of RoviaWeb’s Linux shared website hosting packages bundles provide PgSQL support. Although dropping behind MySQL in terms of reputation and application, PgSQL databases are famous for offering up the greatest level of safety for your website content. It is the reason why businesses like Skype and Yahoo use PgSQL databases as opposed to MySQL.

With regards to database management, PgSQL is equally uncomplicated as MySQL.

With RoviaWeb, you shall invariably find the most recent release of MySQL as well as the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more reliable than the past storage engine’s edition – MyISAM. It’s ACID–compliant and, most of all – it includes full transaction support. Additionally, it takes advantage of row–level locking, as opposed to MyISAM’s table–level locking, that previously used to trigger efficiency problems at high usage times.

We supply you a hassle–free way for you to keep an eye on the database use of your active sites. Through the descriptive database stats interface, which is incorporated into the Web Site Control Panel, it’s possible to monitor the load produced from your busy web sites in real time. The provided data will enable you to assess the database load changes by the hour, per day or monthly.

You can keep an eye on the database load for your websites in the Database Stats part of the Web Site Control Panel. The table onscreen reveals the database lookups made during the present month. To inspect data for an earlier month, simply click on the back arrows situated at the top.