Database Manager

The Database Manager inside our Control Panel boasts a robust but still uncomplicated interface. You are able to configure a completely new MySQL or PostgreSQL database by simply typing a username and password. Also, you can make a backup file or modify the security password of an database with a click of the mouse.

From the Database Manager you will get immediate access to the administrator area for every one of your databases, which enables you to make quick modifications if you ever have to.

We have changed the manual database back–up formation into a simple task. To do so: in the Database Manager, click on the ’clock’ image beside the database that you would like to back up and afterwards hang on for a couple of seconds for the backup process to take place. Depending on the size of the database, the building of a backup file will take between a few seconds and a minute.

You may create as many back–ups per database as you would like. We haven’t set any boundaries about the number of databases you can back up as well.

PgSQL databases are significantly less famous than the standard MySQL databases. Having said that, they’re a favorite option for designers who seek the uttermost safety for their sites and applications. Due to the user–friendly Database Manager included in the Topmark Services Control Panel, you can manage all of your PostgreSQL databases with only a click of the mouse.

Yow will discover PgSQL databases included by default in the best web hosting packages. Provided that you are using a basic hosting package, you can easily ask for PgSQL databases to be included in your account as upgrades.

The MySQL databases on Topmark Services’s machines employ the most recent release of the InnoDB storage engine. InnoDB is built to guarantee the optimum effectiveness for web sites that work with significant volumes of data. It offers CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means you are able to update/insert/create/alter/drop repeatedly for one "operation" of your web app. In addition, it uses row–level locking as an alternative for MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Our company offers you a simple way to keep tabs on the database use on your active sites. Via the descriptive database stats user interface, that’s included in the Control Panel, you are able to monitor the load made from your dynamic web sites in real time. The supplied info will allow you to analyze the database load fluctuations on an hourly basis, on a daily basis or on a monthly basis.

You can monitor the database load for all your websites within the Database Stats area of the Control Panel. The table onscreen features the database lookups accumulated in the present month. To take a look at info for an earlier month, click on the back arrows positioned at the top.