Database Manager

The Database Manager inside our Web Site Control Panel features an effective but user–friendly and uncomplicated user interface. You can set up a new MySQL or PostgreSQL database by simply specifying a username and password. Also, you could make a backup file or alter the password of a database with only a click of the mouse.

Through the Database Manager you’ll have direct access to the administrator area for every one of your databases, so that you can make simple adjustments should you need to.

We have designed the manual database backup creation into a very simple task. To do this: inside of the Database Manager, click on the ’clock’ icon on the side of the database that you want to back up and afterwards wait for a couple of seconds for the backup process to take place. With regards to the size of your database, the creation of a back–up file will require between a couple of seconds and a minute.

You can make as many backups per database as you desire. We have not fixed any restrictions about the amount of databases that you could back up either.

PgSQL databases are less widespread as compared to the well–known MySQL databases. Even so, they are a favorite choice for programmers who are looking for the greatest safety for their sites and apps. Because of the user–friendly Database Manager incorporated into the Website and Domain Hosting Gosport Control Panel, you can manage your PostgreSQL databases with a simple mouse click.

You are going to find PgSQL databases integrated by default with the top hosting packages. Assuming that you are with a basic hosting package, you’ll be able to ask for PgSQL databases to be added to your website hosting account as upgrades.

We’ve integrated InnoDB – the new standard MySQL database engine on our servers. InnoDB is made for big database websites that need high efficiency and scalability. Trials have established that websites employing InnoDB based tables attain a 3–fold efficiency increase for large joins, when compared to those applying MyISAM tables.

InnoDB takes advantage of row–level locking so as to clear away the general performance difficulties discovered at the peak consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load generated by the databases for your dynamic web site makes it possible to reduce any overload issues that can slow it down and chase away site visitors. Therefore, we have incorporated a in depth Database Stats tool into your Web Site Control Panel. There you can get in–depth info about the inbound requests to your databases for every hour, day and month.

In line with the volume of daily and per hour queries, you’re going to be able to find out which databases are employed the most and then take measures to enhance their load.