Databases Manager

The Databases Manager inside our Hosting Control Panel includes a refined nevertheless simplified user interface. It is easy to configure a brand new MySQL or PostgreSQL database by just typing a username and security password. Also, you could make a backup file or change the security password of the database with merely a mouse click.

Through the Databases Manager you’ll get immediate access to the administrative area for every one of your databases, so you’re able to make easy changes should you have to.

We’ve designed the manual database backup formation into a very easy task. To execute this: inside the Databases Manager, click on the ’clock’ symbol on the side of the database that you want to back up and afterwards wait around for a few seconds for the process to take place. With regards to the size of the database, the creation of a backup file will need somewhere between a couple of seconds and a minute.

You can create as many copies per database as you would like. We’ve not set any limits on the number of databases you can back up too.

PgSQL databases are significantly less widespread when compared to the standard MySQL databases. Nonetheless, they’re a favorite option for designers seeking the uttermost safety for their web sites and web apps. Through the user–friendly Databases Manager incorporated into the Pinkerton Hosting Control Panel, you can manage your PostgreSQL databases with simply a click of the mouse.

You’ll find PgSQL databases incorporated by default with the top Linux hosting packages. If you are with a standard hosting package, it is possible to ask for PgSQL databases to be included in your web hosting account as upgrades.

We have added InnoDB – the new default MySQL database engine on all our web servers. InnoDB is ideal for significant database websites that require high levels of general performance and scalability. Tests have established that sites making use of InnoDB based tables achieve a 3–fold efficiency increase for massive joins, when compared to those using MyISAM tables.

InnoDB works by using row–level locking in order to be able to remove the general performance issues observed at the high consumption times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

We offer you an effortless technique to keep track of the database use of your active websites. Through the in–depth database stats user interface, that’s incorporated into the Hosting Control Panel, you can easily track the load generated through your active sites in real time. The supplied info will assist you to evaluate the database load changes by the hour, each day or monthly.

You can keep track of the database load for all your websites from the Database Stats portion of the Hosting Control Panel. The table onscreen shows the database queries made in the present month. To examine information for an earlier month, all you have to do is click on the back arrows situated at the top.