Databases Manager

Administering your databases is easier than in the past, because of the Web Site Control Panel interface for MySQL and PgSQL control! Even if you do not have extensive knowledge of working with databases, it will be very easy to use N2U’s Databases Manager.

You can create a whole new database just by keying in the user name and security password or generate a database back–up with simply a mouse click. Also, through the Data Manager you have direct access to the administration area for each individual database, so you can quite easily alter it.

Provided you have worked with databases, you are aware that generating a manual database backup is not an elementary task. So as to change this, we have developed an effortless to use tool that will back up your whole database with merely a single click. The backup file is going to be prepared for you in under a minute, depending on the size of the chosen database.

There won’t be any restrictions on the total number of copies you can create for a selected database.

A majority of our Linux cloud hosting bundles provide PgSQL support. Although dropping behind MySQL with regards to level of popularity and application, PgSQL databases are renowned for giving the greatest level of security for your site content. This is the reason why businesses like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

When it comes to database administration, PgSQL is equally effortless to use as MySQL.

With N2U, you will invariably discover the most up–to–date edition of MySQL and the default MySQL storage engine – InnoDB, installed.

InnoDB is much more secure when compared to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most of all – it offers full transaction support. Additionally, it makes use of row–level locking, in contrast to MyISAM’s table–level locking, that would always cause performance problems at peak usage occasions.

We supply you an easy way to keep an eye on the database usage on your busy websites. From the in–depth database statistics interface, which is incorporated into the Web Site Control Panel, you’re able to observe the load created from your dynamic web sites in real time. The displayed information will enable you to evaluate the database load variations on an hourly basis, each day or each month.

You can observe the database load for all of your web sites from the Database Stats section of the Web Site Control Panel. The table on–screen presents the database queries accumulated within the present month. To examine information and facts for a previous month, all you have to do is click on the back arrows placed at the top.