Databases Manager

The Databases Manager inside the Web Control Panel contains a powerful nevertheless convenient–to–use user interface. It’s possible to set up a new MySQL or PostgreSQL database by just entering a user name and password. Furthermore, you may create a backup file or alter the security password of any database with simply a mouse click.

Within the Databases Manager you will get direct access to the administration area for every one of your databases, which means you can make simple and easy corrections in case you have to.

Provided you have worked with databases, you know that making a manual database backup just isn’t a simple job. As a way to change this, we’ve created an effortless to use tool that will back up the entire database with just one click of the mouse. The backup file shall be ready for you in under a minute, with respect to the size of the selected database.

There are no limits on just how many backups you may make for any selected database.

PgSQL databases are significantly less widespread as compared to the widespread MySQL databases. Having said that, they’re a preferred selection for web developers seeking the greatest safety for their web sites and applications. Thanks to the user–friendly Databases Manager integrated into the SupremeServer Hosting Control Panel, you can control all of your PostgreSQL databases with merely a click of the mouse.

You can find PgSQL databases bundled by default inside of the best Linux shared hosting packages. Provided that you are using a basic hosting package, it is possible to request PgSQL databases to be included in your account as upgrades.

With SupremeServer Hosting, you will invariably find the latest version of MySQL along with the default MySQL storage engine – InnoDB, installed.

InnoDB is more dependable as compared to the earlier storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it grants 100% transaction support. You’ll find, it utilizes row–level locking, as an alternative to MyISAM’s table–level locking, that would always trigger performance problems at high usage times.

From the all–inclusive database stats tool included in the Web Control Panel, it will be possible to make a record of the stress created by your busy sites twenty–four hours a day. Any overload trouble with your sites can reduce the loading speeds and have a damaging influence over the online experience of your site visitors. Which means that, having data about the database work right away, you are able to mend overload troubles immediately.

The database statistics interface reveals info of the volume of daily, hourly and monthly lookups, which enables you to review the way the load is allocated over several periods of time.