Database Manager

The Database Manager in the Website Control Panel comes with a powerful but still user–friendly user interface. You’ll be able to set up a whole new MySQL or PostgreSQL database by simply entering a user name and security password. Furthermore, you can make a back–up file or modify the password of the database with merely a mouse click.

From the Database Manager you have immediate access to the management area for each of your databases, meaning you can make hassle–free modifications in case you need to.

We’ve transformed the manual database back–up formation into a very easy activity. To execute that: inside the Database Manager, click on the ’clock’ symbol near the database that you plan to back up and then wait for a few seconds for the backup process to take place. Depending upon the size of your database, the generation of a backup file is going to take between a few seconds and a minute.

You may create as many backup copies of a database as you desire. We have not set any boundaries about the number of databases you can back up as well.

PgSQL databases are significantly less popular than the popular MySQL databases. Having said that, they are a favored choice for web developers who are looking for the uttermost safety for their web sites and applications. Through the easy–to–use Database Manager built into the Rtt2 Control Panel, you can manage all your PostgreSQL databases with just a click of the mouse.

You are going to find PgSQL databases provided by default inside of the best Linux cloud website hosting packages. Provided that you are using a regular hosting package, you can ask for PgSQL databases to be added to your account as upgrades.

The MySQL databases on Rtt2’s web servers work with the most current build of the InnoDB storage engine. InnoDB is designed to ensure the highest possible effectiveness for websites that operate with large volumes of data. It grants CPU performance that can not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, so that it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your app. Furthermore, it takes advantage of row–level locking as a substitute for MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

We offer you a painless way for you to keep an eye on the database use on your powerful sites. From your thorough database statistics user interface, that’s built into the Website Control Panel, you can easily keep track of the load produced by your active websites in real time. The displayed info will help you evaluate the database load variations on an hourly basis, per day or on a monthly basis.

It’s possible to record the database load for all your websites through the Database Stats portion of the Website Control Panel. The table on–screen features the database lookups created during the present month. To look at info for a previous month, all you have to do is click on the back arrows placed at the top.