Databases Manager

Administering your databases now is easier than ever, as a result of Web Hosting Control Panel interface for MySQL and PgSQL management! Assuming you do not have thorough experience in dealing with databases, you will find it effortless to handle Orange Hosting’s Databases Manager.

You may create a whole new database by simply entering the user name and password or create a database backup with a click of the mouse. Likewise, from the Data Manager you will possess direct access to the administrator area for each individual database, to help you to effortlessly revise it.

We’ve transformed the manual database back–up creation into a quite simple activity. To do so: in the Databases Manager, click on the ’clock’ image near the database that you plan to back up and afterwards hang on for a few seconds for the backup process to take place. Depending on the size of the database, the creation of the back–up file is going to take between a few seconds and a minute.

You can create as many backups of a database as you wish. We haven’t set any limitations about the quantity of databases that you could back up either.

PgSQL databases are significantly less common in comparison to the widespread MySQL databases. However, they represent a preferred selection for programmers seeking the finest security for their websites and applications. Due to the intuitive Databases Manager integrated into the Orange Hosting Control Panel, you can administer all your PostgreSQL databases with merely a mouse click.

You’re going to find PgSQL databases bundled by default in the advanced cloud hosting packages packages. In case you are using a standard hosting package, it’s possible to ask for PgSQL databases to be included in your web hosting account as upgrades.

With Orange Hosting, you’ll always find the most up–to–date edition of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more stable compared to the former storage engine’s version – MyISAM. It’s ACID–compliant and, best of all – it grants 100% transaction support. What’s more, it works by using row–level locking, instead of MyISAM’s table–level locking, that previously used to cause effectiveness issues at peak usage times.

Tracking the load generated by the databases for your busy web site will let you reduce all overload difficulties that could slow it down and ward off visitors. As a result, we’ve provided a thorough Database Stats tool within the Web Hosting Control Panel. There you can see broad information on the arriving requests to your databases for each hour, day and month.

Depending on the number of day–to–day and per hour queries, it will be easier to determine which databases are utilized the most and then take procedures to enhance their load.