Database Manager

The Database Manager in our Website Control Panel comes with an effective but still simple to operate user interface. You’re able to configure a brand new MySQL or PostgreSQL database simply by specifying a username and security password. Additionally, you could make a back–up file or modify the security password of your database with simply a click of the mouse.

Via the Database Manager you have direct access to the administrator area for each of your databases, so its possible to make simple and easy modifications in the event you need to.

If you have dealt with databases, you know making a manual database backup is just not an elementary task. So as to change this, we have created an effortless to use tool that will back up the entire database with a single click. The data backup file is going to be prepared for you in less than a minute, depending upon the size of the chosen database.

There are no limitations on the actual number of backup copies you can make for a particular database.

Most of RSR Web Hosting’s Linux cloud hosting packages grant PgSQL support. Whilst dropping behind MySQL with regard to global recognition and employment, PgSQL databases are renowned for presenting the maximum level of security for your website content material. It is the basic reason why businesses like Skype and Yahoo make use of PgSQL databases and not MySQL.

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

The MySQL databases on our machines utilize the most recent build of the InnoDB storage engine. InnoDB is meant to guarantee the optimum effectiveness for websites that work with significant volumes of data. It boasts CPU effectiveness that could not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, meaning you’re able to update/insert/create/alter/drop a couple of times for a single "operation" of your application. At the same time, it uses row–level locking as an alternative to MyISAM’s table–level locking, that improves multi–user concurrency and performance.

RSR Web Hosting offers you an easy route to keep tabs on the database usage on your dynamic web sites. From the thorough database statistics interface, that is built into the Website Control Panel, it’s possible to observe the load created through your busy web sites in real time. The offered data will allow you to analyze the database load variations every hour, per day or monthly.

You’re able to keep an eye on the database load for all your websites from the Database Stats part of the Website Control Panel. The table onscreen shows the database queries generated within the present month. To inspect details for a past month, click on the back arrows located at the top.