Databases Manager

Administering your databases is easier than in the past, on account of the Web Control Panel user interface for MySQL and PgSQL administration! Provided you do not have extensive experience in making use of databases, you will find it effortless to deal with our Databases Manager.

You could make a brand new database by only specifying the username and security password or make a database back–up with a mouse click. Furthermore, from the Data Manager you have direct access to the administration area for each individual database, so you’re able to immediately alter it.

If you have dealt with databases, you already know that making a manual database back–up isn’t a basic job. So as to change this, we have made an easy to understand tool that can back up the entire database with merely a single mouse click. The data backup file shall be all set for you in under a minute, based on the size of the chosen database.

There won’t be any limits on how many backup copies you could make for a selected database.

You will find PgSQL support in all of our cloud hosting plans offers. PgSQL databases aren’t as well–known and widely used as MySQL, but they provide the best level of security for your web site content and articles. Because of this, a lot of popular brands like Skype and Yahoo utilize PgSQL databases. Maintaining PgSQL databases is as easy and simple as MySQL, because of the intuitive interface of the Databases Manager.

PgSQL databases are provided by default inside of the most innovative web hosting packages. For the normal packages, they are presented as upgrades.

We have installed InnoDB – the brand new standard MySQL database engine on all of our web servers. InnoDB is great for large database sites which require high functionality and scalability. Tests have shown that sites working with InnoDB based tables attain a 3–fold functionality grow for big joins, in comparison with those using MyISAM tables.

InnoDB employs row–level locking in an effort to get rid of the general performance difficulties found at the top consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load produced by the databases on your dynamic website will let you stop all kinds of overload difficulties that can slow it down and chase away visitors. For this specific purpose, we have built in a thorough Database Stats tool inside the Web Control Panel. There you can get detailed info about the incoming requests to your databases for each hour, day and month.

Depending on the amount of daily and by the hour queries, you are able to find out what databases are being used the most as well as take measures to optimize their work.