Databases Manager

Taking control of your databases is much simpler than ever before, due to the Site Control Panel interface for MySQL and PgSQL management! In case you do not have detailed experience in utilizing databases, it will be effortless to deal with Clintonw.j. collins’s Databases Manager.

You may create a completely new database by merely entering the username and security password or create a database back–up with a click of the mouse. Likewise, with the Data Manager you will have direct access to the administrator area for each individual database, which means you can quite easily modify it.

From the Databases Manager it is easy to make an archived copy of your database when you wish! For this reason, you are going to always have a data backup of your dynamic content material if your web site gets hacked or if you erroneously remove a database. To produce a backup: click on the ’clock’ symbol beside a particular database and afterwards just wait for a couple of seconds for the process to be finalized.

There are no limits on the quantity of databases you can back up or the amount of backup copies you can create for any database.

Practically all of the Linux shared web hosting bundles present PgSQL support. While falling behind MySQL when considering level of popularity and utilization, PgSQL databases are famous for presenting the best level of security for your website content. It is the main reason why brands like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

In terms of database management, PgSQL is identically hassle–free as MySQL.

The MySQL databases on our web servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB is created to guarantee the max performance for websites that process large amounts of data. It grants CPU performance that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, which means that you are able to update/insert/create/alter/drop several times for one "operation" of your application. In addition, it employs row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Clintonw.j. collins offers you a pretty simple way for you to observe the database usage on your active websites. Via the in depth database stats interface, that is incorporated into the Site Control Panel, it is easy to keep track of the load made through your busy websites in real time. The supplied details will assist you to evaluate the database load fluctuations on an hourly basis, each day or monthly.

You’re able to keep an eye on the database load for your web sites from the Database Stats area of the Site Control Panel. The table onscreen reveals the database lookups accumulated during the present month. To assess data for an earlier month, simply click on the back arrows placed at the top.