Databases Manager

Taking control of your databases is simpler than before, as a result of Web Hosting Control Panel user interface for MySQL and PgSQL management! In case you do not have extensive knowledge in handling databases, you will find it easy to work with our Databases Manager.

You can make a brand new database merely by specifying the username and security password or generate a database back–up with only a mouse click. Additionally, with the Data Manager you’ll possess direct access to the administration area for every database, so that you can effortlessly edit it.

With the Databases Manager you can make an archived copy of your database anytime you need! This way, you’ll always have a back–up of your active content if your web site gets hacked or if you erroneously get rid of a database. To produce a back–up: click the ’clock’ image alongside a certain database and afterwards just wait for a couple of seconds for the process to be finished.

There are not any confines about the number of databases you would be able to back up or the number of back–ups you can make for a database.

Practically all of the Linux cloud hosting packages bundles present PgSQL support. Although dropping behind MySQL in terms of level of popularity and usage, PgSQL databases are famous for providing the best level of security for your web site content material. That is the key reason why companies like Skype and Yahoo employ PgSQL databases rather than MySQL.

In terms of database administration, PgSQL is just as simple and easy as MySQL.

We have added InnoDB – the new default MySQL database engine on each of our machines. InnoDB is made for sizeable database sites that demand high efficiency and scalability. Tests have shown that websites making use of InnoDB based tables achieve a 3–fold performance grow for substantial joins, in comparison with those making use of MyISAM tables.

InnoDB makes use of row–level locking in order to clear away the performance issues observed at the top usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

From your all–inclusive database stats tool built into the Web Hosting Control Panel, you are going to be able to keep track of the stress accumulated from your active sites 24 x 365. Every single overload difficulty with your web sites could lower the loading rates and have a damaging influence over the overall experience of your site visitors. Consequently, having information for the database load instantly, it will be straightforward to solve overload troubles immediately.

The database stats interface displays details of the quantity of daily, hourly and monthly queries, meaning you can examine how the load is allocated over several periods of time.