Database Manager

The Database Manager in the Hosting Control Panel boasts a robust nevertheless straightforward user interface. You are able to set up a completely new MySQL or PostgreSQL database by just typing a username and security password. Additionally, you may create a backup file or modify the security password of the database with just a mouse click.

From the Database Manager you’ll possess direct access to the administrative area for every one of your databases, which means you can make convenient corrections when you need to.

In case you have worked with databases, you know that creating a manual database backup isn’t a basic task. In an effort to change this, we’ve developed an easy to understand tool that will back up your whole database with merely one click of the mouse. The data backup file shall be prepared for you in less than a minute, depending on the size of the chosen database.

There aren’t any limits on the actual number of backups you could make for any specific database.

Most of hartmann Hosting’s hosting packages offer PgSQL support. Although dropping behind MySQL with regard to popularity and employment, PgSQL databases are renowned for supplying the maximum level of security for your web site content material. It is the basic reason why companies such as Skype and Yahoo rely on PgSQL databases and not MySQL.

With respect to database management, PgSQL is identically simple and easy as MySQL.

The MySQL databases on hartmann Hosting’s machines employ the newest version of the InnoDB storage engine. InnoDB was created to ensure the optimum performance for sites that operate with big amounts of data. It presents CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, meaning it is possible to update/insert/create/alter/drop many times for a single "operation" of your application. Furthermore, it utilizes row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Our company offers you a hassle–free solution to track the database usage of your active sites. From the thorough database statistics interface, that’s built–into the Hosting Control Panel, you’ll be able to keep an eye on the load accumulated from your dynamic websites in real time. The offered information will assist you to assess the database load variations every hour, every day or on a monthly basis.

You’re able to record the database load for all your websites through the Database Stats part of the Hosting Control Panel. The table on–screen shows the database lookups created in the present month. To look at details for a previous month, simply click on the back arrows positioned at the top.