Database Manager

Managing your databases is simpler than ever, due to the Web Hosting Control Panel user interface for MySQL and PgSQL control! In case you do not have in depth expertise in handling databases, it will be effortless to deal with Best Paid Hosting’s Database Manager.

You could make a completely new database by just entering the username and password or generate a database backup with simply a click of the mouse. Additionally, with the Data Manager you will get direct access to the management area for each database, so its possible to immediately revise it.

We’ve designed the manual database back–up formation into a simple task. To do so: in the Database Manager, click the ’clock’ image next to the database that you want to back up and then wait for a couple of seconds for the process to take place. Depending upon the size of your database, the generation of any back–up file is going to take between a couple of seconds and a minute.

You can create as many backups of a database as you want. We haven’t fixed any limitations for the number of databases that you can back up as well.

PgSQL databases are significantly less popular as opposed to the standard MySQL databases. However, they represent a favorite alternative for developers who seek the maximum security for their web sites and web applications. Because of the incredibly user–friendly Database Manager integrated into the Best Paid Hosting Control Panel, you can administer all your PostgreSQL databases with a click of the mouse.

You’re going to find PgSQL databases provided automatically in the advanced hosting packages. If you are using a regular hosting package, it is possible to ask for PgSQL databases to be added to your hosting account as upgrades.

We’ve set up InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is designed for huge database web sites which require high general performance and scalability. Trials have shown that websites utilizing InnoDB based tables reach a 3–fold performance grow for huge joins, as compared with those applying MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate the general performance issues noticed at the maximum consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

We supply you a straightforward way for you to observe the database consumption of your powerful sites. From your in–depth database statistics user interface, which is built into the Web Hosting Control Panel, you’ll be able to record the load generated through your dynamic websites in real time. The displayed information will help you to assess the database load changes per hour, on a daily basis or each month.

You are able to record the database load for all of your sites through the Database Stats portion of the Web Hosting Control Panel. The table on–screen presents the database lookups accumulated within the present month. To look at details for a past month, click on the back arrows placed at the top.