Database Manager

Managing your databases is less complicated than ever before, on account of the Control Panel interface for MySQL and PgSQL control! Assuming you do not have considerable knowledge in dealing with databases, you will find it effortless to use the Database Manager.

You can create a whole new database merely by specifying the username and password or produce a database back–up with only a click of the mouse. At the same time, from the Data Manager you will get direct access to the admin area for every single database, which means you can almost instantly alter it.

With the Database Manager it is easy to make an archived copy of your database whenever you wish! This way, you are going to always have a data backup of your dynamic content material if your site gets hacked or if you incorrectly erase a database. To make a back–up: click on the ’clock’ image beside a given database and after that just wait for a couple of seconds for the process to be completed.

There aren’t any limitations about the volume of databases you are able to back up or the number of backup copies you can make for any database.

You will find PgSQL support in every one of our Linux shared packages offers. PgSQL databases might not be as famous and widely used as MySQL, however they supply you with the top level of stability for your web site content and articles. Because of this, a lot of well–known companies such as Skype and Yahoo use PgSQL databases. Dealing with PgSQL databases is as easy and simple as MySQL, on account of the user–friendly interface of the Database Manager.

PgSQL databases are incorporated by default within the most sophisticated web hosting bundles. For the standard bundles, they are included as upgrades.

We have incorporated InnoDB – the brand new standard MySQL database engine on each of our machines. InnoDB is designed for substantial database web sites that require high general performance and scalability. Experiments have demonstrated that sites using InnoDB based tables attain a 3–fold overall performance grow for significant joins, as compared with those making use of MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate efficiency issues witnessed at the top usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Our company offers you a very easy technique to observe the database use on your dynamic web sites. Through the detailed database statistics interface, which is built into the Control Panel, you can easily keep an eye on the load generated by your active websites in real time. The presented info will enable you to evaluate the database load variations every hour, every day or per month.

It’s possible to keep an eye on the database load for all of your web sites in the Database Stats section of the Control Panel. The table onscreen reveals the database lookups generated in the present month. To examine information and facts for an earlier month, all you have to do is click on the back arrows positioned at the top.