Database Manager

Supervising your databases now is easier than ever before, due to the Control Panel user interface for MySQL and PgSQL control! Even though you may not have in depth experience of managing databases, it will be very easy to use the Database Manager.

You can create a brand new database just by keying in the user name and password or make a database backup with a click of the mouse. Likewise, with the Data Manager you will possess direct access to the administration area for every database, meaning you can quite easily update it.

From the Database Manager it is easy to generate an archived duplicate of your database whenever you need! For this reason, you will always have a back–up of your dynamic information if your site gets broken into or if you accidentally delete a database. To produce a back–up: click the ’clock’ symbol next to a certain database and then wait for a couple of seconds for the process to be done.

There are not any limitations for the quantity of databases you can back up or the quantity of backups you can make for a database.

Practically all of our Linux shared website hosting packages bundles feature PgSQL support. Whilst dropping behind MySQL regarding acceptance and application, PgSQL databases are famous for offering up the top level of stability for your site content and articles. That is the primary reason why companies like Skype and Yahoo rely on PgSQL databases and not MySQL.

In relation to database administration, PgSQL is just as easy to use as MySQL.

The MySQL databases on our machines make use of the most up–to–date build of the InnoDB storage engine. InnoDB is built to ensure the highest effectiveness for websites that deal with huge amounts of data. It offers CPU efficiency that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, so that you can update/insert/create/alter/drop a couple of times for one "operation" of your application. Also, it employs row–level locking rather than MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Keeping tabs on the load generated by the databases on your busy site will let you stop virtually any overload problems that can slow it down and chase away website visitors. For this reason, we’ve designed a complete Database Stats tool inside the Control Panel. There you can find detailed information about the arriving requests to your databases for each hour, day and month.

In line with the quantity of daily and hourly queries, it’s possible to find out which databases are used the most and also consider procedures to enhance their work.