Database Manager

Supervising your databases is simpler than in the past, as a result of Site Control Panel interface for MySQL and PgSQL management! Even if you do not have in depth knowledge in making use of databases, you will find it easy to handle the Database Manager.

You can create a completely new database simply by keying in the username and security password or produce a database backup with simply a click of the mouse. Furthermore, with the Data Manager you’ll have direct access to the administrator area for each individual database, meaning you can quite simply update it.

If you have dealt with databases, you know that making a manual database back–up isn’t a simple task. In an effort to change this, we have created an easy to understand tool that will back up your whole database with simply one mouse click. The backup file will be available for you in less than a minute, depending on the size of the selected database.

There won’t be any limitations on how many backups you may make for any particular database.

PgSQL databases are significantly less sought after as opposed to the popular MySQL databases. Then again, they represent a favored selection for web developers seeking the ultimate security for their sites and apps. Because of the incredibly user–friendly Database Manager integrated into the OntWeb.com Control Panel, you can control all of your PostgreSQL databases with just a click of the mouse.

You’re going to find PgSQL databases incorporated by default in the best Linux shared packages packages. If you are using a standard hosting package, you are able to ask for PgSQL databases to be added to your web hosting account as upgrades.

The MySQL databases on OntWeb.com’s web servers work with the most recent version of the InnoDB storage engine. InnoDB has been intended to ensure the highest possible effectiveness for sites that operate with significant amounts of data. It boasts CPU efficiency that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, so that you can easily update/insert/create/alter/drop a couple of times for a single "operation" of your app. Moreover, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Monitoring the load generated by the databases within your busy web site will help you prevent any sort of overload troubles that might slow it down and ward off website visitors. For that reason, we’ve built in a in–depth Database Stats tool directly into the Site Control Panel. There you can find complete information on the arriving requests to your databases for every hour, day and month.

In line with the quantity of daily and hourly queries, it will be easy to find out which databases are employed the most as well as consider measures to enhance their load.