Database Manager

Database management might sound like a complicated job to new hosting customers, however with Studio Presence (Rups)’s Database Manager, it’s in fact quite simple! To configure a completely new database, you only have to enter your username and password. Database backups are only a mouse click away at the same time.People who want to explore their databases and then alter them can make use of the phpMyAdmin and phpPgAdmin tools.

From the Database Manager it is easy to make an archived copy of your database anytime you need! For this reason, you are going to always have a data backup of your active content if your web site gets hacked or you incorrectly erase a database. To create a backup: click on the ’clock’ image alongside a particular database and then wait for a couple of seconds for the process to be performed.

There aren’t any boundaries for the amount of databases you can back up or the amount of backup copies you can make for any database.

PgSQL databases are less common compared to the common MySQL databases. On the other hand, they’re a favorite choice for programmers seeking the uttermost safety for their sites and applications. Through the easy–to–use Database Manager built–into the Studio Presence (Rups) Control Panel, you can manage all of your PostgreSQL databases with just a click of the mouse.

You will find PgSQL databases provided automatically in the advanced Linux cloud web hosting packages. In case you are using a regular hosting package, it is easy to request PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on Studio Presence (Rups)’s machines employ the most current build of the InnoDB storage engine. InnoDB was developed to guarantee the maximum performance for websites that operate with massive amounts of data. It offers CPU effectiveness that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, which means you can update/insert/create/alter/drop several times for a single "operation" of your app. Moreover, it uses row–level locking rather than MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Tracking the load made by the databases in your powerful site will let you avoid all overload issues that can slow it down and ward off site visitors. Therefore, we have incorporated a complete Database Stats tool within the Control Panel. There you can get complete information about the incoming requests to your databases for every hour, day and month.

Depending on the number of daily and per hour queries, it’s possible to find out which databases are utilized the most and also consider procedures to optimize their load.