Databases Manager

Taking control of your databases is simpler than in the past, as a result of Control Panel interface for MySQL and PgSQL control! Provided you do not have in depth knowledge in making use of databases, it will be very easy to manage the Databases Manager.

You can create a completely new database simply by entering the user name and security password or create a database back–up with a simple mouse click. Also, within the Data Manager you will possess direct access to the administrator area for each database, allowing you to conveniently revise it.

With the Databases Manager it’s easy to produce an archived copy of your database when you wish! Therefore, you are going to always have a data backup of your dynamic content in case your web site gets compromised or if you accidentally get rid of a database. To create a backup: click on the ’clock’ icon alongside a given database and then simply wait for a couple of seconds for the backup process to be finished.

There won’t be any boundaries for the amount of databases you can back up or the amount of backup copies you may make for a database.

PgSQL databases are significantly less famous as opposed to the popular MySQL databases. Nevertheless, they are a preferred alternative for web developers seeking the ultimate safety for their web sites and apps. Through the incredibly user–friendly Databases Manager built–into the opnux Control Panel, you can administer your PostgreSQL databases with merely a click of the mouse.

You will find PgSQL databases provided automatically inside the best website hosting packages. Provided that you are with a standard hosting package, it is possible to ask for PgSQL databases to be included in your website hosting account as upgrades.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on all our servers. InnoDB is good for big database websites that require high levels of general performance and scalability. Trials have demonstrated that sites working with InnoDB based tables attain a 3–fold operation increase for large joins, in comparison with those using MyISAM tables.

InnoDB makes use of row–level locking in order to eliminate performance issues observed at the peak usage times of the earlier version of the database engine – MyISAM, which employs table–level locking.

Tracking the load caused by the databases for your powerful web site makes it possible to stop virtually any overload issues that can slow it down and chase away website visitors. Therefore, we have bundled a detailed Database Stats tool straight into the Control Panel. There you can get detailed info about the arriving requests to your databases for each hour, day and month.

Using the volume of day–to–day and by the hour queries, it’s possible to find out what databases are used the most and consider actions to enhance their work.