Database Manager

The Database Manager within our Web Site Control Panel boasts a refined but still straightforward interface. It is easy to set up a whole new MySQL or PostgreSQL database by simply typing in a username and password. Moreover, you could make a backup file or customize the security password of the database with merely a mouse click.

Via the Database Manager you’ll possess immediate access to the administrative area for every one of your databases, which enables you to make simple and easy corrections should you need to.

We’ve made the manual database back–up creation into a quite simple activity. To execute this: in the Database Manager, click the ’clock’ image beside the database that you intend to back up and after that hang on for a few seconds for the process to take place. With regards to the size of the database, the creation of a backup file will require somewhere between a couple of seconds and a minute.

You can make as many backup copies per database as you want. We haven’t set any limits for the amount of databases you could back up as well.

PgSQL databases are less common as compared to the well–known MySQL databases. However, they’re a favored alternative for web developers who are looking for the uttermost security for their websites and web applications. Via the incredibly user–friendly Database Manager incorporated into the Supreme Web Servers Control Panel, you can control all your PostgreSQL databases with a simple mouse click.

Yow will discover PgSQL databases incorporated automatically within the advanced Linux shared web hosting packages. If you are using a regular hosting package, it’s possible to ask for PgSQL databases to be added in your website hosting account as upgrades.

With Supreme Web Servers, you will invariably discover the latest release of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more dependable than the past storage engine’s edition – MyISAM. It’s ACID–compliant and, most significantly – it offers complete transaction support. You’ll find, it employs row–level locking, as an alternative to MyISAM’s table–level locking, that would always trigger performance issues at peak usage periods.

Our company offers you a straightforward way to observe the database consumption on your dynamic sites. From the in depth database statistics interface, that’s integrated into the Web Site Control Panel, you are able to keep an eye on the load accumulated through your active sites in real time. The presented details will enable you to assess the database load changes per hour, daily or each month.

You’re able to keep an eye on the database load for all of your sites within the Database Stats area of the Web Site Control Panel. The table on–screen features the database lookups created within the present month. To assess information and facts for a past month, just click on the back arrows located at the top.