Databases Manager

The Databases Manager inside the Hosting Control Panel incorporates a robust but still user–friendly and uncomplicated interface. You’ll be able to configure a completely new MySQL or PostgreSQL database by simply typing in a username and password. In addition, you could make a back–up file or customize the security password of an database with merely a mouse click.

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

Within the Databases Manager you can create an archived duplicate of your database anytime you need! Therefore, you are going to always have a backup of your dynamic content if your website gets hacked or you incorrectly get rid of a database. To make a back–up: click the ’clock’ symbol next to a given database and after that simply wait for a few seconds for the process to be executed.

There won’t be any limits about the quantity of databases you are able to back up or the number of backups you may make for a database.

Nearly all of the Linux website hosting bundles offer PgSQL support. Whilst dropping behind MySQL with respect to acceptance and employment, PgSQL databases are renowned for offering the highest level of stability for your website content material. That is the reason why brands like Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.

When it comes to database management, PgSQL is just as straightforward as MySQL.

We’ve incorporated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is ideal for significant database sites that need high levels of overall performance and scalability. Trials have revealed that web sites making use of InnoDB based tables reach a 3–fold functionality grow for massive joins, when compared with those employing MyISAM tables.

InnoDB works by using row–level locking as a way to get rid of the overall performance problems witnessed at the peak consumption times of the previous variant of the database engine – MyISAM, which employs table–level locking.

We offer you a surprisingly simple option to keep track of the database consumption for your powerful websites. From your in depth database statistics interface, that’s integrated into the Hosting Control Panel, you’ll be able to record the load created from your dynamic sites in real time. The offered details will let you evaluate the database load fluctuations per hour, each day or monthly.

It is easy to keep an eye on the database load for all your websites through the Database Stats section of the Hosting Control Panel. The table on–screen reveals the database queries made within the present month. To assess data for an earlier month, click on the back arrows located at the top.