Databases Manager

The Databases Manager in the Web Site Control Panel features a robust but still intuitive user interface. It’s possible to set up a whole new MySQL or PostgreSQL database by simply typing a user name and password. Also, you can create a backup file or alter the password of any database with a click of the mouse.

Via the Databases Manager you’ll have immediate access to the administration area for all of your databases, so you’re able to make effortless adjustments if you happen to need to.

If you have dealt with databases, you already know that generating a manual database back–up is simply not an elementary task. In order to change this, we’ve created an easy to understand tool that can back up your complete database with merely a single click. The back–up file is going to be set for you in less than a minute, depending on the size of the selected database.

You won’t notice any limits on the actual number of copies you may make for any specific database.

Almost all of Oro Hosting’s shared hosting plans provide PgSQL support. While falling behind MySQL when it comes to acceptance and application, PgSQL databases are famous for delivering the top level of safety for your site content. That is the reason why companies such as Skype and Yahoo rely on PgSQL databases instead of MySQL.

When considering database administration, PgSQL is as hassle–free as MySQL.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is designed for big database websites that require high levels of performance and scalability. Tests have revealed that web sites using InnoDB based tables attain a 3–fold efficiency increase for very big joins, as compared to those applying MyISAM tables.

InnoDB uses row–level locking in an effort to get rid of the effectiveness problems observed at the maximum consumption times of the earlier version of the database engine – MyISAM, which uses table–level locking.

We offer you a surprisingly simple solution to observe the database consumption for your powerful websites. Via the thorough database statistics interface, which is built into the Web Site Control Panel, you can easily record the load produced through your dynamic web sites in real time. The provided data will let you analyze the database load changes on an hourly basis, every day or per month.

You are able to observe the database load for all of your sites from the Database Stats part of the Web Site Control Panel. The table onscreen features the database lookups created in the present month. To check data for an earlier month, click on the back arrows located at the top.