Databases Manager

Managing your databases is less complicated than before, on account of the Hosting Control Panel user interface for MySQL and PgSQL administration! Even though you may not have thorough knowledge in utilizing databases, you will find it an easy task to use our Databases Manager.

You can create a completely new database by just keying in the user name and password or create a database backup with merely a click of the mouse. In addition, within the Data Manager you will possess direct access to the administrator area for every database, to help you to quickly revise it.

We’ve transformed the manual database backup creation into a simple job. To do this: inside of the Databases Manager, click on the ’clock’ icon beside the database that you intend to back up and wait for a couple of seconds for the backup process to take place. Depending on the size of your database, the building of a back–up file will require between a couple of seconds and a minute.

You can create as many copies of a database as you would like. We’ve not set any boundaries on the quantity of databases you could back up either.

PgSQL databases are much less widespread than the widespread MySQL databases. Even so, they’re a favorite selection for developers who seek the best safety for their web sites and web applications. Via the easy–to–use Databases Manager built into the SystemShells.com Control Panel, you can administer your PostgreSQL databases with a click of the mouse.

You will find PgSQL databases provided automatically inside of the top Linux web hosting packages packages. Assuming that you are using a regular hosting package, you’ll be able to ask for PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on SystemShells.com’s web servers use the latest version of the InnoDB storage engine. InnoDB has been meant to ensure the optimum functionality for web sites that deal with large amounts of data. It provides CPU efficiency that could not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, meaning you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your app. Additionally, it employs row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

With the detailed database statistics tool integrated into the Hosting Control Panel, it’s possible to keep a record of the load generated through your busy web sites at any hour. Any overload problem with your sites could slow the loading rates and have a bad effect on the overall impression of your site visitors. Thus, having information for the database load instantly, it will be possible to eliminate overload troubles promptly.

The database statistics interface reveals data of the quantity of daily, hourly and monthly lookups, meaning you can analyze just how the load is distributed over various time frames.