Databases Manager

The Databases Manager in the Web Control Panel boasts a refined but user–friendly and uncomplicated user interface. It is easy to configure a brand new MySQL or PostgreSQL database by simply typing a user name and password. Moreover, you can make a backup file or modify the security password of an database with just a mouse click.

With the Databases Manager you have immediate access to the admin area for each of your databases, allowing you to make easy corrections in case you have to.

In case you have worked with databases, you already know that creating a manual database backup is not a basic task. So as to change this, we have made an effortless to use tool that can back up your complete database with just one click. The backup file will be available for you in under a minute, based on the size of the chosen database.

There are no limits on the actual number of back–ups you could make for a chosen database.

PgSQL databases are much less sought after in comparison to the popular MySQL databases. On the other hand, they represent a preferred alternative for designers who are looking for the best security for their websites and applications. Through the user–friendly Databases Manager incorporated into the Oregon Computing Control Panel, you can administer your PostgreSQL databases with just a click of the mouse.

You will find PgSQL databases included by default with the advanced Linux cloud hosting packages. Provided that you are with a standard hosting package, it’s possible to ask for PgSQL databases to be added to your hosting account as upgrades.

We have installed InnoDB – the new default MySQL database engine on our web servers. InnoDB is ideal for huge database websites that need high levels of overall performance and scalability. Tests demonstrate that websites using InnoDB based tables reach a 3–fold functionality boost for big joins, in contrast to those applying MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate the functionality problems witnessed at the maximum consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

We provide you an uncomplicated method to track the database use on your dynamic web sites. Via the descriptive database stats user interface, which is built–into the Web Control Panel, it’s possible to record the load made through your dynamic web sites in real time. The offered details will help you evaluate the database load changes every hour, on a daily basis or monthly.

You’ll be able to keep track of the database load for all of your web sites through the Database Stats portion of the Web Control Panel. The table on–screen shows the database queries accumulated within the present month. To assess details for a previous month, simply click on the back arrows situated at the top.