Database Manager

Overseeing your databases is much easier than in the past, as a result of Hosting Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed experience in managing databases, it will be simple to handle NETCreator’s Database Manager.

You could make a new database simply by specifying the username and password or generate a database back–up with just a click of the mouse. Furthermore, with the Data Manager you’ll have direct access to the admin area for each and every database, allowing you to almost instantly modify it.

With the Database Manager you can easily generate an archived copy of your database anytime you need! Therefore, you are going to always have a back–up of your operating content in case your web site gets compromised or if you erroneously remove a database. To make a back–up: click the ’clock’ icon alongside any database and afterwards wait for a couple of seconds for the process to be concluded.

There won’t be any restrictions about the quantity of databases you would be able to back up or the quantity of back–ups you can make for a database.

Almost all of our Linux website hosting service packages provide PgSQL support. Whilst falling behind MySQL regarding acceptance and usage, PgSQL databases are renowned for delivering the top level of protection for your site content and articles. It is the primary reason why companies like Skype and Yahoo go with PgSQL databases as opposed to MySQL.

In relation to database management, PgSQL is as uncomplicated as MySQL.

We’ve set up InnoDB – the brand new standard MySQL database engine on our machines. InnoDB is good for big database sites which need high levels of functionality and scalability. Trials have demonstrated that web sites utilizing InnoDB based tables achieve a 3–fold efficiency boost for massive joins, compared to those applying MyISAM tables.

InnoDB makes use of row–level locking in order to be able to take away the efficiency issues detected at the peak usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

We offer you a straightforward option to keep an eye on the database use for your powerful sites. Via the in–depth database statistics user interface, that is integrated into the Hosting Control Panel, you are able to keep track of the load produced from your busy sites in real time. The provided info will assist you to evaluate the database load fluctuations per hour, each day or on a monthly basis.

It is easy to record the database load for your websites through the Database Stats portion of the Hosting Control Panel. The table onscreen features the database queries generated during the present month. To have a look at data for a past month, click on the back arrows placed at the top.